CentralMind/Gateway

--- title: 'Snowflake' --- Snowflake connector allows querying Snowflake data warehouse. ## Config Schema | Field | Type | Required | Description | |-------|------|----------|------------------------------| | type | string | yes | constant: `snowflake` | | account | string | yes | Snowflake account identifier | | database | string | yes | Database name | | user | string | yes | Username | | password | string | yes | Password | | warehouse | string | yes | Warehouse to use for queries | | schema | string | yes | Schema name | | role | string | yes | Role to assume | | conn_string | string | no | Direct connection string | ## Config example: ```yaml type: snowflake account: myaccount # Your Snowflake account identifier database: MYDB user: myuser password: secret warehouse: COMPUTE_WH # Warehouse to use for queries schema: PUBLIC # Schema name role: ACCOUNTADMIN # Role to assume ``` Or as alternative with direct connection string: ```yaml type: snowflake conn_string: myuser:secret@myaccount/MYDB/PUBLIC?warehouse=COMPUTE_WH&role=ACCOUNTADMIN ``` ## Dev Run only snowflake tests: ```bash $ cd gateway $ USE_TESTCONTAINERS=1 gotestsum --rerun-fails --format github-actions --packages="./connectors/snowflake/..." -- -timeout=30m ``` Or Run ```bash $ cd gateway $ make test-integration CONNECTOR=snowflake ```