KDQ Connections

Snowflake

SF_ACCOUNT

SF_USERNAME

SF_PASSWORD

SF_DB

SF_WAREHOUSE

SF_ROLE

– Keypair

SF_PASSPHRASE

SF_KEY

Using Password

snowflake://${SF_USERNAME}:${SF_PASSWORD}@${SF_ACCOUNT}/${SF_DB}?warehouse=${SF_WAREHOUSE}&role=${SF_ROLE}

Using Key Pair

snowflake://${SF_USERNAME}@${SF_ACCOUNT}/${SF_DATABASE}?key=${SF_KEY}&passphrase=${SF_PASSPHRASE}&role=${SF_ROLE}&warehouse=${SF_WAREHOUSE}

v1.2.0 includes support for Snowflake keypair

Azure SQL / SQL Server

SQLSERVER_HOST

SQLSERVER_DATABASE

SQLSERVER_USERNAME

SQLSERVER_PASSWORD

mssql+pyodbc:///?odbc_connect=DRIVER={ODBC Driver 18 for SQL Server};SERVER=${SQLSERVER_HOST};DATABASE=${SQLSERVER_DATABASE};UID=${SQLSERVER_USERNAME};PWD=${SQLSERVER_PASSWORD}

Azure Synapse

SQLSERVER_HOST

SQLSERVER_DATABASE

SQLSERVER_USERNAME

SQLSERVER_PASSWORD

mssql+pyodbc:///?odbc_connect=DRIVER={ODBC Driver 18 for SQL Server};SERVER=${SQLSERVER_HOST};DATABASE=${SQLSERVER_DATABASE};UID=${SQLSERVER_USERNAME};PWD=${SQLSERVER_PASSWORD}

Postgres

POSTGRES_USER

POSTGRES_PASSWORD

POSTGRES_HOST

POSTGRES_PORT

POSTGRES_DB

postgresql://${POSTGRES_USER}:${POSTGRES_PASSWORD}@${POSTGRES_HOST}:${POSTGRES_PORT}/${POSTGRES_DB}