Table: linode_bucket - Query Linode Object Storage Buckets using SQL

Linode Object Storage is a globally-available, S3-compatible method for storing and accessing data. It offers highly scalable, robust, and inexpensive storage for backup, archiving, content distribution, and more. With Linode Object Storage, your data is stored and served in a secure and distributed manner.

Table Usage Guide

The linode_bucket table provides insights into Object Storage Buckets within Linode's Object Storage service. As a DevOps engineer, explore bucket-specific details through this table, including names, created timestamps, and cluster regions. Utilize it to uncover information about buckets, such as their size, the number of objects they contain, and their respective cluster regions.

Examples

List buckets

Explore all the storage buckets available in your Linode account. This can help manage resources and assess storage needs.

select
  *
from
  linode_bucket;

select
  *
from
  linode_bucket;

Buckets in us-east-1

Explore which Linode storage buckets are located in the 'us-east-1' region. This could be useful for managing data locality and ensuring regulatory compliance.

select
  *
from
  linode_bucket
where
  cluster = 'us-east-1';

select
  *
from
  linode_bucket
where
  cluster = 'us-east-1';

Schema for linode_bucket

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
cluster	text	=	The ID of the Object Storage Cluster this bucket is in.
created	timestamp with time zone		When this bucket was created.
euuid	text		An external unique identifier for this account.
hostname	text		The hostname where this bucket can be accessed. This hostname can be accessed through a browser if the bucket is made public.
label	text	=	The name of this bucket.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.

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_bucket