---
title: Snowflake
description: Query R2 Data Catalog tables from Snowflake using a catalog integration.
image: https://developers.cloudflare.com/dev-products-preview.png
---

> Documentation Index  
> Fetch the complete documentation index at: https://developers.cloudflare.com/r2/llms.txt  
> Use this file to discover all available pages before exploring further.

[Skip to content](#%5Ftop) 

# Snowflake

**Last reviewed:**  about 1 year ago 

Below is an example of using [Snowflake ↗](https://docs.snowflake.com/en/user-guide/tables-iceberg-configure-catalog-integration-rest) to connect and query data from R2 Data Catalog (read-only).

## Prerequisites

* Sign up for a [Cloudflare account ↗](https://dash.cloudflare.com/sign-up/workers-and-pages).
* [Create an R2 bucket](https://developers.cloudflare.com/r2/buckets/create-buckets/) and [enable the data catalog](https://developers.cloudflare.com/r2/data-catalog/manage-catalogs/#enable-r2-data-catalog-on-a-bucket).
* [Create an R2 API token](https://developers.cloudflare.com/r2/api/tokens/) with both [R2 and data catalog permissions](https://developers.cloudflare.com/r2/api/tokens/#permissions).
* A [Snowflake ↗](https://www.snowflake.com/) account with the necessary privileges to create external volumes and catalog integrations.

## Example usage

In your Snowflake [SQL worksheet ↗](https://docs.snowflake.com/en/user-guide/ui-snowsight-worksheets-gs) or [notebook ↗](https://docs.snowflake.com/en/user-guide/ui-snowsight/notebooks), run the following commands:

```

-- Create a database (if you don't already have one) to organize your external data

CREATE DATABASE IF NOT EXISTS r2_example_db;


-- Create an external volume pointing to your R2 bucket

CREATE OR REPLACE EXTERNAL VOLUME ext_vol_r2

    STORAGE_LOCATIONS = (

        (

            NAME = 'my_r2_storage_location'

            STORAGE_PROVIDER = 'S3COMPAT'

            STORAGE_BASE_URL = 's3compat://<bucket-name>'

            CREDENTIALS = (

                AWS_KEY_ID = '<access_key>'

                AWS_SECRET_KEY = '<secret_access_key>'

            )

            STORAGE_ENDPOINT = '<account_id>.r2.cloudflarestorage.com'

        )

    )

    ALLOW_WRITES = FALSE;


-- Create a catalog integration for R2 Data Catalog (read-only)

CREATE OR REPLACE CATALOG INTEGRATION r2_data_catalog

    CATALOG_SOURCE = ICEBERG_REST

    TABLE_FORMAT = ICEBERG

    CATALOG_NAMESPACE = 'default'

    REST_CONFIG = (

        CATALOG_URI = '<catalog_uri>'

        CATALOG_NAME = '<warehouse_name>'

    )

    REST_AUTHENTICATION = (

        TYPE = BEARER

        BEARER_TOKEN = '<token>'

    )

    ENABLED = TRUE;


-- Create an Apache Iceberg table in your selected Snowflake database

CREATE ICEBERG TABLE my_iceberg_table

    CATALOG = 'r2_data_catalog'

    EXTERNAL_VOLUME = 'ext_vol_r2'

    CATALOG_TABLE_NAME = 'my_table';  -- Name of existing table in your R2 data catalog


-- Query your Iceberg table

SELECT * FROM my_iceberg_table;


```

```json
{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"item":{"@id":"/directory/","name":"Directory"}},{"@type":"ListItem","position":2,"item":{"@id":"/r2/","name":"R2"}},{"@type":"ListItem","position":3,"item":{"@id":"/r2/data-catalog/","name":"R2 Data Catalog"}},{"@type":"ListItem","position":4,"item":{"@id":"/r2/data-catalog/config-examples/","name":"Connect to Iceberg engines"}},{"@type":"ListItem","position":5,"item":{"@id":"/r2/data-catalog/config-examples/snowflake/","name":"Snowflake"}}]}
```