Includes data on all list entries across all your Affinity Lists. Includes basic list metadata, and a json object that includes your custom list-specific fields.
Name: list_entries
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 |
|---|
entity_type | Internal identifier for the entity type |
list_id | The ID of the list that this list entry belongs to |
list_name | The name of the list |
is_public | Whether or not the list is public |
list_owner_id | The ID of the user that owns this list |
list_creator_id | The ID of the user that created this list |
list_type | The entity type for this list |
id | The list entry’s unique identifier |
creator_id | The ID of the user that created this list entry |
created_at | The date that the list entry was created |
custom_fields | Custom field values on the list entry |
last_updated_at | Timestamp when this record was last updated |
