> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# dune.lens.publication_metadata

> Lens publication metadata — content type, tags, and media attachments for posts.

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

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

## Table description

The `dune.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              |

## Table Sample

<TableSample tableSchema="dune.lens" tableName="publication_metadata" />