BigQuery Datashare

​

How It Works

• Cross-Project Sharing: Dune grants your project access to shared datasets containing our blockchain data
• Regional Replication: Data is replicated to your preferred region (US Central 1 or EU West 2)
• Native Integration: Shared datasets appear as regular BigQuery datasets in your project
• Automatic Sync: Fresh data arrives daily/hourly without manual intervention

​

Get Started

• GCP Project ID
• Preferred region (US Central 1 or EU West 2)
• Chains of interest

​

Sharing Identifiers

• Data Hub: Shared datasets appear in your project’s Data Hub
• Direct sharing: We grant access to specific dataset IDs in your project

​

Principal Types

​

Data Types

​

Addresses & Hashes

-- Query using BYTES
WHERE tx_hash = FROM_HEX('efb2e2c26974f72d9f3f04c693db73ecc679dd60')
-- Or STRING
WHERE tx_hash_hex = '0xefb2e2c26974f72d9f3f04c693db73ecc679dd60'

​

Large Integers

WHERE value > CAST('1000000000000000000000' AS BIGNUMERIC)

​

Event Logs

SELECT block_number, topics, data
FROM `project.ethereum.logs`
WHERE topics[OFFSET(0)] = FROM_HEX('ddf252ad...')

​

Query Optimization

• Use block_time in WHERE clauses for partitioning
• Select only needed columns
• Tables are clustered by common query patterns

​

Regions