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

# Snowflake Datashare

> Access Dune's blockchain data through the Snowflake Marketplace

Access 1.5M+ blockchain tables across 100+ chains directly in your Snowflake environment.

## How It Works

Snowflake Datashare uses Snowflake's native data sharing capabilities to provide instant access to Dune's data:

* **Shared Storage**: Data lives in Dune's Snowflake account but appears as regular tables in your environment
* **Zero-Copy Sharing**: No data transfer fees or storage duplication - you only pay for compute
* **Live Updates**: Shared data automatically reflects our latest blockchain processing
* **Native Access**: Query using standard Snowflake SQL with full performance optimization

## Get Started

**Trial (Free):**

1. Go to [Dune on Snowflake Marketplace](https://app.snowflake.com/marketplace/providers/GZSVZMYSCO/Dune)
2. Click "Get" on any dataset for 30-day free trial
3. Start querying

**Production:** [Contact enterprise team](https://dune.com/enterprise) or email [datashares-sales@dune.com](mailto:datashares-sales@dune.com)

## Sharing Identifiers

Please provide your Snowflake data sharing account identifier so I can grant you access to a listing. To find this identifier log in to your Snowflake account and click at your user profile at the bottom of the screen > *Account* > *View account details* > Copy data sharing account identifier (you can view a visual path [here](https://docs.snowflake.com/en/alias/client/account-identifier-listing)). You can also run the following SQL command:

```sql theme={null}
SELECT CURRENT_ORGANIZATION_NAME() || '.' || CURRENT_ACCOUNT_NAME();
```

Then, share your identifier with me.

## Data Types

Blockchain data types are adapted for Snowflake:

### Addresses & Hashes

* `column_name` (VARBINARY) - use for queries (faster)
* `column_name_hex` (STRING) - for convenience

```sql theme={null}
-- Recommended:
WHERE hash = X'efb2e2c26974f72d9f3f04c693db73ecc679dd60'
-- Slower:
WHERE hash_hex = '0xefb2e2c26974f72d9f3f04c693db73ecc679dd60'
```

### Large Integers (uint256/int256)

* `column_name` (DOUBLE) - for most calculations
* `column_name_binary` (VARBINARY) - for exact precision

Use VARBINARY for exact matching (e.g., token IDs), DOUBLE for calculations.

If you need full precision when doing arithmetic, you must work with the VARBINARY field:

• You can convert the binary to `DECIMAL(38,0)` if you are fine with the smaller range (up to 38 digits vs. 78 for `UINT256`).

• Any values larger than `DECIMAL(38,0)` will overflow and must be handled as `NULL` or excluded.

Here is an example conversion query:

```sql theme={null}
select 
  IFF(
    SUBSTR(amount_raw, 1, 17) != TO_BINARY(REPEAT('0', 34), 'HEX'), -- check for overflow
    NULL, -- if overflow, return null
    TO_NUMBER(
      TO_VARCHAR(SUBSTR(amount_raw, 18, 15), 'HEX'),
      REPEAT('X', 30)
    )::NUMBER(38,0) -- convert last 15 bytes to decimal
  ) AS amount_raw_converted,
  amount_raw,
  amount,
  tx_hash
from prod_datashares.tokens.transfers
limit 100;
```

## Details

* **Freshness**: hourly or daily depending on requirements
* **Regions**: Available worldwide, contact us for specific region availability
* **Support**: [support@dune.com](mailto:support@dune.com) | [Discord](https://discord.gg/2VCqwzzF7u)