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

Working in Unlimited LOB mode is not supported.