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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
updated_at	timestamp with time zone		The time when any of the user preferences was last updated.
user_id	text	=, !=, ~~, ~~, !~~, !~~	The unique identifier for the user.
version_id	bigint		The 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