Active Product

Cardano on BigQuery

Query the entire Cardano blockchain with standard SQL. No nodes, no syncing, no infrastructure. Start with a free 5-day trial. Full access, granted automatically. No payment until you decide to continue.

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
Self-service identity management via BCA dashboard
Feature levels: Developer · Team · Enterprise

1 hr

Update cadence

Genesis

History depth

Per epoch

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
Google account email
Self-service identity management
Free 5-day trial — no payment to start

Start free trial →

then € 19 / month

Pay annually: € 209 — get 1 month free

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
Google account email and service accounts
Domain restriction enforced
Free 5-day trial — no payment to start

Start free trial →

then € 69 / month

Pay annually: € 759 — get 1 month free

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

How the trial works

Sign up, get access.

Checkout registers your account and collects billing details (email, business address, VAT if applicable) so an invoice can be prepared. IAM access is granted automatically — no waiting on us.

Full dataset, full features.

The trial is the real product, not a sample.

No charge during the trial.

Nothing is billed up front. If you continue, you'll receive an invoice.

5 days to evaluate.

Near the end we'll reach out — both to answer questions and for feedback. Need longer to test an integration? Contact us and we'll extend it.

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	Up to 10
Identity types	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 IAM read access to identities you register via the BCA dashboard. Developer: one Google account email. Team: up to 10 Google account emails and/or GCP service accounts.
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 on this site with tag: cardano-on-bigquery-deep-comparison

Resources

GitHub Repository

Open-source export and validation code

Schema Documentation

Full table and column reference

Schema Machine-readable

Machine-readable schema definitions intented for LLMs and AI agents to learn about the structure of the dataset and for writing queries.

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?

Start your free 5-day trial. Access is granted automatically — you'll be running SQL in minutes. No payment until you decide to continue.

Start free trial →