KDQ Connections

Snowflake

SF_ACCOUNT

SF_USERNAME

SF_PASSWORD

SF_DB

SF_WAREHOUSE

SF_ROLE

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

Update to allow Keypair is planned for an upcoming release (TBC)

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}