Skip to main content
Version: 1.2.14

Snowflake Limitations

Input Table Characteristics (Especially for Snowflake Dynamic Table Integration):​

  • Physical Tables: When S2V is used in conjunction with features like Snowflake Dynamic Tables for downstream processing (e.g., building a Standardized Zone from a Raw Zone), the input tables S2V reads from (e.g., Raw Zone tables) must be actual Snowflake tables. External tables or views may not be suitable as Dynamic Tables rely on change tracking capabilities of base tables.
  • Change Tracking: For optimal performance and to enable incremental processing by downstream Dynamic Tables, change tracking should be enabled on these source Snowflake tables.
  • Full History: These source tables should ideally contain a full history of the data. This is important for potential rebuilds of downstream layers (like a Standardized Zone or the Data Vault itself) during deployments or recovery scenarios.