Azure Cosmos DB¶
Supported as Custom DB from version 2020.3
Scope of Support¶
Supported as Custom DB with a CData JDBC Driver for Cosmos DB. Please contact your Azure account manager to find out if this driver is included into your Azure solution.
Authentication with the Shared Key authorization
Cosmos DB Account APIs: SQL
Extraction of Stored Procedures is supported
Sampling and Profiling
Compose: support based on the CData driver for Cosmos DB scope of support for SQL statements
QLI is not supported. Query history is ingested from Compose only. Lineage and Popularity are calculated based on the query history from Compose.
CData CosmosDB driver supports SELECT, INSERT, UPDATE, and DELETE statements. CREATE and DROP operations cannot be performed using SQL queries and need to be performed using an app. Please refer to MS Cosmos DB documentation for details.
Billable by Microsoft Azure on your Azure account:
The queries Alation runs on the connected Cosmos DB instance during MDE and Profiling
Queries run in Compose
JDBC driver used to connect to the database: CData Cosmos driver 2020
JDBC URI for the Cosmos DB data source
Azure Account Key for the Cosmos DB instance
Server-side access to Alation to place the driver on the Alation system
Construct the URI¶
The JDBC URI must be entered without the “JDBC” tag at the beginning:
Use the RTK parameter only if you have the RTK provided by Alation.
cosmosdb:AccountEndpoint="<Cosmos_DB_URL>";AccountKey="<Account_Key>";SupportsCatalogsInTableDefinitions=True;SupportsSchemasInTableDefinitions=True;SupportsCatalogsInTableDefinitions=True; and SupportsSchemasInTableDefinitions=True;RTK=<RTK_Code>
For the other URI parameters that support specific cases, please refer to the CData Driver documentation: Connection String Options.
Azure Account Key
Add the driver to the Alation server before adding your Cosmos DB source to the Catalog.
Add the CData Driver to Alation¶
Steps in Alation¶
To add a Cosmos DB data source to the Catalog,
On the Sources page, add a new data source. Provide a title and proceed to the Add Data Source wizard.
On the Add a Data Source screen of the wizard, specify:
Database Type: Custom DB
JDBC URI: Use the required format. See Construct the URI.
Select Driver: select the CData driver for Cosmos DB that you have added to Alation:
Privacy: Public or Private
Click Save and Continue:
On the next screen - Set Up a Service Account - select Yes, then in the Username field, type
User(or any other string) and click Save and Continue. As the Account Key is included into the URI, there is no need to provide this information on this screen.
On the next screen - Configure Data Source - click Skip This Step.
After this step, you are navigated to the Settings page of the new data source.
Configure the Cosmos DB Data Source¶
Complete the configuration on the Settings page and perform MDE and Profiling:
Access: configure access and Privacy settings.
General Settings: verify the connection parameters and connection status.
Custom Settings: Set the Catalog Object Definition for MDE. Use the Catalog.Table option for this data source. Without the Catalog Object Definition set, the object names will include the CData prefix.
Metadata Extraction: configure and perform MDE.
Data Profiling (Data Sampling): configure and perform Sampling and Profiling.
Logs to collect/review:
For logs related to MDE: taskserver.log, taskserver_err.log.
For logs related to Compose: connector.log, connector_err.log
For any other errors: alation-error.log, alation-debug.log