Limitations and considerations
The following limitations apply when using the Snowflake on AWS target endpoint in a Replicate task:
- 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.