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