> ## 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.profile_metadata

> Lens profile metadata — display names, bios, avatars, and profile attributes.

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

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