#
Snowflake
This page contains the setup guide and reference information for the Snowflake source connector.
#
To Connect with Snowflake database
There are two options
- Username/Password
- OAuth 2.0
Additionally, you have to fill the details given below
- Source Name
- Host Account
- Role
- Warehouse
- Database
- Schema
- Jdbc url (optional)
#
Getting Started
#
Create a dedicated read-only user with access to the relevant schemas (Recommended but optional)
This step is optional but highly recommended to allow for better permission control and auditing. Alternatively, you can connect Datasource with an existing user in your database.
To create a dedicated database user, run the following commands against your database:
-- set variables (these need to be uppercase)
SET KURSAHA_ROLE = 'KURSAHA_ROLE';
SET KURSAHA_USERNAME = 'KURSAHA_USER';
-- set user password
SET KURSAHA_PASSWORD = '-password-';
BEGIN;
-- create Airbyte role
CREATE ROLE IF NOT EXISTS $KURSAHA_ROLE;
-- create Airbyte user
CREATE USER IF NOT EXISTS $KURSAHA_USERNAME
PASSWORD = $KURSAHA_PASSWORD
DEFAULT_ROLE = $KURSAHA_ROLE
-- grant Airbyte schema access
GRANT OWNERSHIP ON SCHEMA $KURSAHA_SCHEMA TO ROLE $KURSAHA_ROLE;
COMMIT;