Skip to main content

Snowflake

Databases

Connect to Snowflake to read or write tables. Supports password auth and keypair auth (recommended for service accounts).

Authentication​

  • Password: username + password + account + warehouse + database + schema + role.
  • Keypair: username + account + warehouse + database + schema + role + private key (+ optional passphrase).

Supported actions​

  • Source: query a table or write a SELECT in script mode.
  • Load: Append, Replace, or Merge-by-key.
  • DB Script for multi-statement SQL.

Setup reference​

For provider-side setup (OAuth apps, redirect URIs, tenant-side permissions), follow the File hub setup guide and the Connections guide.