steampipe plugin install pipes

Table: pipes_user_preferences - Query Pipes User Preferences using SQL

Pipes User Preferences is a feature within Turbot Pipes that allows users to customize and manage their individual settings and preferences. It provides users with the ability to personalize their experience and interactions with the Pipes platform. Pipes User Preferences helps users maintain control over their individual settings, providing a tailored user experience.

Table Usage Guide

The pipes_user_preferences table provides insights into user-defined settings within Turbot Pipes. As a system administrator, explore user-specific details through this table, including individual preferences, settings, and associated metadata. Utilize it to uncover information about user behaviors, such as customization patterns, preference trends, and the verification of user-defined settings.

Examples

Basic info

Explore user preferences to understand their communication preferences and the time of their preference creation. This can be useful in tailoring communication strategies and understanding user engagement over time.

select
id,
communication_community_updates,
communication_product_updates,
communication_tips_and_tricks,
created_at
from
pipes_user_preferences;
select
id,
communication_community_updates,
communication_product_updates,
communication_tips_and_tricks,
created_at
from
pipes_user_preferences;

Schema for pipes_user_preferences

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
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.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
updated_attimestamp with time zoneThe time when any of the user preferences was last updated.
user_idtext=, !=, ~~, ~~*, !~~, !~~*The unique identifier for the user.
version_idbigintThe version ID of the user preferences.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- pipes

You can pass the configuration to the command with the --config argument:

steampipe_export_pipes --config '<your_config>' pipes_user_preferences