Mappings in advanced mode

• •You cannot read data in binary format.
• •You cannot read data from non-partitioned collections.
• •When you read boolean fields in a mapping, Boolean fields in an array are written as null in the target.
• •When you read string data, you cannot use in-out parameters in the advanced properties.
• •You cannot add multiple pipelines in a mapping.
• •The unique key that you specify when you create a container is not considered in a mapping.
• •When you read from Microsoft Azure Cosmos DB SQL API and write to Microsoft Azure Data Lake Storage Gen2, a zero-byte file is created in the target with other target files.
• •When you read from or write to Microsoft Azure Cosmos DB SQL API, ensure that the collection contains at least one document to infer the schema.
• •When you read data from a Microsoft Azure Synapse SQL and write data to Boolean fields in Microsoft Azure Cosmos DB SQL API, ensure that the data type of the source fields is Bit.
• •When you read from or write to Microsoft Azure Cosmos DB SQL API, ensure that the ID column in the source is mapped to the ID column in the target.
If the source does not have an ID column, use the Expression transformation to add an ID column and then run the mapping.
• •When you run a task that reads from Microsoft Azure Cosmos DB SQL API and writes to Microsoft Azure Data Lake Storage Gen2 in the verbose mode, the execution log shows the following error even though the task is successful:
java.lang.IllegalArgumentException: Failed to load any of the given libraries:[netty_tcnative_linux_x86_64, netty_tcnative_linux_x86_64_fedora, netty_tcnative_x86_64, netty_tcnative]
Ignore the message.
• •When you read from and write to Microsoft Azure Cosmos DB SQL API, any values of double data type in the source are written in exponential form in the target.
For example, 1234567 is written as 1.234567E6.
• •You cannot partially parameterize the advanced properties. For example, do not specify Add100.$$filtercolumn=8.