Limitations and considerations

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

General limitations

• Replication of tables with backslashes in their names (for example, SPECIAL\\TABLE\N) is not supported.
• When Bulk Loading is set as the loading method, the Transactional apply Change Processing mode is not supported.
• When using Snowpipe Streaming as the loading method, the following limitations apply:
  • As Snowpipe only supports INSERT operations, the Apply Changes replication option will not be available.
  • When the Store Changes replication option is enabled, changes can only be stored in Change tables, not in an Audit table.
  • The Batch optimized apply change processing mode is not supported.
  • Username and password authentication is not supported.
  • The XML subtype is not supported.
  • Stopping Store Changes replication during a transaction and resuming it after 30 days or more might cause duplicate records on target. Snowflake automatically deletes channels after 30 days.

Additional limitations when using Google Cloud Storage staging

• Applying changes to binary data types is not supported.

• Working in Unlimited LOB mode is not supported.