Lens Network Public Datasets

The Lens Network public datasets provide comprehensive access to all public data through Google BigQuery. This enables developers, analysts, and researchers to query and analyze social data from the Lens ecosystem using standard SQL.

In our source most of the data are stored in their raw binary format. When syncing with BigQuery, we transform this byte data into hexadecimal strings with the format \x{string}.

To make the data Web3-friendly, we provide a public function called FORMAT_HEX that converts BigQuery's \x format to the standard Web3 0x format. Here's how to use it:

SELECT  address as original_address,  `lens-public-data.testnet_block_explorer_public.FORMAT_HEX`(address) as web3_formatted_addressFROM `lens-public-data.testnet_block_explorer_public.addresses`LIMIT 5;

This will return results like: