Reputation: 31
Using Azure Data Factory, how to extract data from arrays in documents of DocumentDB to SQL Database
I need to extract arrays from documents in a DocumentDB and copy to SQL Database using Azure Data Factory..
I need to implement the same functionality of using jsonNodeReference and jsonPathDefinition in "Sample 2: cross apply multiple objects with the same pattern from array" of this article:
Upvotes: 0
Views: 1698
Answers (1)
Reputation: 24569
According to your mentioned File and compression formats supported by Azure Data Factory, it seems that it is not supported to extract data from documentdb to SQL database with Azure Data Factory Copy Activity currently. We could give our feedback to Azure document Team.
This topic applies to the following connectors: Amazon S3, Azure Blob, Azure Data Lake Store, File System, FTP, HDFS, HTTP, and SFTP.
But we also could use custom activities in an Azure Data Factory pipeline or Azure WebJob/Function with customized logic to do that.
Some related documents:
How to to Query Azure Cosmos DB resources
How to operate Azure SQL Database
Upvotes: 0
Related Questions
- Exporting data from Azure DocumentDB
- Selecting values from objects in document nested array in CosmosDB
- Is there a way to insert a document with a nested array in Azure Data Factory?
- Create an Azure Data Factory pipeline to copy new records from DocumentDB to Azure SQL
- Azure Cosmos DocumentDB - return array from 1 property in sub array
- How to import documents that have arrays with the Cosmos DB Data Migration Tool
- How to use Azure Data Factory to Unpivot json documents to SQL Database
- Unwind an array in DocumentDB query
- DocumentDB queries with arrays
- Select certain value in Array in Documentdb