Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
meta Table key text 2147483647 null
filemon Table lastoffsetbytes int8 19 √ null

The end position of the most recent successful import
connection Table certified bool 1 false
managed_table_column Table id_managed_table uuid 2147483647 null
user_security_filter Table comment text 2147483647 √ null
database_info Table uuid uuid 2147483647 gen_random_uuid()
shared_query Table uuid uuid 2147483647 gen_random_uuid()
shared_query Table query text 2147483647 √ null
database_info Table id_owned_by uuid 2147483647 null
role Table id_database uuid 2147483647 null
shared_query Table mode text 2147483647 √ null
managed_table Table periodicstatementperiod text 2147483647 √ null
user Table name text 2147483647 null
filemon Table lastseen timestamptz 35 null

The system time when this file was last seen
connection Table username text 2147483647 null
role_security_filter Table comment text 2147483647 √ null
shared_query Table created_on timestamptz 35 now()
schema_info Table is_default bool 1 false

True if this is the default schema for a given database
widget Table positionrow int4 10 √ null
shared_query Table results text 2147483647 √ null
connection Table source text 2147483647 √ null
connection Table id_owned_by uuid 2147483647 null
user Table version int8 19 1
dashboard Table source text 2147483647 √ null
widget Table uuid uuid 2147483647 gen_random_uuid()
user_roles Table id_role uuid 2147483647 null
database_info Table is_default bool 1 false

True if this is the default database
role_security_filter Table version int8 19 1
filemon Table lastfingerprintlength int4 10 √ null

The number of bytes used to calculate lastfingerprint
role Table props jsonb 2147483647 √ null
query_snapshot_data Table rownum int4 10 √ 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
widget Table positioncol int4 10 √ null
role_permission Table tags jsonb 2147483647 √ null
managed_table Table tags jsonb 2147483647 √ null
saved_query Table id_owned_by uuid 2147483647 null
widget Table updated_on timestamptz 35 now()
saved_query Table query text 2147483647 √ null
database_info Table updated_on timestamptz 35 now()
managed_table Table name text 2147483647 null
reportssnapshot Table recipients text 2147483647 null
connection Table id_database uuid 2147483647 null
saved_query Table name text 2147483647 null
periodic_statement_status Table lastmessage text 2147483647 √ null
user_security_filter Table tablenamepattern text 2147483647 null
user_session Table tags jsonb 2147483647 √ null
managed_table Table dtype text 2147483647 null
reportssnapshot Table _row json 2147483647 √ null
periodic_statement_status Table id_managed_table uuid 2147483647 null
user Table uuid uuid 2147483647 gen_random_uuid()
managed_table Table npartitions int4 10 4
connection Table url text 2147483647 null
dashboard Table comment text 2147483647 √ null
user_session Table options text 2147483647 √ null
periodic_statement_status Table laststatus text 2147483647 √ null
widget Table options jsonb 2147483647 √ null
connection Table password text 2147483647 null
managed_table Table updated_on timestamptz 35 now()
shared_query Table version int8 19 1
user_security_filter Table user_uuid uuid 2147483647 null
role_permission Table object_type text 2147483647 null
widget Table sizey int4 10 √ null
schema_info Table id_database uuid 2147483647 null
role_security_filter Table filter text 2147483647 √ null
role_permission Table props jsonb 2147483647 √ null
widget Table tags jsonb 2147483647 √ null
macro Table tags jsonb 2147483647 √ null
macro Table version int8 19 1
user Table created_on timestamptz 35 now()
role Table created_on timestamptz 35 now()
filemon Table filedate timestamptz 35 null

The last modification time of the file as it was most recently observed
macro Table parameters jsonb 2147483647 √ null
managed_table_column Table pgoid int4 10 null
dashboard Table id_database uuid 2147483647 null
reportssnapshot Table schedulename text 2147483647 null
user_session Table created_on timestamptz 35 now()
reportssnapshot Table reportname text 2147483647 null
role_security_filter Table schemanamepattern text 2147483647 null
role_permission Table updated_on timestamptz 35 now()
macro Table id_owned_by uuid 2147483647 null
schema_info Table name text 2147483647 null

The actual name of this schema
connection Table tags jsonb 2147483647 √ null
managed_table Table version int8 19 1
dashboard Table uuid uuid 2147483647 gen_random_uuid()
dashboard Table updated_on timestamptz 35 now()
user Table username text 2147483647 null
query_snapshot Table records_retrieved int4 10 0
user Table id_owned_by uuid 2147483647 null
saved_query Table props jsonb 2147483647 √ null
reportssnapshot Table id uuid 2147483647 null
widget Table widgettype text 2147483647 null
shared_query Table parameters jsonb 2147483647 √ null
role_security_filter Table tags jsonb 2147483647 √ null
role Table comment text 2147483647 √ null
query_snapshot_data Table rowdata text 2147483647 √ null
user_session Table user_id uuid 2147483647 null
user_session Table timestamp int8 19 null
macro Table source text 2147483647 √ null
saved_query Table version int8 19 1
filemon_config Table path text 2147483647 null

Modified glob pattern to monitor path. Use '**' to match any path including '/'
managed_table_column Table javaclass text 2147483647 null
user Table is_default bool 1 false
query_snapshot Table metadata text 2147483647 √ null
macro Table id_schema uuid 2147483647 null
macro Table fixedparams bool 1 true
managed_table Table id_schema uuid 2147483647 null
dashboard Table tags jsonb 2147483647 √ null
database_info Table version int8 19 1
managed_table Table uuid uuid 2147483647 gen_random_uuid()
database_info Table name text 2147483647 null

The actual name of this database
saved_query Table id_schema uuid 2147483647 null
query_snapshot_data Table query_uuid uuid 2147483647 null
role_permission Table comment text 2147483647 √ null
role Table version int8 19 1
widget Table name text 2147483647 null
connection Table driver text 2147483647 null
user_security_filter Table fields text 2147483647 √ null
user Table expirydate timestamptz 35 √ null
user_security_filter Table tags jsonb 2147483647 √ null
connection Table dbtype text 2147483647 null
managed_table Table source text 2147483647 √ null
saved_query Table created_on timestamptz 35 now()
user Table avatar text 2147483647 √ null
macro Table props jsonb 2147483647 √ null
user_security_filter Table version int8 19 1
macro Table comment text 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)
user_security_filter Table schemanamepattern text 2147483647 null
dashboard Table version int8 19 1
managed_table Table created_on timestamptz 35 now()
managed_table Table props jsonb 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)
role_security_filter Table role_uuid uuid 2147483647 null
managed_table Table periodicstatementstatement text 2147483647 √ null
managed_table Table id serial 10 √ nextval('warehouse.managed_table_id_seq'::regclass)
role_security_filter Table fieldspolicy text 2147483647 √ null
role Table id_owned_by uuid 2147483647 null
saved_query Table updated_on timestamptz 35 now()
user_session Table version int8 19 1
shared_query Table comment text 2147483647 √ null
saved_query Table source text 2147483647 √ null
dashboard Table props jsonb 2147483647 √ null
macro Table uuid uuid 2147483647 gen_random_uuid()
user_session Table props jsonb 2147483647 √ null
user_security_filter Table created_on timestamptz 35 now()
role_security_filter Table updated_on timestamptz 35 now()
filemon Table configid int4 10 √ null

Foreign key to warehouse.filemon_config.id
shared_query Table id_database uuid 2147483647 null
role_permission Table created_on timestamptz 35 now()
macro Table macrotype text 2147483647 null
widget Table queryid uuid 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.
query_snapshot Table lastdate timestamptz 35 null
managed_table_column Table name text 2147483647 null
shared_query Table tags jsonb 2147483647 √ null
periodic_statement_status Table lastrun timestamptz 35 √ null
role_security_filter Table source 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 enabled bool 1 true
periodic_statement_status Table lastdurationmillis int8 19 √ null
role_permission Table restricttoowner bool 1 false
query_snapshot Table compilation_time int4 10 null
shared_query Table updated_on timestamptz 35 now()
filemon Table filename text 2147483647 null

The file name
role Table roletype text 2147483647 null
widget Table tableid 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)
dashboard Table created_on timestamptz 35 now()
dashboard Table gridcolumns int4 10 12
query_snapshot Table uuid uuid 2147483647 null
shared_query Table ttl text 2147483647 √ null
managed_table Table extschemaname text 2147483647 √ null
connection Table props jsonb 2147483647 √ null
filemon Table lastimportdate timestamptz 35 √ null

The date of the last successful import (not modified when lastimportstatus is not SUCCESS)
role_permission Table role_uuid uuid 2147483647 null
managed_table Table query text 2147483647 √ null
managed_table_column Table nulltype bool 1 null
shared_query Table intervalend text 2147483647 √ null
widget Table dashboard_uuid uuid 2147483647 null
role Table updated_on timestamptz 35 now()
user_roles Table id_user uuid 2147483647 null
managed_table Table id_owned_by uuid 2147483647 null
dashboard Table name text 2147483647 null
shared_query Table intervalstart text 2147483647 √ null
shared_query Table id_owned_by uuid 2147483647 null
widget Table databaseorder int4 10 null
role_permission Table action_name text 2147483647 null
connection Table comment text 2147483647 √ null
connection Table uuid uuid 2147483647 gen_random_uuid()
role_security_filter Table tablenamepattern text 2147483647 null
saved_query Table comment text 2147483647 √ null
role_permission Table source text 2147483647 √ null
macro Table definition text 2147483647 √ null
role_permission Table version int8 19 1
role_security_filter Table created_on timestamptz 35 now()
schema_info Table alias text 2147483647 null

An alias for this schema that may be found in legacy DDL files
user Table props jsonb 2147483647 √ null
user Table updated_on timestamptz 35 now()
user_security_filter Table fieldspolicy text 2147483647 √ null
role Table tags jsonb 2147483647 √ null
user_session Table id_owned_by uuid 2147483647 null
macro Table created_on timestamptz 35 now()
role_security_filter Table fields text 2147483647 √ null
filemon_config Table fingerprintlength int4 10 256

Length of content to use for computing the fingerprint (Default: 256 bytes)
managed_table_column Table sqltype int4 10 null
widget Table props jsonb 2147483647 √ null
shared_query Table name text 2147483647 null
saved_query Table certified bool 1 false
managed_table Table certified bool 1 false
user_security_filter Table props jsonb 2147483647 √ null
shared_query Table certified bool 1 false
widget Table sizex int4 10 √ null
managed_table_column Table columnindex int4 10 null
managed_table_column Table arraytype bool 1 null
widget Table comment text 2147483647 √ null
user Table preferences jsonb 2147483647 √ null
role Table uuid uuid 2147483647 gen_random_uuid()
connection Table created_on timestamptz 35 now()
user Table authservice text 2147483647 √ null
dashboard Table id_owned_by uuid 2147483647 null
meta Table value text 2147483647 √ null
reportssnapshot Table _ts timestamptz 35 null
schema_info Table uuid uuid 2147483647 gen_random_uuid()
user_session Table updated_on timestamptz 35 now()
saved_query Table tags jsonb 2147483647 √ null
connection Table name text 2147483647 null
macro Table updated_on timestamptz 35 now()
query_snapshot Table service_time int4 10 null
widget Table created_on timestamptz 35 now()
managed_table Table extconn_uuid uuid 2147483647 √ null
user_session Table comment text 2147483647 √ null
shared_query Table props jsonb 2147483647 √ null
periodic_statement_status Table uuid uuid 2147483647 gen_random_uuid()
database_info Table created_on timestamptz 35 now()
role Table source text 2147483647 √ null
query_snapshot Table record_count int4 10 null
schema_info Table partition_name text 2147483647 √ null
user Table email text 2147483647 √ null
shared_query Table source text 2147483647 √ null
user Table source text 2147483647 √ null
connection Table version int8 19 1
user_security_filter Table filter text 2147483647 √ null
user_session Table uuid uuid 2147483647 gen_random_uuid()
connection Table updated_on timestamptz 35 now()
filemon_config Table targetschema text 2147483647 null

The target schema into which this data should be ingested. May be aliased (see warehouse.schema_info)
filemon Table lastimportstatus text 2147483647 null

The status of the last import: SUCCESS or an error indication
user Table tags jsonb 2147483647 √ null
managed_table Table comment text 2147483647 √ null
macro Table name text 2147483647 null
saved_query Table uuid uuid 2147483647 gen_random_uuid()
managed_table Table exttablename text 2147483647 √ null
shared_query Table operations jsonb 2147483647 √ null
role Table name text 2147483647 null
saved_query Table operations jsonb 2147483647 √ null
managed_table Table parserspec text 2147483647 √ null
schema_info Table id_owned_by uuid 2147483647 null
user_security_filter Table updated_on timestamptz 35 now()
role_security_filter 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
user Table comment text 2147483647 √ null
filemon_config Table targettable text 2147483647 null

The target table into which this data should be ingested
managed_table_column Table typename text 2147483647 null
filemon Table lastfingerprint text 2147483647 √ null

The fingerprint for this file as it was last observed
role_permission Table object_id text 2147483647 √ null