Tukui client .toc file formatting is incorrect.
Causeįor the schema-free connectors (the column number, column name and column data type of each row can be different when comparing with others), by default, ADF uses sample rows (for example, top 100 or 1000 rows data) to infer the schema, and the inferred result will be used as a schema to read data. When you want to use the ADF data flow to move or transfer data from Cosmos DB/JSON into other data stores, some columns of the source data may be missed.
#Tukui client .toc file formatting is incorrect. upgrade
Image 4: Upgrade the storage account to general purpose v2Īzure Cosmos DB and JSON format Support customized schemas in the source Symptoms If the account kind is Storage (general purpose v1), upgrade your storage account to the general purpose v2 or choose a different authentication. Image 3: Specify the storage account kind in the Azure Blob Storage linked service Furthermore, refer to Image 2 to get the storage account kind, and check and confirm the account kind is not Storage (general purpose v1).
If the storage account kind is None in the Azure Blob linked service, specify the proper account kind, and refer to Image 3 shown below to accomplish it. To solve this issue, refer to the following recommendations: Image 1: The account kind in the Azure Blob Storage linked service This situation is shown in Image 1 and Image 2 below. When you use the Azure Blob linked service in data flows, the managed identity or service principal authentication is not supported when the account kind is empty or "Storage". In data flows, if you use Azure Blob Storage (general purpose v1) with the service principal or MI authentication, you may encounter the following error message:Ĭom.: ServicePrincipal and MI auth are not supported if blob storage kind is Storage (general purpose v1) Cause Azure Blob Storage Account Storage type (general purpose v1) doesn't support service principal and MI authentication Symptoms This article explores troubleshooting methods related to connector and format for mapping data flows in Azure Data Factory (ADF).