Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
shared_query Table uuid uuid 2147483647 gen_random_uuid()
widget Table positionrow int4 10 √ null
periodic_statement_status Table uuid uuid 2147483647 gen_random_uuid()
managed_table_column Table sqltype int4 10 null
database_info Table is_default bool 1 false

True if this is the default database
user Table name text 2147483647 null
managed_table Table id serial 10 √ nextval('warehouse.managed_table_id_seq'::regclass)
macro Table created_on timestamptz 35 now()
user Table expirydate timestamptz 35 √ null
user Table props jsonb 2147483647 √ null
saved_query Table name text 2147483647 null
saved_query Table created_on timestamptz 35 now()
filemon Table lastimportdatalength int8 19 √ null

The number of bytes imported during the most recent successful import (not modified when lastimportstatus is not SUCCESS)
user Table tags jsonb 2147483647 √ null
user_security_filter Table version int8 19 1
managed_table Table created_on timestamptz 35 now()
connection Table password text 2147483647 null
user_session Table created_on timestamptz 35 now()
saved_query Table source text 2147483647 √ null
shared_query Table operations jsonb 2147483647 √ null
user_security_filter Table props jsonb 2147483647 √ null
shared_query Table name text 2147483647 null
saved_query Table id_owned_by uuid 2147483647 null
managed_table Table name text 2147483647 null
dashboard Table id_owned_by uuid 2147483647 null
user_session Table user_id uuid 2147483647 null
query_snapshot_data Table query_uuid uuid 2147483647 null
filemon Table lastimportdate timestamptz 35 √ null

The date of the last successful import (not modified when lastimportstatus is not SUCCESS)
macro Table source text 2147483647 √ null
role_permission Table comment text 2147483647 √ null
managed_table Table extconn_uuid uuid 2147483647 √ null
managed_table Table extschemaname text 2147483647 √ null
saved_query Table version int8 19 1
user Table is_default bool 1 false
query_snapshot Table records_retrieved int4 10 0
saved_query Table certified bool 1 false
dashboard Table gridcolumns int4 10 12
query_snapshot_data Table rowdata text 2147483647 √ null
shared_query Table intervalstart text 2147483647 √ null
user Table uuid uuid 2147483647 gen_random_uuid()
shared_query Table certified bool 1 false
connection Table tags jsonb 2147483647 √ null
user_security_filter Table comment text 2147483647 √ null
user Table enabled bool 1 true
connection Table id_database uuid 2147483647 null
schema_info Table id_owned_by uuid 2147483647 null
filemon_config Table fingerprintlength int4 10 256

Length of content to use for computing the fingerprint (Default: 256 bytes)
filemon_config Table pipelinename text 2147483647 √ null

The pipeline to use for ingestion. Leave empty to use the default (first) pipeline in the parser spec
widget Table tableid uuid 2147483647 √ null
role Table source text 2147483647 √ null
role_permission Table tags jsonb 2147483647 √ null
dashboard Table updated_on timestamptz 35 now()
role Table comment text 2147483647 √ null
connection Table version int8 19 1
managed_table Table exttablename text 2147483647 √ null
user Table source text 2147483647 √ null
filemon_config Table path text 2147483647 null

Modified glob pattern to monitor path. Use '**' to match any path including '/'
managed_table Table npartitions int4 10 4
filemon Table lastimportstatus text 2147483647 null

The status of the last import: SUCCESS or an error indication
role Table name text 2147483647 null
filemon_config Table id serial 10 √ nextval('warehouse.filemon_config_id_seq'::regclass)

A unique ID for this configuration row
user Table id_owned_by uuid 2147483647 null
macro Table uuid uuid 2147483647 gen_random_uuid()
managed_table_column Table name text 2147483647 null
role Table tags jsonb 2147483647 √ null
connection Table uuid uuid 2147483647 gen_random_uuid()
role_security_filter Table comment text 2147483647 √ null
reportssnapshot Table reportname text 2147483647 null
dashboard Table name text 2147483647 null
filemon_config Table pollintervalseconds int4 10 0

Specify the polling interval in seconds to scan for new files. If zero (default) then file change event monitoring is enabled. If last polled files are still being processed then the scanning is deferred to next scan interval.
role Table id_database uuid 2147483647 null
connection Table url text 2147483647 null
filemon_config Table targettable text 2147483647 null

The target table into which this data should be ingested
role_permission Table updated_on timestamptz 35 now()
schema_info Table id_database uuid 2147483647 null
filemon Table lastfingerprint text 2147483647 √ null

The fingerprint for this file as it was last observed
connection Table source text 2147483647 √ null
managed_table Table comment text 2147483647 √ null
managed_table_column Table pgoid int4 10 null
database_info Table uuid uuid 2147483647 gen_random_uuid()
saved_query Table operations jsonb 2147483647 √ null
user Table preferences jsonb 2147483647 √ null
role_security_filter Table role_uuid uuid 2147483647 null
filemon_config Table targetdatabase text 2147483647 null

The target database into which this data should be ingested. May be aliased (see warehouse.database_info)
user_session Table updated_on timestamptz 35 now()
widget Table sizey int4 10 √ null
filemon Table lastoffsetbytes int8 19 √ null

The end position of the most recent successful import
filemon Table configid int4 10 √ null

Foreign key to warehouse.filemon_config.id
managed_table_column Table id_managed_table uuid 2147483647 null
connection Table props jsonb 2147483647 √ null
macro Table props jsonb 2147483647 √ null
saved_query Table comment text 2147483647 √ null
role Table version int8 19 1
macro Table id_schema uuid 2147483647 null
query_snapshot Table record_count int4 10 null
shared_query Table created_on timestamptz 35 now()
managed_table Table source text 2147483647 √ null
role_security_filter Table tablenamepattern text 2147483647 null
database_info Table alias text 2147483647 null

An alias for this database that may be found in legacy DDL files
user_session Table props jsonb 2147483647 √ null
user_security_filter Table fields text 2147483647 √ null
dashboard Table created_on timestamptz 35 now()
user_security_filter Table tablenamepattern text 2147483647 null
role_security_filter Table fieldspolicy text 2147483647 √ null
dashboard Table tags jsonb 2147483647 √ null
managed_table Table tags jsonb 2147483647 √ null
connection Table id_owned_by uuid 2147483647 null
managed_table_column Table javaclass text 2147483647 null
user_security_filter Table schemanamepattern text 2147483647 null
user_security_filter Table fieldspolicy text 2147483647 √ null
macro Table name text 2147483647 null
managed_table Table dtype text 2147483647 null
filemon Table lastseen timestamptz 35 null

The system time when this file was last seen
saved_query Table uuid uuid 2147483647 gen_random_uuid()
widget Table options jsonb 2147483647 √ null
role Table roletype text 2147483647 null
widget Table widgettype text 2147483647 null
widget Table created_on timestamptz 35 now()
role_permission Table source text 2147483647 √ null
shared_query Table comment text 2147483647 √ null
reportssnapshot Table id uuid 2147483647 null
role Table created_on timestamptz 35 now()
user Table username text 2147483647 null
user_session Table options text 2147483647 √ null
filemon Table filename text 2147483647 null

The file name
managed_table Table id_schema uuid 2147483647 null
reportssnapshot Table _ts timestamptz 35 null
query_snapshot Table lastdate timestamptz 35 null
periodic_statement_status Table laststatus text 2147483647 √ null
connection Table name text 2147483647 null
shared_query Table results text 2147483647 √ null
meta Table key text 2147483647 null
role_security_filter Table schemanamepattern text 2147483647 null
macro Table macrotype text 2147483647 null
saved_query Table tags jsonb 2147483647 √ null
shared_query Table ttl text 2147483647 √ null
managed_table_column Table typename text 2147483647 null
managed_table_column Table arraytype bool 1 null
connection Table comment text 2147483647 √ null
user_security_filter Table updated_on timestamptz 35 now()
user_security_filter Table filter text 2147483647 √ null
role_security_filter Table created_on timestamptz 35 now()
dashboard Table version int8 19 1
connection Table created_on timestamptz 35 now()
database_info Table name text 2147483647 null

The actual name of this database
managed_table Table id_owned_by uuid 2147483647 null
role_security_filter Table version int8 19 1
role Table updated_on timestamptz 35 now()
saved_query Table id_schema uuid 2147483647 null
connection Table dbtype text 2147483647 null
role Table uuid uuid 2147483647 gen_random_uuid()
periodic_statement_status Table id_managed_table uuid 2147483647 null
widget Table name text 2147483647 null
macro Table tags jsonb 2147483647 √ null
widget Table databaseorder int4 10 null
shared_query Table query text 2147483647 √ null
schema_info Table is_default bool 1 false

True if this is the default schema for a given database
connection Table updated_on timestamptz 35 now()
user Table version int8 19 1
managed_table Table updated_on timestamptz 35 now()
saved_query Table props jsonb 2147483647 √ null
connection Table driver text 2147483647 null
shared_query Table id_database uuid 2147483647 null
query_snapshot Table compilation_time int4 10 null
widget Table dashboard_uuid uuid 2147483647 null
shared_query Table parameters jsonb 2147483647 √ null
role_security_filter Table source text 2147483647 √ null
managed_table Table parserspec text 2147483647 √ null
shared_query Table updated_on timestamptz 35 now()
user Table created_on timestamptz 35 now()
role Table props jsonb 2147483647 √ null
meta Table value text 2147483647 √ null
dashboard Table id_database uuid 2147483647 null
managed_table Table version int8 19 1
role_security_filter Table fields text 2147483647 √ null
user_security_filter Table user_uuid uuid 2147483647 null
periodic_statement_status Table lastdurationmillis int8 19 √ null
connection Table certified bool 1 false
database_info Table id_owned_by uuid 2147483647 null
user_security_filter Table created_on timestamptz 35 now()
widget Table sizex int4 10 √ null
query_snapshot Table metadata text 2147483647 √ null
role_security_filter Table filter text 2147483647 √ null
shared_query Table id_owned_by uuid 2147483647 null
role_permission Table action_name text 2147483647 null
role_security_filter Table tags jsonb 2147483647 √ null
connection Table username text 2147483647 null
widget Table updated_on timestamptz 35 now()
query_snapshot Table uuid uuid 2147483647 null
user Table updated_on timestamptz 35 now()
role_security_filter Table props jsonb 2147483647 √ null
macro Table id_owned_by uuid 2147483647 null
managed_table Table periodicstatementperiod text 2147483647 √ null
reportssnapshot Table _row json 2147483647 √ null
widget Table queryid uuid 2147483647 √ null
user Table email text 2147483647 √ null
user_session Table uuid uuid 2147483647 gen_random_uuid()
macro Table version int8 19 1
database_info Table created_on timestamptz 35 now()
filemon Table lastfingerprintlength int4 10 √ null

The number of bytes used to calculate lastfingerprint
schema_info Table alias text 2147483647 null

An alias for this schema that may be found in legacy DDL files
managed_table_column Table columnindex int4 10 null
schema_info Table name text 2147483647 null

The actual name of this schema
shared_query Table tags jsonb 2147483647 √ null
managed_table Table periodicstatementstatement text 2147483647 √ null
dashboard Table comment text 2147483647 √ null
periodic_statement_status Table lastmessage text 2147483647 √ null
shared_query Table mode text 2147483647 √ null
user_session Table version int8 19 1
user_session Table timestamp int8 19 null
managed_table Table uuid uuid 2147483647 gen_random_uuid()
widget Table comment text 2147483647 √ null
schema_info Table partition_name text 2147483647 √ null
role_permission Table props jsonb 2147483647 √ null
macro Table definition text 2147483647 √ null
query_snapshot Table service_time int4 10 null
user_security_filter Table tags jsonb 2147483647 √ null
macro Table fixedparams bool 1 true
filemon Table lastimportdurationmillis int8 19 √ null

The amount of time spent on the last successful import (not modified when lastimportstatus is not SUCCESS)
macro Table updated_on timestamptz 35 now()
shared_query Table version int8 19 1
macro Table parameters jsonb 2147483647 √ null
managed_table Table props jsonb 2147483647 √ null
role_permission Table object_type text 2147483647 null
managed_table Table certified bool 1 false
saved_query Table query text 2147483647 √ null
database_info Table version int8 19 1
role_security_filter Table updated_on timestamptz 35 now()
filemon Table filedate timestamptz 35 null

The last modification time of the file as it was most recently observed
shared_query Table props jsonb 2147483647 √ null
widget Table tags jsonb 2147483647 √ null
schema_info Table uuid uuid 2147483647 gen_random_uuid()
dashboard Table props jsonb 2147483647 √ null
user_session Table comment text 2147483647 √ null
filemon_config Table targetschema text 2147483647 null

The target schema into which this data should be ingested. May be aliased (see warehouse.schema_info)
role_permission Table created_on timestamptz 35 now()
role_permission Table object_id text 2147483647 √ null
managed_table Table query text 2147483647 √ null
reportssnapshot Table recipients text 2147483647 null
role Table id_owned_by uuid 2147483647 null
saved_query Table updated_on timestamptz 35 now()
user Table avatar text 2147483647 √ null
shared_query Table intervalend text 2147483647 √ null
dashboard Table source text 2147483647 √ null
user_roles Table id_user uuid 2147483647 null
user_session Table tags jsonb 2147483647 √ null
widget Table positioncol int4 10 √ null
dashboard Table uuid uuid 2147483647 gen_random_uuid()
role_permission Table version int8 19 1
user Table comment text 2147483647 √ null
macro Table comment text 2147483647 √ null
periodic_statement_status Table lastrun timestamptz 35 √ null
reportssnapshot Table schedulename text 2147483647 null
user Table authservice text 2147483647 √ null
query_snapshot_data Table rownum int4 10 √ null
widget Table props jsonb 2147483647 √ null
user_session Table id_owned_by uuid 2147483647 null
widget Table uuid uuid 2147483647 gen_random_uuid()
role_permission Table role_uuid uuid 2147483647 null
role_permission Table restricttoowner bool 1 false
user_roles Table id_role uuid 2147483647 null
managed_table_column Table nulltype bool 1 null
database_info Table updated_on timestamptz 35 now()
shared_query Table source text 2147483647 √ null