Use Snowflake with R2 to extend your global data lake
May 16, 2023Phillip Jones, Abhi Das
Summary
This post announces a partnership between Cloudflare R2 and Snowflake, enabling users to query data stored in R2 from Snowflake and load data from R2 into Snowflake. It provides step-by-step instructions for generating R2 API tokens and creating external stages in Snowflake using R2 credentials. It also demonstrates how to use the `COPY INTO` command for loading data and how to create external tables in Snowflake to query data in R2.
More from the Data Infrastructure & Analytics trail
- Introducing Cloudflare Basin: an open, serverless data platform, now generally available
- Introducing the Billable Usage API: programmatic cost visibility for Cloudflare
- Announcing the Monetization Gateway: charge for any resource behind Cloudflare via x402
- How we built Cloudflare's data platform and an AI agent on top of it
- Iran's Internet is partially restored, Cloudflare Radar data shows