Snowflake@1
Snowflake@1 provider lets you read data from Snowflake, no additional drivers are needed.
This provider is in Preview! Any feedback is highly appreciated.
You can use the Feedback button in the bottom right corner of this site. It might speed up the preview phase. Thank you! 😻
Snowflake@1 provider works out-of-the-box, you don’t need any drivers installed.
Example
Data sources:
- Name: MySnowflakeDatabase
Provider: Snowflake@1
Connection string: "account=testaccount;user=%USER_NAME%;password=%PASSWORD%;db=testdb;schema=testschema;"
Notice you can use an environment variable instead of a real password or any other detail (enclose the environment variable name with percents). See How to work with Passwords. You can also hide the entire connection string in an environment variable like this:
Data sources:
- Name: MySnowflakeDatabase
Provider: Snowflake@1
Connection string: "%MY_CONNECTION_STRING%"
Details
This provider is built on top of Snowflake connector for .NET. Here you can find more details, including connection string options:
https://github.com/snowflakedb/snowflake-connector-net?tab=readme-ov-file#create-a-connection
Prerequisites
CAT already contains the underlying drivers out of the box, you don’t need to install any other prerequisites.