Snowflake
Setting up the Snowflake connector
| No | Item | Required | Example | Notes |
|---|---|---|---|---|
| 1 | Authorization Method | Yes | Refer to the documentation in the form while using the connector OAuth2.0Username and Password | |
| 2 | Account Name | Yes | accountname.us-east-2.aws.snowflakecomputing.com | The host domain of the snowflake instance (must include the account, region, cloud environment, and end with snowflakecomputing.com). |
| 3 | Role | Yes | AIRBYTE_ROLE | The role you created for Zipstack to access Snowflake. |
| 4 | Warehouse | Yes | AIRBYTE_WAREHOUSE | The warehouse you created for Zipstack to access data. |
| 5 | Database | Yes | AIRBYTE_DATABASE | The database you created for Zipstack to access data. |
| 6 | Schema | No | AIRBYTE_SCHEMA | The source Snowflake schema tables. Leave empty to access tables from multiple schemas. |
| 7 | JDBC URL Params | No | Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3). |
Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.