Does not know transactions for ddl-statements. Therefore, it can happen that structures may remain in an inconsistent state when an error occurs.
Loading of CLOBs and BLOBs into the Data Vault is currently not supported.
Data Viewer / Data Preview does not (fully) support tables/columns with CLOBs and BLOBs.
Missing dependencies metadata restricts data lineage calculation.
- Azure Synapse:
No Field length longer than 8000 bytes as large datatypes can not participate in column store index.
No transactions: Everything is running in auto-commit mode.
TimeTZ not loadable.
No FKs on synapse - no validation for referential integrity.
- Snowflake Source Connector:
Limitations with processing timestamps due to a handling issue in the JDBC Driver