In Snowflake, you can setup data shares to allow other organizations to access data in the data warehouse. This allows an easy way to query data inside CircleCI without hammering the API with complicated ETL processes.