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
