Numia Partners with Secret Network to Bring SQL Access to On-Chain Data via BigQuery

Numia Data
3 min readFeb 27, 2024

--

Numia is thrilled to announce its latest partnership with SCRT Labs. This collaboration is set to enable developers and data scientists to access and utilize on-chain data for the Secret chain. By enabling universal and free SQL access to the data via the Google BigQuery analytics platform, this partnership promises to unlock a new realm of possibilities for data-driven projects within the Secret community.

The Partnership

At the heart of this partnership is a shared vision to enhance blockchain data accessibility and utility. Numia and Secret want to offer unprecedented access to on-chain data through SQL queries. This initiative is not just about simplifying data access; it’s about empowering developers and data scientists to explore, analyze, and innovate like never before.

Empowering Access with SQL via BigQuery

Numia’s indexing technology stores Cosmos SDK-based chains’ on-chain data into BigQuery (Google Cloud’s Datawarehouse). This process involves capturing and organizing real-time transaction data, smart contract interactions, and other relevant on-chain activities, making them readily queryable through BigQuery without losing the privacy offered by the Secret Network. This real-time data indexing is crucial for maintaining up-to-date datasets, enabling timely analyses and decision-making processes.

Developers and analysts can freely access this data through SQL, which with its widespread adoption and ease of use, allows for complex queries to be constructed and executed swiftly, making blockchain data more accessible and understandable. BigQuery’s robust data warehouse capabilities enable handling vast amounts of data easily, ensuring that insights are easy and fast to extract.

The only thing that is required to access the data is a Google account with access to BigQuery. No permission from Numia or SCRT Labs is required, and every developer can perform any query they want in full confidentiality. Google may charge for querying the data (see their pricing here), but the first terabyte of data per month is free, allowing for hundreds of queries.

Use Cases and Applications

The applications of this partnership are as diverse as they are impactful.

Developers can now

  • build dynamic dashboards that reflect current market trends
  • conduct deep-dive analyses into the efficiency of smart contracts,
  • or explore user behavior across decentralized applications (DApps).

Data scientists and analysts can

  • leverage this rich dataset to apply machine learning models,
  • predict market movements,
  • or identify emerging trends within the Secret Network.

These are just a few examples of how accessible, high-quality on-chain data can drive innovation and insight.

This partnership extends beyond technological advancements, aiming to empower the Secret community by democratizing data access. With tools and resources to explore on-chain data easily, community members can undertake their analyses, contribute to the ecosystem’s growth, and drive transparency within the blockchain space. This empowerment is expected to spur community-driven projects, research initiatives, and collaborations that further the Secret chain’s adoption and utility.

How to Get Started

Getting started is straightforward for developers, analysts, and data scientists eager to dive into the Secret chain’s on-chain data. Numia provides detailed documentation, guides, and support channels to help users navigate the process of accessing and querying data via BigQuery. Whether you’re looking to analyze transaction patterns, explore DApp usage, or build predictive models, the resources are in place to support your endeavors.

--

--