Integrations / Databases & Warehouses / Snowflake

Snowflake

A data source for your Jourier workspace. Enter the database address and a read-only login.

Set-up
Self-service
Credentials
Username and password
Modules
Custom builds
Vendor docs
docs.airbyte.com
Notes
Spec offers three pasteable auth options: username/password (chosen as default), RSA key-pair (private_key + optional passphrase), and a programmatic access token (single programmatic_access_token field). Worth supporting key-pair or the access token as alternatives since Snowflake is tightening plain-password auth for programmatic access. Optional schema field skipped as sync scoping.

What you need at hand

FieldWhere it comes from
Server URLThe host domain of the Snowflake instance; must include the account, region and cloud environment, and end with snowflakecomputing.com.
RoleThe Snowflake role created for this connection to use.
WarehouseThe warehouse created for this connection to use.
DatabaseThe database created for this connection to access.
UsernameThe username created to allow access to the database.
PasswordThe password associated with the username.

Connect Snowflake.

Pick it at sign-up, or add it later from the workspace. Free for a month.