Table: scaleway_object_bucket - Query Scaleway Object Storage Buckets using SQL

Scaleway Object Storage is a service within Scaleway that allows you to store and retrieve any amount of data, at any time, from anywhere. It is designed to make web-scale computing easier by enabling you to store and retrieve any amount of data, at any time, from within Scaleway's computing environment. Scaleway Object Storage is a simple, scalable, and reliable object storage solution for managing data for applications, websites, backup, and restore, archive, and big data analytics.

Table Usage Guide

The scaleway_object_bucket table provides insights into Object Storage Buckets within Scaleway. As a DevOps engineer, explore bucket-specific details through this table, including bucket name, region, creation date, and owner. Utilize it to uncover information about buckets, such as their ACLs, CORS configuration, and lifecycle configuration rules.

Examples

Basic info

Explore which of your Scaleway object storage buckets are publicly accessible. This can help in identifying potential security risks and ensuring that sensitive data is not exposed unintentionally.

select
  name,
  region,
  project,
  bucket_policy_is_public
from
  scaleway_object_bucket;

select
  name,
  region,
  project,
  bucket_policy_is_public
from
  scaleway_object_bucket;

List buckets with versioning disabled

Discover the segments that have versioning disabled in your Scaleway object storage. This can be useful to identify potential risks and ensure data integrity by enabling versioning.

select
  name,
  region,
  project,
  versioning_enabled
from
  scaleway_object_bucket
where
  not versioning_enabled;

select
  name,
  region,
  project,
  versioning_enabled
from
  scaleway_object_bucket
where
  not versioning_enabled;

List buckets with no lifecycle policy

Explore which Scaleway object buckets are missing a lifecycle policy. This can be useful to identify potential areas of cost savings, as lifecycle policies can help manage storage costs by automatically archiving or deleting old data.

select
  name,
  region,
  project,
  versioning_enabled
from
  scaleway_object_bucket
where
  lifecycle_rules is null;

select
  name,
  region,
  project,
  versioning_enabled
from
  scaleway_object_bucket
where
  lifecycle_rules is null;

Schema for scaleway_object_bucket

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
acl	jsonb		The access control list (ACL) of a bucket.
bucket_policy_is_public	boolean		The policy status for an Scaleway bucket, indicating whether the bucket is public.
cors_rule	jsonb		The cors configuration information set for the bucket.
creation_date	timestamp with time zone		An unique identifier of the bucket.
lifecycle_rules	jsonb		The lifecycle configuration information of the bucket.
name	text		The user-defined name of the bucket.
policy	jsonb		The resource-based policy access document for the bucket.
project	text		The ID of the project where the bucket resides.
region	text		Specifies the region where the bucket resides.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	jsonb		A list of tags associated with the bucket.
title	text		Title of the resource.
versioning_enabled	boolean		The versioning state of a bucket.
versioning_mfa_delete	boolean		The MFA Delete status of the versioning state.
website	jsonb		The website configuration for a bucket.

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

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

steampipe_export_scaleway --config '<your_config>' scaleway_object_bucket