🔬
Product Docs
  • 👋Welcome to Web3 Analytics
  • Overview
    • ✨Features
    • 💡How does it work?
  • Fundamentals
    • 🛠️Getting set up
      • 📝Register an app
      • 🔧Install via NPM
      • 🔨Install via CDN
      • ⚙️Instrumenting your app
  • Product Guides
    • ❓Creating queries
    • 📊Making a dashboard
    • ✔️Sample apps
  • Technology
    • Why Web3 Analytics?
    • Front end instrumentation
    • Decentralized data network
    • Smart contract registry
    • Indexer
    • Dashboard builder
    • Source code
Powered by GitBook
On this page
  • Step 1 - Add a new query
  • Step 2 - Write your SQL
  • Step 3 - Run your query
  1. Product Guides

Creating queries

PreviousInstrumenting your appNextMaking a dashboard

Last updated 2 years ago

Step 1 - Add a new query

First, navigate to queries in the top nav and click '+' to add a new query.

Name your new query anything you like.

Step 2 - Write your SQL

All data is stored in the 'events' table, and the default query is:

SELECT * from events;

On queries you have created, a list of available fields and their datatype is shown to the left of the SQL editor.

Clicking on a field name will insert a reference to the field where your cursor is in the SQL editor.

Step 3 - Run your query

If you run your query, you can browse through results 100 records at a time. Your query is saved every time it is successfully run.

You can also filter the data or download it as a CSV file.

After adding a query, you will be redirected to the query page and able to customize your SQL query. Web3 Analytics uses the .

❓
Presto SQL syntax