Configure Compose

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

To configure the use of Compose with your Azure SQL DB OCF data source, go to the Compose tab on the Settings page of your Azure SQL DB OCF data source. For more details, see Configure Compose for OCF Data Sources.

Note

User impersonation in Compose with a kerberized account is not supported yet.

Create Tables and Views in Compose

To ensure the successful incremental MDE from Compose, use fully qualified table names when creating tables. For Alation to incrementally extract views created in Compose, both the service account connection JDBC URI and the Compose connection URI should include the database parameter. For more information on the URI format, see JDBC URI above.

Example SQL for CREATE TABLE:

CREATE TABLE <DATABASE>.<SCHEMA>.<TABLE> ({column properties});

Example SQL for CREATE VIEW:

USE <DATABASE>;
CREATE VIEW <SCHEMA>.<VIEW> AS {view condition};