Table: scaleway_billing_consumption - Query Scaleway Billing comsumption using SQL

Scaleway Billing Consumption tracks the costs of various scaleway products such as object_storage, storage, serverless, etc.

Important Notes

This table requires an Organization ID to be configured in the scaleway.spc file.

Table Usage Guide

The scaleway_billing_consumption table offers insights into the Billing Consumption within Scaleway.

Examples

Basic info

Explore the billing for all scaleway services.

select
  category_name,
  product_name,
  project_id,
  resource_name,
  value
from
  scaleway_billing_consumption;

select
  category_name,
  product_name,
  project_id,
  resource_name,
  value
from
  scaleway_billing_consumption;

List consumption by category

Explore costs by product category of scaleway

select
  category_name,
  sum((value -> 'units') :: float) AS units
from
  scaleway_billing_consumption
group by
  category_name;

select
  category_name,
  sum((value -> 'units') :: float) AS units
from
  scaleway_billing_consumption
group by
  category_name;

List consumption by Project ID

Explore costs by product category of scaleway

select
  project_id,
  sum((value -> 'units') :: float) AS units
from
  scaleway_billing_consumption
group by
  project_id;

select
  project_id,
  sum((value -> 'units') :: float) as units
from
  scaleway_billing_consumption
group by
  project_id;

Schema for scaleway_billing_consumption

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
billed_quantity	jsonb		Consumed quantity.
category_name	text	=	The CategoryName: name of consumption category.
product_name	text		The product name. For example, VPC Public Gateway S, VPC Public Gateway M for the VPC product.
project_id	text		The project ID of the consumption.
resource_name	text		Identifies the reference based on the category.
sku	text		The unique identifier of the product.
unit	text		The unit of consumed quantity.
value	jsonb		Monetary value of the consumption.

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_billing_consumption