Short Answer: Possible, but you can only query Snowflake objects that are materialized as an (Apache) Iceberg table using duckdb.
Duckdb as a zero-copy layer
- Duckdb can serve as a zero-copy layer between your data
- This means that we can access data from Snowflake locally and integrate these with csv or parquet files stored locally or remotely.
- Rill can be integrated with duckdb
- Rill utilizes DuckDB’s speed and exploration on the fly, showcasing its ability to handle already “big” data sets such as the NYC dataset.
- Rill
- If deploying to RILL cloud
- https://docs.rilldata.com/reference/connectors/motherduck#:~:text=IF%20DEPLOYING%20TO%20RILL%20CLOUD