Querying Numia Datasets

1. Pin numia-data to your datasets

Bigquery uses projects to know what data you are querying. We have currently 2 projects:

• immaculate-355716 (Beta)

• numia-data (Production)

Please use numia-data as we will deprecate immaculate in the next months.

2. Query numia-data

Now that you have pinned our dataset to your google project you can start exploring the data set and start querying it. In order to do so you need to specify your query in the from clause and tell it to query our project. The format is `project`.`dataset`.`table`

select * from numia-data.osmosis.osmosis_blocks

where:

• numia-data = project

• osmosis = dataset

• osmosis_blocks = table