BARRYBARRY
Documentation

Snowflake

Load into Snowflake.

Snowflake as a managed table sink for BARRY.

Capabilities: Sink

What it does

Loads into Snowflake by staging files and running COPY INTO, with append, overwrite and merge all supported. This is a self-contained sink — it owns staging and apply and needs no separate Output Format.

Configuration

  • Account
  • Warehouse
  • Database
  • Schema
  • Authentication — a Snowflake user with password, or key-pair authentication

Each transport targets schema.table; the database and schema come from the connection, the table name is per-transport.

Notes

Point the connection at a role with rights on the target schema and a warehouse sized for your load. Merge applies inserts, updates and deletes from a continuous CDC source.

See also Connections, Transports.