Microsoft Azure Cosmos DB SQL API source properties
You can use a Microsoft Azure Cosmos DB SQL API object as a source in a data loader task.
When you create a data loader task to read data from Microsoft Azure Cosmos DB SQL API, specify the Microsoft Azure Cosmos DB SQL API source properties and formatting options.
The following table describes the Microsoft Azure Cosmos DB SQL API source properties:
Property
Description
Connection
Name of the source connection.
Select a source connection or create a new connection.
Source Path
The path to the directory that contains the source data.
Default value is forward slash (/).
Rules and guidelines for primary key fields and watermark fields
When you read data from Microsoft Azure Cosmos DB SQL API, you can manually define the primary key fields. The default value is Primary key fields not required.
You cannot manually define the watermark fields. The default value is Watermark fields not required.
Formatting options
Select the format of the Microsoft Azure Cosmos DB SQL API file and configure the formatting options.
The following table describes the formatting options:
Property
Description
Formatting Type
Specifies the file format to read data from Microsoft Azure Cosmos DB SQL API.
Select one of the following options:
- None. Doesn't apply to a data loader task.
- JSON. To read JSON documents in a data loader task.