dune.lens.profile_metadata - Dune Docs

Deprecation Notice: Lens data ingestion has been discontinued as of December 2025. Only historical data is available, and no new data will be added.

Table description

The dune.lens.profile_metadata table holds the profile metadata. If it does not pass metadata standards, it goes into the metadata_failed table. This holds stuff like name, bio, etc.

Table Schema

Column Name	Type	Description
id	integer	Auto-incrementing row identifier
profile_id	varbinary	Unique identifier of the Lens profile
name	varchar	Display name set by the profile owner
bio	varchar	Profile biography text
app	varchar	Application used to set the metadata
metadata_json	varchar	Raw JSON of the profile metadata
metadata_version	varchar	Version of the metadata standard used
metadata_uri	varchar	URI pointing to the metadata resource
metadata_snapshot_location_url	varchar	Snapshot storage URL for the metadata
profile_with_weights	varchar	Profile scoring or weighting data
profile_picture_snapshot_location_url	varchar	Snapshot storage URL for the profile picture
cover_picture_snapshot_location_url	varchar	Snapshot storage URL for the cover picture
transaction_executor	varbinary	Address that executed the metadata update transaction
tx_hash	varbinary	Transaction hash of the metadata update
block_hash	varbinary	Hash of the block containing the transaction
block_number	integer	Block number of the transaction
log_index	integer	Index of the event log within the transaction
tx_index	integer	Index of the transaction within the block
block_timestamp	timestamp	Timestamp of the block

Table Sample