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 awhere
clause, or specified as part ofjoin
with another table.
Caveat
- Be careful when requesting all columns (
*
) or thedata_structure_id
column without using anid
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_namefrom 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 versionselect id, namefrom 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_percfrom make_organization o join make_team t on t.organization_id = o.id join make_data_store ds on ds.team_id = t.idorder 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_percfrom make_data_store ds join make_team t on t.id = ds.team_id join make_organization o on o.id = t.organization_idgroup by o.name, o.licenseorder by org_name;
Detail of a Data Store
select id, name, records, size, max_size, data_structure_idfrom make_data_storewhere 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. |