Limitations and Troubleshooting¶
Alation Cloud Service Applies to Alation Cloud Service instances of Alation
Enhanced Connector Enhanced connectors add extended capabilities and require a separate entitlement in addition to your Alation platform license.
Limitations¶
If the transformation or orchestration job contains a query that has a two-part name (schema.table) for 3-part (catalog.schema.table) Alation-supported datasources, then lineage will not appear. Because Alation supports 3-part schema names and thus cannot resolve the lineage.
Cross-system lineage will not be generated for queries that contain square brackets or non-standard SQL queries due to parsing issue on Matillion side.
Troubleshooting¶
For information about logs, refer to Troubleshoot OCF Connectors.
Find specific troubleshooting scenarios below:
Long Runtime During Lineage Extraction¶
Problem¶
Lineage extraction from Matillion is taking a long time to complete.
Solution¶
Lineage extraction duration can be delayed if the lineage lookback (days) is set to a high value. By default lookback time set to 30 days, you can set this to lower days and schedule an extraction.
Cross-Source Lineage Fails to Generate¶
Problem¶
Cross-source lineage is not generated after configuring Matillion lineage settings.
Solution¶
Cross-source lineage generation fails if the hostname and port do not match between Matillion and Alation data source configuration. Ensure that the host and port information in the Additional Datasource Connections field matches the Matillion configuration. For more information, refer to Configure Lineage Across Data Sources in Configure Lineage.