Table: linode_account - Query Linode Accounts using SQL

Linode is a cloud hosting provider that offers high-performance SSD Linux servers for all of your infrastructure needs. Linode has received multiple awards for being one of the best virtual private server providers. Linode's Account service provides detailed information about the account, including balance, transfer, and billing information.

Table Usage Guide

The linode_account table provides insights into the account details within Linode. As a cloud engineer, explore account-specific details through this table, including balance, transfer, and billing information. Utilize it to uncover information about the account, such as current balance, pending charges, and the account's last payment date.

Examples

Get account information

Review the configuration for your Linode account to gain insights into its settings and details. This is useful for understanding the state and configuration of your account as a whole.

select
  *
from
  linode_account;

select
  *
from
  linode_account;

Balances

Explore the financial status of your Linode accounts. This query provides an overview of the account balances, uninvoiced balances, and associated credit card details, helping you manage your resources effectively.

select
  email,
  balance,
  balance_uninvoiced,
  credit_card
from
  linode_account;

select
  email,
  balance,
  balance_uninvoiced,
  credit_card
from
  linode_account;

Schema for linode_account

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
address_1	text		First line of this Account’s billing address.
address_2	text		Second line of this Account’s billing address.
balance	text		This Account’s balance, in US dollars.
balance_uninvoiced	text		This Account’s current estimated invoice in US dollars. This is not your final invoice balance. Transfer charges are not included in the estimate.
city	text		The city for this Account’s billing address.
company	text		The company name associated with this Account.
country	text		The two-letter country code of this Account’s billing address.
credit_card	jsonb		Credit Card information associated with this Account.
email	text		The email address of the person associated with this Account.
euuid	text		An external unique identifier for this account.
first_name	text		The first name of the person associated with this Account.
last_name	text		The last name of the person associated with this Account.
phone	text		The phone number associated with this Account.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
state	text		The state for this Account’s billing address.
tax_id	text		The tax identification number associated with this Account, for tax calculations in some countries. If you do not live in a country that collects tax, this should be null.
zip	text		The zip code of this Account’s billing address.

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_account