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 all the SUCCESSFUL publication records, including Momoka publications; it also has a MIRROR|QUOTE|COMMENT|POST publication type, but the rest of the columns should explain itself. The definition of success to us is if it follows the metadata standard.
Table Schema
| Column Name | Type | Description |
|---|
| publication_id | varchar | Unique publication identifier (format: profileId-pubId) |
| contract_publication_id | varbinary | On-chain publication ID from the Lens Hub contract |
| publication_type | varchar | Type of publication: POST, COMMENT, MIRROR, or QUOTE |
| profile_id | varbinary | Profile ID of the publication author |
| content_uri | varchar | URI pointing to the publication content/metadata |
| parent_publication_id | varchar | Publication ID of the parent (for comments, quotes, mirrors) |
| root_publication_id | varchar | Publication ID of the root post in the thread |
| is_hidden | boolean | Whether the publication has been hidden |
| is_momoka | boolean | Whether the publication was posted via Momoka (off-chain DA layer) |
| momoka_proof | varchar | Momoka data availability proof (null for on-chain publications) |
| app | varchar | Application used to create the publication |
| gardener_flagged | boolean | Whether the publication was flagged by a gardener for moderation |
| transaction_executor | varbinary | Address that executed the publication transaction |
| tx_hash | varbinary | Transaction hash (null for Momoka publications) |
| 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 |
| is_comment_hidden_by_author | boolean | Whether a comment was hidden by the original post author |
Table Sample
