Table: ovh_cloud_storage_swift

A Swift storage is an object storage.

The ovh_cloud_storage_swift table can be used to query information about storage containers and you must specify which cloud project in the where or join clause (where project_id=, join ovh_cloud_project on id=).

Examples

List swift storage containers of a cloud project

select
  id,
  name
from
  ovh_cloud_storage_swift
where
  project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'

List empty swift storage containers

select
  id,
  name
from
  ovh_cloud_storage_swift
where
  project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'
  and stored_objects is null