Includes data on all fields across entities and their metadata. Includes things like field types, available dropdown options, and formula definitions.
Name: fields_metadata
Grant access to the Snowflake share only to users who are authorized to view all
organization data. There are no per-user or per-role visibility filters applied at the
share level.
Columns
| Column | Description |
|---|
field_id | The field’s unique identifier |
entity_type | The entity type this field applies to |
id | The field’s API identifier |
name | The field’s name |
list_id | The ID of the list this field belongs to (null for non-list fields) |
field_type | The field’s type (enriched, global, list, relationship-intelligence) |
value_type | The underlying value type (text, number, date, etc.) |
enrichment_source | The source of the data in this field (if it is enriched) |
dropdown_options | Dropdown options for dropdown/status fields |
formula | Formula definition for formula fields |
last_updated_at | Timestamp when this record was last updated |
