Table: linode_profile - Query Linode Profiles using SQL

Linode Profiles are a part of the Linode API that allows users to manage their account settings and preferences. The profile encompasses a user's contact information, two-factor authentication settings, authorized third-party applications, and more. It is a centralized way to manage user-specific details within the Linode environment.

Table Usage Guide

The linode_profile table provides insights into user profiles within Linode. As a system administrator, explore user-specific details through this table, including contact information, two-factor authentication settings, and authorized applications. Utilize it to manage user preferences, such as timezone settings, authentication methods, and to monitor authorized third-party applications.

Examples

Get profile data

Explore your Linode profile's overall configuration and settings to gain insights into your current setup and identify areas for potential improvement.

select
  *
from
  linode_profile;

select
  *
from
  linode_profile;

Schema for linode_profile

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
authorized_keys	jsonb		The list of SSH Keys authorized to use Lish for your User.
email	text		Your email address. This address will be used for communication with Linode as necessary.
email_notifications	boolean		If true, you will receive email notifications about account activity. If false, you may still receive business-critical communications through email.
euuid	text		An external unique identifier for this account.
ip_whitelist_enabled	boolean		If true, logins for your User will only be allowed from whitelisted IPs. This setting is currently deprecated, and cannot be enabled.
lish_auth_method	text		The authentication methods that are allowed when connecting to the Linode Shell (Lish): password_keys, keys_only, disabled.
referrals	jsonb		Information about your status in our referral program. This information becomes accessible after this Profile’s Account has established at least $25.00 USD of total payments.
restricted	boolean		If true, your User has restrictions on what can be accessed on your Account.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
timezone	text		The timezone you prefer to see times in.
two_factor_auth	boolean		If true, logins from untrusted computers will require Two Factor Authentication.
uid	text		Your unique ID in our system. This value will never change, and can safely be used to identify your User.
username	text		Your username, used for logging in to our system.

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)" -- linode

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

steampipe_export_linode --config '<your_config>' linode_profile