Table: linode_type - Query Linode Instance Types using SQL

Linode Instance Types represent different hardware configurations that you can use for your Linode. Each type comes with different specifications, including CPU, memory, storage, and transfer capabilities. These types determine the capabilities and pricing of your Linode.

Table Usage Guide

The linode_type table provides insights into the various instance types available within Linode. As a system administrator, you can use this table to understand each instance type's capabilities, including CPU, memory, storage, and transfer specifications. This information can be instrumental in choosing the most suitable instance type for your specific needs.

Examples

List all types

Analyze the settings to understand the different types of services available on Linode, sorted by their monthly cost. This is useful for budget planning and understanding the cost implications of different service types.

select
  *
from
  linode_type
order by
  price_monthly;

select
  *
from
  linode_type
order by
  price_monthly;

List all dedicated instance types

Explore the different dedicated instance types available on Linode, arranged in order of their monthly price. This can help you choose the most cost-effective option for your specific needs.

select
  *
from
  linode_type
where
  class = 'dedicated'
order by
  price_monthly;

select
  *
from
  linode_type
where
  class = 'dedicated'
order by
  price_monthly;

Schema for linode_type

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
addons	jsonb		A list of optional add-on services for Linodes and their associated costs.
class	text		The class of the Linode Type: nanode, standard, dedicated, gpu, highmem.
disk	bigint		The Disk size, in MB, of the Linode Type.
euuid	text		An external unique identifier for this account.
id	text	=	The ID representing the Linode Type.
label	text		The Linode Type’s label is for display purposes only.
memory	bigint		Amount of RAM included in this Linode Type.
network_out	bigint		The Mbits outbound bandwidth allocation.
price_hourly	bigint		Cost (in US dollars) per hour.
price_monthly	bigint		Cost (in US dollars) per month.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
transfer	bigint		The monthly outbound transfer amount, in MB.
vcpus	bigint		The number of VCPU cores this Linode Type offers.

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_type