Question 1

Why export from a data warehouse into object storage?

Accepted Answer

Two reasons dominate. Handing data to something that cannot query the warehouse directly, whether that is a partner, a separate team, or a processing job that expects files. And keeping a durable record on your own retention terms, independent of what the warehouse holds. Because the export runs on a schedule rather than as a manual extract, the bucket reflects current state rather than whenever somebody last remembered to run it.

Question 2

Which format should I choose?

Accepted Answer

Parquet for anything that will be read by a query engine later, because it carries types and reads efficiently by column, so a downstream reader does not have to reinterpret every value. JSON Lines suits record by record processing and keeps nested values intact. CSV is the compatibility option and remains the right answer when the consumer expects it. Compression is not configurable, and Parquet uses the writer defaults.

Question 3

Can files be organised into dated folders?

Accepted Answer

Yes, through expressions rather than a partitioning setting. Output subfolders and file names are both expression evaluated, so a datetime expression produces date based paths automatically as runs happen. New configurations default the subfolder to the source connection name, which is a sensible starting point you can then change. This is path templating, so it is not the same as partitioning on a field value in the data.

Question 4

What affects cost and runtime on the Snowflake side?

Accepted Answer

Compute on the warehouse running the query, since Polytomic reads through ordinary SQL rather than a warehouse specific unload path. Narrowing the column list, filtering in the model, and keeping a usable tracking column all reduce how much gets scanned per run. A dedicated warehouse with auto suspend is the common recommendation, so export activity neither competes with analyst queries nor sits idle accruing cost.

Connect Snowflake with Google Cloud Storage

Connect Snowflake and Google Cloud Storage with Polytomic

Four output formats

Snapshots or a stable file

Service account authentication

Trusted by businesses worldwide

Step-by-step integration guide

Connect Snowflake in Polytomic

Connect Google Cloud Storage in Polytomic

Create a sync between Snowflake and Google Cloud Storage

Map fields and enable the sync

Frequently asked questions

The sync and ETL platform that does it all

Powerful data sync

Advanced analytics

Enterprise security

Easy setup

Ready to connect Snowflake with Google Cloud Storage?