Integrates DuckDB with Snowflake, allowing direct querying and management of Snowflake databases using Arrow ADBC drivers
Maintainer(s):
iqea-ai
Installing and Loading
INSTALL snowflake FROM community;
LOAD snowflake;
Example
-- Install and load the extension
INSTALL snowflake FROM community;
LOAD snowflake;
-- Create a Snowflake profile
CREATE SECRET my_snowflake_secret (
TYPE snowflake,
ACCOUNT 'your_account.snowflakecomputing.com',
USER 'your_username',
PASSWORD 'your_password',
DATABASE 'your_database',
WAREHOUSE 'your_warehouse'
);
-- Query Snowflake data using pass through query
SELECT * FROM snowflake_scan(
'SELECT * FROM customers WHERE state = ''CA''',
'my_snowflake_secret'
);
-- Attach Snowflake database for direct SQL access
ATTACH '' AS snow_db (TYPE snowflake, SECRET my_snowflake_secret, READ_ONLY);
SELECT * FROM snow_db.schema.customers WHERE state = 'CA';
About snowflake
This community-maintained extension allows DuckDB to connect to Snowflake using Arrow ADBC drivers. For detailed setup and usage instructions, visit the extension repository.
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| snowflake_scan | table | NULL | NULL | |
| snowflake_version | scalar | NULL | NULL |