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
Thedune.lens.publication_metadata table holds the publication content/metadata.
Table Schema
| Column Name | Type | Description |
|---|---|---|
| publication_id | varchar | Unique identifier of the publication (format: profileId-pubId) |
| metadata_snapshot_location_url | varchar | Snapshot storage URL for the metadata |
| metadata_json | varchar | Raw JSON of the publication metadata |
| metadata_version | varchar | Version of the metadata standard used |
| content | varchar | Text content of the publication |
| language | varchar | Language code of the publication content |
| region | varchar | Regional locale of the publication |
| content_warning | varchar | Content warning label if applicable (e.g. NSFW, SENSITIVE) |
| main_content_focus | varchar | Primary content type (e.g. TEXT_ONLY, IMAGE, VIDEO, ARTICLE) |
| tags_vector | varchar | Serialized array of tags associated with the publication |
| hide_from_feed | boolean | Whether the publication should be hidden from feeds |
| is_encrypted | boolean | Whether the publication content is gated/encrypted |
| app | varchar | Application used to create the publication |
| tx_hash | varbinary | Transaction hash (null for Momoka publications) |
| timestamp | timestamp | Timestamp of the publication creation |
| created_at | timestamp | Timestamp when the record was created in the database |
| content_vector | varchar | Vector embedding of the content for similarity searches |