steampipe plugin install chaos

Table: chaos_all_column_types

Chaos table to test all columns of different types

Examples

List all

select
*
from
chaos_all_column_types;

Schema for chaos_all_column_types

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
array_elementjsonbThis column test the functionality of array lookup in Transform function
array_to_maps_columnjsonb
boolean_columnboolean
cidr_columncidr
date_time_columntimestamp with time zone
double_columndouble precision
empty_hydratetextThis column tests both a hydrate function returning no results, and the column default mechanism
epoch_column_millisecondstimestamp with time zone
epoch_column_secondstimestamp with time zone
idbigint
inet_columninet
ipaddress_columninet
json_columnjsonb
long_string_columntext
ltree_columnltree
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
string_columntext
string_to_array_columnjsonb