Skip to main content

What's Numia's Data Warehouse?

Numia's Data Warehouse is a real-time streaming of on-chain data into different Data Warehouse technologies. Our main partner is BigQuery, but we also can ingest data to any Database technologies. BigQuery provides access to this data via its SQL interface, Google Sheets, and Google Looker Studio—versatile tools for data analysis that influenced our decision to use it over other options.

We can index your L1 or L2 or build models on top of exisitng chains and make them available to you our your community.

Why BigQuery?​

  • Native Integration with Looker Studio: Create data visualizations and dashboards effortlessly.
  • Google Sheets Integration: Analyze data collaboratively in spreadsheets.
  • BigQuery API Access: Programmatically retrieve data for advanced workflows.
  • Data Joining Capabilities: Merge Numia’s data with other public or private datasets.
  • Python Driver Support: Connect BigQuery to Jupyter Notebooks for Python-based analysis.
Note

Google charges based on the amount of data processed by each query, regardless of computation power. Numia's raw data tables can be terabytes in size, but we regularly create smaller, optimized tables to reduce query costs. For tips on minimizing expenses, refer to the Optimze Queries page.

Other Databases​

While Numia's Data Warehouse is optimized for BigQuery, we understand that different organizations have varying infrastructure requirements and database preferences. If you're an L1 blockchain project or a company that needs on-chain data delivered to a different database system, Numia can accommodate your needs.

Numia supports exporting and delivering blockchain data to various database systems beyond BigQuery. We work with enterprises and blockchain projects to provide flexible data delivery solutions that integrate seamlessly with your existing data infrastructure.

Supported Databases:

  • ClickHouse - High-performance columnar database for analytical workloads
  • Snowflake - Cloud-based data warehousing platform
  • PostgreSQL - Powerful open-source relational database
  • MongoDB - Leading NoSQL document database
  • DuckDB - Fast in-process analytical database

If you're interested in receiving Numia's blockchain data in any of these database systems, please reach out to our team to discuss your specific requirements and use case.

Contact our team: