[billythemaniam]

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.

[darth_avocado]

And the network ingress/egress costs are higher for cross account/region transfers.