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
This 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
