steampipe plugin install marekjalovec/makesteampipe plugin install marekjalovec/make

make_api_token make_connection make_data_store make_function make_hook make_organization make_organization_variable make_scenario make_scenario_dlq make_scenario_log make_team make_team_variable make_user make_user_organization_role make_user_role make_user_team_role

Table: make_data_store

Data Stores are used to store data from scenarios or for transferring data in between individual scenarios or scenario runs.

Key columns

Provide a numeric id if you want to query for a specific Team.
Provide a numeric team_id to query Data Stores for a specific Team. This can be either set directly in a where clause, or specified as part of join with another table.

Caveat

Be careful when requesting all columns (*) or the data_structure_id column without using an id in the query. To load this data, Steampipe will have to make one extra API request per Data Store returned.

Examples

List of all Data Stores in the account

select
  o.name as organization_name,
  t.name as team_name,
  ds.name as data_store_name
from
  make_organization o
  join make_team t on t.organization_id = o.id
  join make_data_store ds on ds.team_id = t.id;
-- or a simplified version
select
  id,
  name
from
  make_data_store;

List of all Data Stores including data quota usage

select
  o.name as organization_name,
  t.name as team_name,
  ds.name as data_store_name,
  round(100.0 / max_size * size, 2) as ds_fill_perc
from
  make_organization o
  join make_team t on t.organization_id = o.id
  join make_data_store ds on ds.team_id = t.id
order by
  ds_fill_perc desc;

Usage of Data Store quota for the whole account

select
  o.name org_name,
  count(ds.id),
  o.license ->> 'dslimit' dslimit,
  round(
    100.0 / cast(o.license ->> 'dslimit' as int) * count(ds.id),
    2
  ) as usage_perc
from
  make_data_store ds
  join make_team t on t.id = ds.team_id
  join make_organization o on o.id = t.organization_id
group by
  o.name,
  o.license
order by
  org_name;

Detail of a Data Store

select
  id,
  name,
  records,
  size,
  max_size,
  data_structure_id
from
  make_data_store
where
  id = 1;

Schema for make_data_store

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
data_structure_id	bigint		Data structure ID.
id	bigint	=	The Data Store ID.
max_size	bigint		The maximum size of the data that the Data Store can store.
name	text		The name of the Data Store.
records	bigint		Number of records in the Data Store.
size	bigint		The current size of the data in the Data Store.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
team_id	bigint		Virtual column, used to map the entity to another object.
title	text		The display name for the resource.