Snowflake Data Sharing

Glassnode offers secure access to historical metrics data via Snowflake Marketplace private listings, allowing you to query our data directly in your own Snowflake environment.

Data Shares allow you to access the full history range of all our metrics without needing to ingest the data through the API, saving you a lot of time in builiding a client, managing ETLs and maintaining an data ingestion pipeline infrastructure.

What are Snowflake Listings?

We provide access to our metrics data through Snowflake listings, which allow you to use our data in your own Snowflake environment. Rather than setting up direct Snowflake Shares, we use the Snowflake Marketplace private listings approach to make our data easily accessible from any Snowflake region.

Getting Started

To access Glassnode's data through Snowflake listings, you'll need to provide Glassnode your account identifier

Step 1: Retrieving your account identifier

Follow Snowflake’s guide to get your organization and account name.

Step 2: Request Access

Share your account identifier with our team.

Step 3: Access Your Data

Once approved, you'll be able to access Glassnode's data directly in your Snowflake environment through the listing.

For a complete overview of available metrics, see our Metric Catalog.

Beta Feature: During the beta phase, data sharing includes only Bitcoin (BTC) on-chain data. Support for additional blockchains will be added as we expand this feature.

How to Access Glassnode Data

Once you've been approved for access, you'll receive an email notification to set up your data listing. Follow these steps:

1. Click the listing detail page link in the email notification you received:

   

   Email notification with listing detail page link

If you don't receive an email, you likely haven't configured email notifications in your Snowflake account. In this case, navigate directly to the Data Products > Private Sharing > Share with you section in the Snowflake UI, where you'll find the Glassnode listing ready for you to access.

1. Click the Get button on the listing page:

   

   Get button on listing page
2. Fill in your personal information in the form:

   

   Personal data form
3. Select your database name and role where the listing will be mapped in your Snowflake account:

   

   Database and role selection
4. Wait for initial replication. The first time you access the dataset, Snowflake will replicate the data to your account. You'll see the dataset in a Replicating state:

   ⚠️ Initial Replication Time: Initial replication can take up to an hour depending on the number of objects being shared. Please be patient during this initial setup phase.

5. Start querying your data. Once replication is complete, you can access the data as a normal database in Snowflake.

How to Consume Metrics

Once you have access to the Glassnode data listing in your Snowflake account, you can explore and query the available metrics:

1. Browse the catalog: You'll see a set of views in your database, with one view per metric and time resolution:

   

   Catalog view showing available metrics
2. View metric details: Click on any view and select View details to see a description of the metric, including its definition and available fields:

   

   View details showing metric description

Metrics Schema

Table names follow the pattern: {CATEGORY}__{METRIC_NAME}_{RESOLUTION}

Example: ADDRESSES__ACTIVE_COUNT_1MONTH

Each metric table follows a consistent schema structure with three types of fields:

Field Types

1. Timestamp Field

   • Always named TIMESTAMP

   • Represents the time of the data point

   • Type: Timestamp

2. Filter Fields

   • Used to segment and filter data

   • Follow the same naming convention as query parameters in our API

   • Common filter fields include:

     • A - Asset (e.g., BTC, ETH)

     • NETWORK - Network

     • Additional filters vary by metric

3. Value Fields

   • Contain the actual metric measurements

   • Always prefixed with V_ for metrics with multiple values

   • Single-value metrics use just V (without underscore)

   • Type: Typically Number

Example

The metric /addresses/active_count with 1-month resolution is stored in table ADDRESSES__ACTIVE_COUNT_1MONTH:

Name	Type	Description
TIMESTAMP	Timestamp	Time of the data point
A	Varchar	Asset (filter field)
V	Number	Number of active addresses (value field)

Latency

There is an approximate delay of about 10 minutes compared to our API.

Ready to get started? Contact our team to learn more about accessing our Snowflake listings.