Active Product

Cardano on BigQuery

Query the entire Cardano blockchain with standard SQL. No nodes, no syncing, no infrastructure.

SQL access to the full Cardano blockchain dataset in Google BigQuery
Sourced from cardano-db-sync, exported hourly, back-validated after every epoch
Access granted via Google Cloud IAM (service account or Google email)
Self-service identity management via BCA dashboard
Feature levels: Developer · Team · Enterprise

1 hr

Update cadence

Genesis

History depth

~5 days

Validation cycle

SQL

Query language

Plans

Tier 1

Developer

For individual developers and researchers who need SQL access to the full Cardano chain.

Full chain history
Hourly updates + epoch validation
1+1 managed GCP identities
Self-service identity management

Get Quote →

Tier 2

Team

For teams and companies that need multiple identities with domain-level access control.

Everything in Developer
Up to 10 managed GCP identities
Mixed identity types
Domain restriction enforced

Get Quote →

Tier 3

Enterprise

Custom deployment, dedicated dataset copies, SLAs, and tailored support. Available on request.

Everything in Team
Dedicated dataset in your GCP project
Custom update schedules
Priority support & SLA

Feature Matrix

Feature	Developer	Team
Full chain history (genesis to tip)	✓	✓
Hourly dataset updates	✓	✓
Epoch back-validation (hash comparison)	✓	✓
Validation & freshness dashboards	✓	✓
Schema documentation & example queries	✓	✓
Self-service identity management	✓	✓
Managed GCP identities	1+1	Up to 10
Identity types	Service account or Google email	Service accounts and/or Google emails
Domain restriction (no resell)	—	✓ Must be customer domain

Example Query

example.sqlBigQuery Standard SQL

-- Count transactions per epoch (last 10 epochs)
SELECT
  epoch_no,
  COUNT(*) AS tx_count
FROM
  `blockchain-analytics-392322.cardano_mainnet.tx`
WHERE
  epoch_no >= (SELECT MAX(epoch_no) FROM
    `blockchain-analytics-392322.cardano_mainnet.tx`) - 10
GROUP BY epoch_no
ORDER BY epoch_no DESC;

Built For

Analytics & BI

Connect Looker Studio, Metabase, Grafana, or Tableau directly to the dataset

Staking Research

Reward reconciliation, delegation flows, pool economics, and tax reporting

DApp Development

Query UTxO state, script interactions, metadata, and token movements at scale

Data Pipelines

ETL into data lakes, warehouses, or ML feature stores via BigQuery's export tools

Academic Research

Full-chain history accessible for on-chain economics, network science, governance studies

Audit & Compliance

Transaction tracing, address clustering, and forensic analysis with SQL

Requirements

Requirement	Details
GCP Account	Google Cloud account with the BigQuery API enabled
Billing	Active billing on your GCP project — BigQuery query costs are paid by you to Google
Access grant	BCA grants access via your GCP service account email or Google user account
Tooling	BigQuery console, `bq` CLI, any BigQuery client library, or BI tool with BigQuery connector

Data Scope

The dataset mirrors the complete cardano-db-sync relational schema. Tables are partitioned by epoch for cost-efficient querying.

Domain	What's covered
Blocks & Slots	Block headers, slot numbers, epoch boundaries, slot leaders, pool hashes
Transactions	Inputs, outputs, fees, collateral, validity intervals, metadata
Staking	Delegations, rewards, pool registrations, retirements, stake addresses, withdrawals
Multi-Assets	Minting/burning events, policy IDs, asset names, token quantities
Scripts	Plutus scripts (V1/V2/V3), native scripts, redeemers, datums
Governance	Governance actions, votes, committee data (Conway era)

Back-Validation Pipeline

After every Cardano epoch boundary (~5 days), an automated validation pipeline ensures the BigQuery dataset is a faithful copy of the on-chain state.

Step 1

Hash Computation

Data hashes computed independently in canonical order on both PostgreSQL and BigQuery

Step 2

Cross-DB Compare

Hashes compared table by table; any divergence is flagged and prevents promotion

Step 3

Result Publishing

Comparison outcomes stored and made accessible via a public Looker Studio dashboard

Resources

GitHub Repository

Open-source export and validation code

Schema Documentation

Full table and column reference

Validation Results

Epoch-by-epoch hash comparison results

Freshness Dashboard

Live data update status

Related BCA Products

Product	Description
Cardano REST API	AI-ready HTTP endpoints for staking rewards, transactions, and UTxO data (coming soon)
Bitcoin REST API	AI-ready HTTP endpoints for Bitcoin blockchain data (coming soon)

Ready to query Cardano?

Choose a plan and get started. Setup takes minutes once access is granted.

Get Quote →