Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
connection Table name text 2147483647 null
saved_query Table props jsonb 2147483647 √ null
role Table version int8 19 1
periodic_statement_status Table lastmessage text 2147483647 √ null
widget Table comment text 2147483647 √ null
shared_query Table query text 2147483647 √ null
role_security_filter Table tags jsonb 2147483647 √ null
user_security_filter Table fields text 2147483647 √ null
managed_table_column Table name text 2147483647 null
managed_table_column Table javaclass text 2147483647 null
managed_table_column Table arraytype bool 1 null
role Table name text 2147483647 null
user_session Table uuid uuid 2147483647 gen_random_uuid()
periodic_statement_status Table laststatus text 2147483647 √ null
user_roles Table id_user uuid 2147483647 null
managed_table Table extschemaname text 2147483647 √ null
connection Table id_owned_by uuid 2147483647 null
saved_query Table uuid uuid 2147483647 gen_random_uuid()
reportssnapshot Table reportname text 2147483647 null
saved_query Table version int8 19 1
role_security_filter Table comment text 2147483647 √ null
macro Table uuid uuid 2147483647 gen_random_uuid()
widget Table tags jsonb 2147483647 √ null
shared_query Table updated_on timestamptz 35 now()
user Table authservice text 2147483647 √ null
macro Table comment text 2147483647 √ null
role Table props jsonb 2147483647 √ null
user Table updated_on timestamptz 35 now()
external_cache_table_status Table created timestamptz 35 null
macro Table parameters jsonb 2147483647 √ null
managed_table Table source text 2147483647 √ null
role Table created_on timestamptz 35 now()
role_security_filter Table version int8 19 1
filemon Table lastseen timestamptz 35 null

The system time when this file was last seen
macro Table tags jsonb 2147483647 √ null
dashboard Table id_database uuid 2147483647 null
managed_table Table periodicstatementstatement text 2147483647 √ null
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
role Table id_owned_by uuid 2147483647 null
shared_query Table intervalstart text 2147483647 √ null
widget Table positionrow int4 10 √ null
role Table tags jsonb 2147483647 √ null
saved_query Table tags jsonb 2147483647 √ null
schema_info Table alias text 2147483647 null

An alias for this schema that may be found in legacy DDL files
role Table comment text 2147483647 √ null
shared_query Table created_on timestamptz 35 now()
connection Table source text 2147483647 √ null
filemon Table lastfingerprint text 2147483647 √ null

The fingerprint for this file as it was last observed
filemon Table filedate timestamptz 35 null

The last modification time of the file as it was most recently observed
managed_table Table query text 2147483647 √ null
widget Table widgettype text 2147483647 null
external_cache_table_status Table lastaccessed timestamptz 35 null
widget Table created_on timestamptz 35 now()
role_security_filter Table updated_on timestamptz 35 now()
saved_query Table certified bool 1 false
query_snapshot Table service_time int4 10 null
external_cache_table_status Table shouldrefresh bool 1 true
role_permission Table restricttoowner bool 1 false
shared_query Table id_owned_by uuid 2147483647 null
widget Table sizey int4 10 √ null
widget Table queryid uuid 2147483647 √ null
filemon_config Table targettable text 2147483647 null

The target table into which this data should be ingested
user_session Table tags jsonb 2147483647 √ null
managed_table Table uuid uuid 2147483647 gen_random_uuid()
user Table created_on timestamptz 35 now()
user Table preferences jsonb 2147483647 √ null
reportssnapshot Table _row json 2147483647 √ null
role_permission Table updated_on timestamptz 35 now()
schema_info Table partition_name text 2147483647 √ null
managed_table Table dtype text 2147483647 null
widget Table name text 2147483647 null
saved_query Table id_schema uuid 2147483647 null
shared_query Table parameters jsonb 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)
managed_table Table id_schema uuid 2147483647 null
database_info Table updated_on timestamptz 35 now()
user_security_filter Table comment text 2147483647 √ null
macro Table fixedparams bool 1 true
managed_table_column Table typename text 2147483647 null
dashboard Table version int8 19 1
managed_table Table id serial 10 √ nextval('warehouse.managed_table_id_seq'::regclass)
role_permission Table source text 2147483647 √ null
role_security_filter Table source text 2147483647 √ null
external_cache_table_status Table lastquerymode text 2147483647 √ null
managed_table Table version int8 19 1
filemon_config Table targetschema text 2147483647 null

The target schema into which this data should be ingested. May be aliased (see warehouse.schema_info)
shared_query Table mode text 2147483647 √ null
widget Table props jsonb 2147483647 √ null
shared_query Table version int8 19 1
macro Table updated_on timestamptz 35 now()
filemon_config Table id serial 10 √ nextval('warehouse.filemon_config_id_seq'::regclass)

A unique ID for this configuration row
user Table username text 2147483647 null
managed_table Table npartitions int4 10 4
connection Table id_database uuid 2147483647 null
periodic_statement_status Table uuid uuid 2147483647 gen_random_uuid()
saved_query Table query text 2147483647 √ null
role Table uuid uuid 2147483647 gen_random_uuid()
dashboard Table tags jsonb 2147483647 √ null
managed_table_column Table columnindex int4 10 null
filemon Table lastimportdate timestamptz 35 √ null

The date of the last successful import (not modified when lastimportstatus is not SUCCESS)
role_security_filter Table created_on timestamptz 35 now()
saved_query Table created_on timestamptz 35 now()
role Table source text 2147483647 √ null
user Table tags jsonb 2147483647 √ null
shared_query Table ttl text 2147483647 √ null
shared_query Table id_database uuid 2147483647 null
shared_query Table operations jsonb 2147483647 √ null
role Table id_database uuid 2147483647 null
managed_table Table created_on timestamptz 35 now()
managed_table Table tags jsonb 2147483647 √ null
user_roles Table id_role uuid 2147483647 null
user Table enabled bool 1 true
managed_table Table exttablename text 2147483647 √ null
saved_query Table source text 2147483647 √ null
user_security_filter Table schemanamepattern text 2147483647 null
user Table email text 2147483647 √ null
query_snapshot_data Table query_uuid uuid 2147483647 null
user Table comment text 2147483647 √ null
macro Table props jsonb 2147483647 √ null
role_permission Table action_name text 2147483647 null
periodic_statement_status Table id_managed_table uuid 2147483647 null
role_permission Table created_on timestamptz 35 now()
user Table expirydate timestamptz 35 √ null
filemon Table lastfingerprintlength int4 10 √ null

The number of bytes used to calculate lastfingerprint
user Table version int8 19 1
connection Table comment text 2147483647 √ null
shared_query Table intervalend text 2147483647 √ null
role_security_filter Table role_uuid uuid 2147483647 null
filemon_config Table fingerprintlength int4 10 256

Length of content to use for computing the fingerprint (Default: 256 bytes)
external_cache_table_status Table uuid uuid 2147483647 gen_random_uuid()
dashboard Table gridcolumns int4 10 12
database_info Table version int8 19 1
query_snapshot_data Table rownum int4 10 √ null
macro Table macrotype text 2147483647 null
role_permission Table object_type text 2147483647 null
dashboard Table props jsonb 2147483647 √ null
managed_table_column Table id_managed_table uuid 2147483647 null
dashboard Table created_on timestamptz 35 now()
macro Table definition text 2147483647 √ null
connection Table url text 2147483647 null
user Table avatar text 2147483647 √ null
saved_query Table name text 2147483647 null
connection Table props jsonb 2147483647 √ null
user Table uuid uuid 2147483647 gen_random_uuid()
external_cache_table_status Table creationquery text 2147483647 null
saved_query Table id_owned_by uuid 2147483647 null
shared_query Table results text 2147483647 √ null
user_security_filter Table tablenamepattern text 2147483647 null
shared_query Table name text 2147483647 null
macro Table source text 2147483647 √ null
widget Table tableid uuid 2147483647 √ null
query_snapshot Table records_retrieved int4 10 0
dashboard Table name text 2147483647 null
saved_query Table operations jsonb 2147483647 √ null
managed_table Table certified bool 1 false
shared_query Table uuid uuid 2147483647 gen_random_uuid()
widget Table updated_on timestamptz 35 now()
shared_query Table source 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.
user_session Table props jsonb 2147483647 √ null
user_session Table created_on timestamptz 35 now()
connection Table version int8 19 1
managed_table Table extconn_uuid uuid 2147483647 √ null
role_security_filter Table props jsonb 2147483647 √ null
managed_table_column Table sqltype int4 10 null
role_security_filter Table fieldspolicy text 2147483647 √ null
user Table is_default bool 1 false
shared_query Table tags jsonb 2147483647 √ null
widget Table options jsonb 2147483647 √ null
user_security_filter Table fieldspolicy text 2147483647 √ null
reportssnapshot Table schedulename text 2147483647 null
user_session Table timestamp int8 19 null
external_cache_table_status Table populated timestamptz 35 √ null
schema_info Table uuid uuid 2147483647 gen_random_uuid()
shared_query Table props jsonb 2147483647 √ null
shared_query Table certified bool 1 false
user_security_filter Table created_on timestamptz 35 now()
role Table roletype text 2147483647 null
filemon Table lastimportstatus text 2147483647 null

The status of the last import: SUCCESS or an error indication
saved_query Table comment text 2147483647 √ null
managed_table Table comment text 2147483647 √ null
database_info Table uuid uuid 2147483647 gen_random_uuid()
database_info Table is_default bool 1 false

True if this is the default database
meta Table value text 2147483647 √ null
managed_table Table periodicstatementperiod text 2147483647 √ null
role_security_filter Table fields text 2147483647 √ null
user_session Table version int8 19 1
user_security_filter Table user_uuid uuid 2147483647 null
filemon_config Table path text 2147483647 null

Modified glob pattern to monitor path. Use '**' to match any path including '/'
macro Table id_schema uuid 2147483647 null
connection Table updated_on timestamptz 35 now()
managed_table Table updated_on timestamptz 35 now()
role_security_filter Table tablenamepattern text 2147483647 null
query_snapshot Table compilation_time int4 10 null
dashboard Table id_owned_by uuid 2147483647 null
macro Table name text 2147483647 null
database_info Table created_on timestamptz 35 now()
managed_table Table id_owned_by uuid 2147483647 null
filemon Table lastimportdurationmillis int8 19 √ null

The amount of time spent on the last successful import (not modified when lastimportstatus is not SUCCESS)
connection Table dbtype text 2147483647 null
schema_info Table id_database uuid 2147483647 null
role_permission Table props jsonb 2147483647 √ null
database_info Table alias text 2147483647 null

An alias for this database that may be found in legacy DDL files
role Table updated_on timestamptz 35 now()
macro Table created_on timestamptz 35 now()
connection Table created_on timestamptz 35 now()
filemon Table lastoffsetbytes int8 19 √ null

The end position of the most recent successful import
connection Table username text 2147483647 √ null
widget Table dashboard_uuid uuid 2147483647 null
schema_info Table name text 2147483647 null

The actual name of this schema
dashboard Table source text 2147483647 √ null
connection Table driver text 2147483647 null
query_snapshot_data Table rowdata text 2147483647 √ null
role_permission Table object_id text 2147483647 √ null
query_snapshot Table uuid uuid 2147483647 null
connection Table password text 2147483647 √ null
dashboard Table updated_on timestamptz 35 now()
user_security_filter Table props jsonb 2147483647 √ null
role_security_filter Table filter text 2147483647 √ null
external_cache_table_status Table id_managed_table uuid 2147483647 null
role_permission Table version int8 19 1
database_info Table id_owned_by uuid 2147483647 null
reportssnapshot Table id uuid 2147483647 null
connection Table uuid uuid 2147483647 gen_random_uuid()
user_security_filter Table filter text 2147483647 √ null
saved_query Table updated_on timestamptz 35 now()
query_snapshot Table lastdate timestamptz 35 null
user_session Table user_id uuid 2147483647 null
user_session Table updated_on timestamptz 35 now()
periodic_statement_status Table lastrun timestamptz 35 √ null
role_permission Table comment text 2147483647 √ null
query_snapshot Table record_count int4 10 null
periodic_statement_status Table lastdurationmillis int8 19 √ null
role_permission Table tags jsonb 2147483647 √ null
macro Table id_owned_by uuid 2147483647 null
connection Table certified bool 1 false
filemon Table filename text 2147483647 null

The file name
widget Table databaseorder int4 10 null
role_permission Table role_uuid uuid 2147483647 null
role_security_filter Table schemanamepattern text 2147483647 null
user_session Table options text 2147483647 √ null
user Table name text 2147483647 null
managed_table Table parserspec text 2147483647 √ null
dashboard Table uuid uuid 2147483647 gen_random_uuid()
reportssnapshot Table _ts timestamptz 35 null
schema_info Table is_default bool 1 false

True if this is the default schema for a given database
filemon Table configid int4 10 √ null

Foreign key to warehouse.filemon_config.id
user_security_filter Table tags jsonb 2147483647 √ null
schema_info Table id_owned_by uuid 2147483647 null
widget Table uuid uuid 2147483647 gen_random_uuid()
user Table source text 2147483647 √ null
filemon Table lastimportdatalength int8 19 √ null

The number of bytes imported during the most recent successful import (not modified when lastimportstatus is not SUCCESS)
widget Table sizex int4 10 √ null
user_session Table comment text 2147483647 √ null
managed_table_column Table pgoid int4 10 null
user_security_filter Table version int8 19 1
external_cache_table_status Table suspendcleanup int4 10 1
widget Table positioncol int4 10 √ null
managed_table Table props jsonb 2147483647 √ null
reportssnapshot Table recipients text 2147483647 null
connection Table tags jsonb 2147483647 √ null
macro Table version int8 19 1
shared_query Table comment text 2147483647 √ null
user Table props jsonb 2147483647 √ null
user_security_filter Table updated_on timestamptz 35 now()
external_cache_table_status Table sessionid text 2147483647 null
user Table id_owned_by uuid 2147483647 null
database_info Table name text 2147483647 null

The actual name of this database
managed_table Table name text 2147483647 null
managed_table_column Table nulltype bool 1 null
user_session Table id_owned_by uuid 2147483647 null
dashboard Table comment text 2147483647 √ null
meta Table key text 2147483647 null
query_snapshot Table metadata text 2147483647 √ null