Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article describes how to configure advanced settings in a copy activity Mappings tab besides the basic settings introduced in Configure your mappings under mapping tab.
Configure your type conversion
Expand Type conversion settings to configure your type conversion if needed.
See the following table for the setting details.
| Setting | Description |
|---|---|
| Allow data truncation | Allow data truncation when converting source data to destination with different type during copy. For example, from decimal to integer, from DatetimeOffset to Datetime. |
| Treat boolean as number | Treat boolean as number. For example, treat true as 1. |
| Date format | Format string when converting between dates and strings, for example "yyyy-MM-dd". For more information, see Custom date and time format strings. The date column can be read as date type for: • Amazon RDS for SQL Server • Azure SQL Database • Azure SQL Managed Instance • Azure Synapse Analytics • Delimited text format • Lakehouse Table • Parquet format • SQL server |
| DateTime format | Format string when converting between dates without time zone offset and strings. For example, "yyyy-MM-dd HH:mm:ss.fff". |
| DateTimeOffset format | Format string when converting between dates with time zone offset and strings. For example, "yyyy-MM-dd HH:mm:ss.fff zzz". |
| TimeSpan format | Format string when converting between time periods and strings. For example, "dd.hh:mm:ss". |
| Culture | Culture information to be used when convert types. For example, "en-us", "fr-fr". |
Configure your column flatten settings
Expand Column flatten settings to configure your column flatten if needed. Applies to the following connectors/formats:
- Azure Cosmos DB for NoSQL
- Azure Cosmos DB for MongoDB
- JSON
- Microsoft 365
- MongoDB
- MongoDB Atlas
- REST
- XML
See the following table for the setting details.
| Setting | Description |
|---|---|
| Treat array as string | Specify to treat array values as string. |
| Treat struct as string | Specify to treat struct values as string. |
| Flatten column delimiter | Specify the flatten column delimiter, and the default is .. This setting isn't available when you enable Treat struct as string. |