Re:Snowflake, Cloud Storage Giant, Suffers Breach
by billythemaniam on Saturday June 01, 2024 @08:40AM
(#40545254)
Yes, federated queries (external tables) are supported but that is a lot slower than ingesting the data into Snowflake's storage and querying it. Since Snowflake's pricing model is based on computation time, querying external tables are usually more costly because of worse performance.
Re:Snowflake, Cloud Storage Giant, Suffers Breach
by darth_avocado on Saturday June 01, 2024 @12:30PM
(#40547054)
And the network ingress/egress costs are higher for cross account/region transfers.
See https://docs.snowflake.com/en/user-guide/data-load-s3-config...
Personally believe this is the right approach as the data resides in a location fully under the company's control. You could ditch snowflake and the data still resides in your s3 buckets for reuse with a another platform (just remove the iam permissions for snowflake).