4 ms·
> While both BQ and Snowflake are adopting lake features, they still only support parquet and other file formats for loading, not for querying. This is not tru
by chrisjc 6y ago
> While both BQ and Snowflake are adopting lake features, they still only support parquet and other file formats for loading, not for querying.
This is not true. Snowflake allows you to create an external stage (pointer to s3) and then query any prefix you want as long as you provide the correct file format arguments or types.
select * from @somestage/someprefix file_format(....)
edit: hadn't refreshed the page and i can see others have already responded to this point.