steampipecloud_audit_logsteampipecloud_connectionsteampipecloud_organizationsteampipecloud_organization_membersteampipecloud_organization_workspace_membersteampipecloud_processsteampipecloud_tokensteampipecloud_usersteampipecloud_user_emailsteampipecloud_user_preferencessteampipecloud_workspacesteampipecloud_workspace_aggregatorsteampipecloud_workspace_connectionsteampipecloud_workspace_db_logsteampipecloud_workspace_modsteampipecloud_workspace_mod_variablesteampipecloud_workspace_pipelinesteampipecloud_workspace_processsteampipecloud_workspace_snapshot
Table: steampipecloud_user_preferences
User Preferences represents various preferences settings for a user e.g. email settings.
The steampipecloud_user_preferences
table returns preferences of a user whose token is used for authentication.
Examples
Basic info
select id, communication_community_updates, communication_product_updates, communication_tips_and_tricks, created_atfrom steampipecloud_user_preferences;
Schema for steampipecloud_user_preferences
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
communication_community_updates | text | Is the user subscribed to receiving community update emails. | |
communication_product_updates | text | Is the user subscribed to receiving product update emails. | |
communication_tips_and_tricks | text | Is the user subscribed to receiving tips and tricks emails. | |
created_at | timestamp with time zone | The time when the user preferences was created. | |
id | text | The unique identifier for the user preferences. | |
updated_at | timestamp with time zone | The time when any of the user preferences was last updated. | |
version_id | bigint | The version ID of the user preferences. |