Snowflake Agent for Gluesync: Target Integration
Core principles
This agent establishes a connection to Snowflake via the Snowflake JDBC driver leveraging Apache Arrow for the CDC process and the Snowpipe API for the snapshot process to provided an enhanced performance.
Platform supported features
| Feature | Support | Notes |
|---|---|---|
Target role |
✅ |
Writes to Snowflake via the official JDBC driver with Apache Arrow optimizations. |
Source role |
❌ |
Snowflake is supported as a target only. |
Snapshots |
✅ |
Snapshot batches are uploaded through Snowpipe APIs for rapid ingestion. |
CDC |
❌ |
This agent does not currently support reading incremental changes from Snowflake. |
CDC type |
N/A |
This agent does not currently support reading incremental changes from Snowflake. |
Bulk load |
✅ |
Supports staging-table Bulk load workflows with COPY INTO / Snowpipe. |
Source persisted internal cache |
N/A |
Target-only connector. |
Target persisted internal cache |
N/A |
Files are staged in Snowflake-managed storage during load jobs. |
Driver / connector |
Snowflake JDBC driver + Apache Arrow |
Bundled driver leverages Arrow for high-throughput writes. |
Chains |
N/A |
Not supported being a target-only connector. |
Truncate operation support (reading) |
N/A |
Target-only connector. |
Truncate operation support (writing) |
✅ |
Supports “TRUNCATE before snapshot” via Snowflake SQL commands when enabled. |