How it works
import snowflake.connector
conn = snowflake.connector.connect(
account='xy12345.us-east-1',
user='username',
password='password',
host='localhostcomputing.com', # [✓] Use local compute
warehouse='COMPUTE_WH',
database='DEMO_DB'
)
cursor = conn.cursor()
cursor.execute("SELECT * FROM users")Python
Iceberg Metadata
DuckDB Compute
Filesystem Cache
SnowflakeDuckDB runs the query locally
01
Ingest Data
Create Iceberg tables to ingest your data with two way sync with Snowflake.
02
Transform Data
Transform data with SQL or use tools such as dbt and SQLMesh.
03
Analyze Data
Speed up your BI tools and reduce costs by using Spile as a cache layer on top of your Snowflake account.
04
Activate Data
Use Reverse ETL such as Hightouch and Census to load data from Snowflake to your favorite tools.