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 existing chains and make them available to you or 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.
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.
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
Full Documentation
For detailed guides on querying data, available chains, and optimization tips: