turbot/steampipecloud
steampipe plugin install steampipecloud

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_at
from
steampipecloud_user_preferences;

Schema for steampipecloud_user_preferences

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
communication_community_updatestextIs the user subscribed to receiving community update emails.
communication_product_updatestextIs the user subscribed to receiving product update emails.
communication_tips_and_trickstextIs the user subscribed to receiving tips and tricks emails.
created_attimestamp with time zoneThe time when the user preferences was created.
idtextThe unique identifier for the user preferences.
updated_attimestamp with time zoneThe time when any of the user preferences was last updated.
version_idbigintThe version ID of the user preferences.