Includes metadata on all Affinity Lists including name, owner, creator, type, and public/private status.
Name: lists
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 |
|---|
id | The list’s unique identifier |
name | The name of the list |
is_public | Whether or not the list is public |
owner_id | The ID of the user that owns this list |
creator_id | The ID of the user that created this list |
type | The entity type for this list (person, company, or opportunity) |
is_deleted | Whether the list has been deleted |
last_updated_at | Timestamp when this record was last updated |