Quick Start Guide
Get started with querying Lens Network data using BigQuery in minutes.
Prerequisites
Before you begin, ensure you have:
A Google Cloud account (Sign up here)
A Google Cloud project with billing enabled
BigQuery API access enabled
New Google Cloud users get $300 in free credits valid for 90 days. For current pricing details, visit the official BigQuery pricing page.
Setup Process
-
Go to Google Cloud Console
-
In the top navigation bar, click on the project dropdown menu
-
For a new project:
Click "New Project"
Enter a project name (e.g., "lens-analytics")
Optional: Select an organization and location
Click "CREATE"
-
For an existing project:
Click on the project selector
Use the search bar to find your project
Select the project from the list
Make sure you have sufficient permissions (Owner or Editor role) for the project you select.
Go to the Google Cloud Console Billing page
Select your project
Click "Link a billing account"
Either select an existing billing account or create a new one
Go to BigQuery API page
Click "Enable"
Open BigQuery Console
In the query editor, paste and run this query to explore a table's schema:
SELECT table_nameFROM `lens-public-data.testnet_block_explorer_public.INFORMATION_SCHEMA.TABLES`;Remember: Always verify your query's cost before running it by clicking the "Query Validation" button.