BigQuery Usage Examples

Learn how to interact with Lens Chain datasets using different programming languages and tools.

Python

Using the official Google Cloud client library:

from google.cloud import bigquery
# Initialize the clientclient = bigquery.Client()
# Query recent posts app, account, post_typesquery = """SELECT     app,    `lens-protocol-mainnet.post.FORMAT_HEX`(account) as account,    post_types,    timestampFROM `lens-protocol-mainnet.post.record` postORDER BY timestamp DESCLIMIT 5"""
# Execute the queryquery_job = client.query(query)
# Process resultsfor row in query_job:    print(f"App: {row.app}, {row.post_types} Posted by: {row.account}, Posted at: {row.timestamp}")

Node.js

Using the @google-cloud/bigquery package:

const {BigQuery} = require('@google-cloud/bigquery');
async function queryLens() {const bigquery = new BigQuery();
const query = `    SELECT         app,        `lens-protocol-mainnet.post.FORMAT_HEX`(account) as account,        post_types,`        timestamp    FROM `lens-protocol-mainnet.post.record` post    ORDER BY timestamp DESC    LIMIT 5`;
const [rows] = await bigquery.query(query);console.log('Latest 5 post types by accounts:', rows);}

REST API

Using the BigQuery REST API:

curl -X POST \-H "Authorization: Bearer $(gcloud auth print-access-token)" \-H "Content-Type: application/json" \https://bigquery.googleapis.com/bigquery/v2/projects/lens-public-data/queries \-d '{    "query": "SELECT `lens-protocol-mainnet.account.FORMAT_HEX`(account) as account_address, total_posts FROM `lens-protocol-mainnet.account`.post_summary ORDER BT total_posts DESC LIMIT 10""}'

Remember to handle authentication appropriately in your applications. For local development, you can use the Google Cloud CLI.