Limitations and considerations

The following limitations apply when using the Snowflake source endpoint in a Replicate task:

• Capture of changes from directory tables and external tables is not supported. Only standard tables and views are supported.
• Capture of DDL changes is not supported:
  • If the DDL introduces new metadata that did not previously exist, the DDL will be ignored and the task will continue. An example of such a change would be a column that is added to a source table after the task has started.
  • If the DDL is executed on a captured column or table, a table error will occur. An example of such a change would be a captured table that is dropped or renamed after the task has started.
• The Start processing changes from source change position advanced run option is not supported.
• Changes to tables with GEOGRAPHY and GEOMETRY data types will not be captured. The affected table(s) will be suspended.

• Replicate uses the CHANGES clause to capture changes. Therefore any Snowflake’s limitations related to the CHANGES clause will also apply to Replicate.

  For more information, see CHANGES.

• Homogeneous replication is not supported.
• STRING and BYTES columns without a specified size will be replicated to the target with their maximum size (16 GB for STRING and 8 GB for BYTES).