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	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
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.
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.
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