System Catalog

the system catalog exposes read only virtual tables that contain metadata about the system alphabetical list of tables sys active operator instances sys addendum directories sys association rules models sys average bb sizes sys average column sizes sys channel endpoint parameters sys clusters sys column cardinalities sys column distributions sys columns sys columns compression info sys completed operator instances sys completed queries sys compute configurations sys config sys connectivity pool participants sys connectivity pools sys data usage by file type and table sys databases sys decision tree models sys degraded segment groups sys degraded segment groups by table sys effective merge policy per table sys feedforward network models sys function signatures sys functions sys gaussian mixture models sys global map table info sys group roles sys groups sys index advisor enabled sys index advisors sys index columns sys index recommendations sys index usage sys indexes sys k means models sys k nearest neighbors models sys linear combination regression models sys linear discriminant analysis models sys load errors sys load events sys locations sys locks sys logistic regression models sys lts cluster info sys machine learning model options sys machine learning models sys metric levels sys multiple linear regression models sys naive bayes models sys network interface models sys network interface usage types sys node clusters sys node config sys node network interfaces sys node status sys nodes sys nodes with unhealthy stored segments sys nonlinear regression models sys oidc integrations sys oidc sessions sys op inst debug info sys osn acquisitions sys pipeline errors sys pipeline events sys pipeline files sys pipeline functions sys pipeline metrics sys pipeline metrics info sys pipeline partitions sys pipeline tables sys pipeline tasks sys pipelines sys plans sys polynomial regression models sys principal component analysis models sys privileges sys procedures sys queries sys random forest models sys reserved words sys result cache sys rights sys roles sys security integrations sys security settings sys segment directories sys segment group transfers sys segment groups sys segment part inventory sys segment part redundancy info sys segment parts sys segments sys segments compression info sys service classes sys service classes for user sys service role channel endpoints sys service role status sys service roles sys sessions sys simple linear regression models sys sql messages sys stats files sys storage capacity sys storage device files sys storage device metrics sys storage device status sys storage scopes sys storage spaces sys storage used sys stored segments sys subtasks sys support vector machine models sys system information sys system table columns sys system tables sys table cardinalities sys tables sys tasks sys tkt table clustering column indices sys tkt table info sys user groups sys user mappings sys user roles sys users sys vector autoregression models sys view columns sys views sys vl columns compression info alphabetical list of categories configuration connectivity pools databases loading machine learning monitoring network pipelines security security integrations statistics storage system system information user management workload management catalog table details configuration sys config this table contains all configuration overrides applied on the system column name column type column description scope type char type of the scope scope id uuid universally unique identifier (uuid) of the storage scope where this override applies key char string that represents the configuration parameter value char value for the configuration parameter key sys node config this table contains the effective node configuration for all nodes in the system column name column type column description node id uuid universally unique identifier (uuid) of the node where this configuration exists (sys nodes) key char string that represents the configuration parameter value char value for the configuration parameter key connectivity pools sys connectivity pool participants this table contains the connectivity pool participants and their information column name column type column description id uuid universally unique identifier (uuid) of the connectivity pool that contains the participant node id uuid uuid of the participant node created at timestamp timestamp that indicates the creation of the connectivity pool participant updated at timestamp timestamp that indicates the last update of the connectivity pool participant listen address char address where the participant node listens listen port int port number where the participant node listens advertised address char address that the participant node advertises to the client advertised port int optional port number that the participant node advertises to the client openapi port int optional port number where the api, written according to the openapi specification (oas), listens sys connectivity pools this table contains the connectivity pools and their information (excluding participants) column name column type column description id uuid universally unique identifier (uuid) of the connectivity pool name char name of the connectivity pool created at timestamp timestamp that indicates the creation of the connectivity pool updated at timestamp timestamp that indicates the last update of the connectivity pool source address char source address in cidr notation for the connectivity pool source port int optional source port of the connectivity pool priority int priority of the connectivity pool sso integration name char name of the default sso security integration for the connectivity pool databases sys columns this table contains all columns in each table in the system column name column type column description id uuid universally unique identifier (uuid) of the column name char name of the column data type char data type of the column (int, char, boolean, etc ) position int position of the column in its table table id uuid uuid of the table that contains this column (sys tables) nullable boolean specifies whether the values in this column can be null default expression char default value of this column when the value is unspecified description char description of the column ordinal long ordinal of the column with respect to its table gdc type char type of gdc applied to this column potential index boolean specifies whether the column is a potential index sys databases this table contains all databases defined in the system column name column type column description id uuid universally unique identifier (uuid) of the database name char name of the database created at timestamp timestamp that specifies when the database was created user can view all queries boolean current user can view all queries made in this database sys functions this table contains all of the user defined functions in the system column name column type column description id uuid universally unique identifier (uuid) of the user defined function schema char schema of the user defined function name char name of the user defined function sql expression char for sql user defined functions, this is the expression that defines the function database id uuid uuid of the database of this user defined function (sys databases) created at timestamp timestamp of when this user defined function was created updated at timestamp timestamp of when this user defined function was last updated language char language that the user defined function is written in function type char for non sql user defined functions, the type of function being defined filename char for non sql user defined functions, the name of the file containing the user defined function code function name in external code char for non sql user defined functions, the name of the java or python function or method that defines the user defined function return type char for non sql user defined functions, the return type of the user defined function sys global map table info this table contains the global dictionary compression (gdc) details associated with each compressed column column name column type column description table id uuid universally unique identifier (uuid) of the table (sys tables) column id uuid uuid of the column (sys columns) compressed size int compressed column size (in bytes) max count long maximum amount of unique column values allowed in the column current count long current amount of unique column values in the column sys index advisor enabled this table contains all tables and databases where the index advisor is currently enabled column name column type column description id uuid universally unique identifier (uuid) of the table or database name char name of the table or database object type char determines whether this object is a database or table sys index advisors this table contains raw index advisor information column name column type column description table id uuid universally unique identifier (uuid) of the table for the potential index (sys tables) column id uuid uuid that represents the column (sys columns) table name char name of the table column name char name of the column index type char type of the potential index query id uuid uuid that represents the query query time timestamp a unix timestamp that represents when the query executed sql char the sql statement to use for creating this index sys index columns this table contains the index settings applied to each column column name column type column description index id uuid universally unique identifier (uuid) that represents the index (sys indexes) column id uuid uuid that represents the column (sys columns) ordinal int ordinal of the column in the index structure tuple element char specifies the name of the component column that the index applies to if the index exists on a tuple column ascending boolean indicates whether the values in this column are built in ascending order column ordinal long ordinal position of this column in the source table sys index recommendations this table contains index recommendations column name column type column description table name char name of the table column name char name of the column sql char the sql statement to use for creating this index usage count long number of times this index would be used sys index usage this table contains index usage information column name column type column description table id uuid universally unique identifier (uuid) of the table where the index is located index id uuid uuid of the index segment id uuid uuid of the segment with the index query id uuid uuid of the query that could have used the index was used boolean whether or not the index was used sys indexes this table contains all indexes defined on tables column name column type column description id uuid universally unique identifier (uuid) of the index name char name of the index index type char type of the index table id uuid uuid of the table for the index (sys tables) index use char intended use for the index by the system ngram size int size of each n gram (in bytes) enabled boolean whether the index is enabled on this table sys locations this table contains all of the external table providers column name column type column description id uuid universally unique identifier (uuid) of the location name char name of the location remote info char remote information that defines how to talk to the external table provider database id uuid uuid of the database of this location (sys databases) created at timestamp timestamp that represents when this location was created updated at timestamp timestamp that represents when this location was last updated sys procedures this table contains all of the stored procedures in the system column name column type column description id uuid universally unique identifier (uuid) of the stored procedure schema char schema of the stored procedure name char name of the stored procedure database id uuid uuid of the database of this stored procedure (sys databases) created at timestamp timestamp of when this stored procedure was created updated at timestamp timestamp of when this stored procedure was last updated language char language that the stored procedure is written in filename char the name of the file that the database should load when it needs this stored procedure function name char the name of the function to execute to execute the stored procedure sys tables this table contains all tables defined in the system column name column type column description id uuid universally unique identifier (uuid) of the table (sys tables) name char name of the table schema char name of the schema database id uuid uuid of the database (sys databases) storage space id uuid uuid of the storage space (sys storage spaces) maximum segment size gib int maximum size of a segment for the table in gib description char detailed description of the table streamloader property string char additional properties assigned to control the stream loading behavior for the table lts property string char additional properties assigned to control the lts role behavior for the table created at timestamp timestamp that represents when the table was created altered at timestamp timestamp that represents when the table's structure was last modified via ddl rolehostd version char the rolehostd version in which this table was created software compatible version int the rolehostd version this table is compatible with creator id uuid the uuid of the user or group who created the table (sys users) sys tkt table clustering column indices this table contains the columns defined as part of a clustering index column name column type column description table id uuid universally unique identifier (uuid) of the table (sys tables) column id uuid uuid of the column (sys columns) sys tkt table info this table contains the columns that are defined as the time key on each user defined table and the size of the time bucket in use column name column type column description table id uuid universally unique identifier (uuid) of the table (sys tables) time column id uuid uuid of the column that represents the time column on the table (sys columns) time bucket width long time bucket width used to segment data in nanoseconds sys user mappings this table contains user mappings for locations column name column type column description id uuid universally unique identifier (uuid) of the user mapping name char name of the user mapping local userid char local user identifier remote userid char remote user identifier location id uuid uuid of the location for this user mapping database id uuid uuid of the database for this user mapping (sys databases) created at timestamp timestamp that represents when this user mapping was created updated at timestamp timestamp that represents when this user mapping was last updated remote password char password for the remote user identifier sys view columns this table contains all columns in each view in the system column name column type column description id uuid the universally unique identifier (uuid) of the column name char the name of the column data type char the data type of the column view id uuid the uuid of the view this column comes from nullable boolean whether or not this column is nullable default expression char the default expression of this column, if it exists ordinal long the ordinal of this column sys views this table contains all user defined database views created on the system column name column type column description id uuid universally unique identifier (uuid) of the view name char name of the view database id uuid uuid of the database (sys databases) schema char schema name where the view exists query char query used to generate the view content description char detailed description of the view global dictionary compression table id uuid uuid of the table with the gdc column (sys tables) created at timestamp timestamp that represents the date and time for the creation of the view updated at timestamp timestamp that represents the date and time for the last update of the view creator id uuid the uuid of the user or group who created the view (sys users/sys groups) loading sys load errors the load errors view shows information for the load errors in the system column name column type column description loader id uuid the unique identifier of the loader node (sys nodes) table id uuid if the event is specific to a table, the unique identifier of the table (sys tables) error message char the message that provides more details about the error timestamp timestamp the timestamp that represents when this error occurred scope id uuid if the error is specific to a storage scope, the unique identifier of the scope, which might be the identifier of the query for the results (sys queries) sys load events the load events view shows information for the load events in the system column name column type column description loader id uuid the unique identifier of the loader node (sys nodes) table id uuid if the event is specific to a table, the unique identifier of the table (sys tables) event type char the type of the event event message char the message that provides more details about the event event timestamp timestamp the timestamp that represents when this event occurred scope id uuid if the error is specific to a storage scope, the unique identifier of the scope, which might be the identifier of the query for the results (sys queries) machine learning sys association rules models this table contains the name of the snapshot table for an association rules model column name column type column description machine learning model id uuid universally unique identifier (uuid) of the machine learning model (sys machine learning models) num arguments int number of arguments in the machine learning model data table name char name of the snapshot table sys decision tree models this table contains all model parameters for decision tree models in the system column name column type column description machine learning model id uuid universally unique identifier (uuid) of the machine learning model (sys machine learning models) case statement char the case statement that defines the decision tree num arguments int number of arguments in the machine learning model data correctly classified double percentage of training data that the decision tree model correctly classifies area under roc double area under the roc curve of the decision tree model sys feedforward network models this table contains all model parameters for feedforward neural network models in the system column name column type column description machine learning model id uuid universally unique identifier (uuid) of the machine learning model (sys machine learning models) coefficients array(double) list of coefficients associated with the feedforward network model num arguments int number of arguments in the machine learning model data average loss double average value of the loss function sys gaussian mixture models this table contains all model parameters for gaussian mixture models column name column type column description machine learning model id uuid universally unique identifier (uuid) of the machine learning model (sys machine learning models) coefficients array(double) list of coefficients associated with the gaussian mixture model num distributions int number of distributions in the gaussian mixture model average loss double average value of the loss function sys k means models this table contains all model parameters for k means clustering models in the system column name column type column description machine learning model id uuid universally unique identifier (uuid) of the machine learning model (sys machine learning models) centroids array(double) values that represent the centroid values of each cluster num arguments int number of arguments in the machine learning model data means array(double) means of each of the feature columns in the data standard deviations array(double) standard deviations of each of the feature columns in the data sys k nearest neighbors models this table contains the number of arguments and the target table for k nearest neighbors models in the system column name column type column description machine learning model id uuid universally unique identifier (uuid) of the machine learning model (sys machine learning models) num arguments int number of arguments in the machine learning model data table name char name of the target table for the k nearest neighbors (knn) model correctly classified double percentage of training data that is correctly classified by the knn model means array(double) means of each of the feature columns in the data standard deviations array(double) standard deviations of each of the feature columns in the data sys linear combination regression models this table contains all model parameters for linear combination regression models in the system column name column type column description machine learning model id uuid universally unique identifier (uuid) of the machine learning model (sys machine learning models) coefficients array(double) list of model coefficients associated with the regression y intercept double y intercept of the regression coefficient of determination double r^2 value of the regression, if calculated, otherwise null num arguments int number of arguments in the machine learning model data rmse double root mean square error of the regression adjusted r2 double adjusted r^2 value of the regression sys linear discriminant analysis models this table contains all model parameters for linear discriminant analysis (lda) models in the system column name column type column description machine learning model id uuid universally unique identifier (uuid) of the machine learning model (sys machine learning models) coefficients array(double) list of coefficients associated with the lda model num features int number of features returned by the lda model importance array(double) importance of each of the output features that represent the data sys logistic regression models this table contains all model parameters for logistic regression models in the system column name column type column description machine learning model id uuid universally unique identifier (uuid) of the machine learning model (sys machine learning models) coefficients array(double) list of coefficients associated with the logistic regression model correctly classified double percentage of training data that is correctly classified by the logistic regression num arguments int number of arguments in the machine learning model data zero case char the case where the logistic regression uses a value of 0 one case char the case where the logistic regression uses a value of 1 classes array(char) target classes for the logistic regression sys machine learning model options this table contains options defined for each machine learning model the database stores these options as key value pairs column name column type column description machine learning model id uuid uuid of the machine learning model (sys machine learning models) machine learning model key char machine learning model configuration option key machine learning model value char machine learning model configuration option value sys machine learning models this table contains the machine learning models that are defined in the database column name column type column description id uuid universally unique identifier (uuid) of the machine learning model name char name of the machine learning model schema char schema of the machine learning model machine learning model type char type of the machine learning model database id uuid uuid of the database that contains the machine learning model definition (sys databases) on select char the select sql statement used to create this model creator id uuid the uuid of the user or group who created the machine learning model (sys users/sys groups) sys multiple linear regression models this table contains the y intercept and coefficient of determination values for the multiple linear regression machine learning models column name column type column description machine learning model id uuid universally unique identifier (uuid) of the machine learning model (sys machine learning models) y intercept double y intercept of the regression coefficient of determination double r^2 value of the regression, if calculated, otherwise null rmse double root mean square error of the regression adjusted r2 double adjusted r^2 value of the regression slopes array(double) slopes for each variable in the regression sys naive bayes models this table contains all model parameters for naive bayes classification models in the system column name column type column description machine learning model id uuid universally unique identifier (uuid) of the machine learning model (sys machine learning models) num arguments int number of arguments in the machine learning model data result probability table char name of the internal result probability table feature result matrix table char name of the internal feature result matrix table correctly classified double percentage of training data that is correctly classified by the naive bayes model sys nonlinear regression models this table contains all model parameters for nonlinear regression models in the system column name column type column description machine learning model id uuid universally unique identifier (uuid) of the machine learning model (sys machine learning models) coefficients array(double) list of coefficients associated with the nonlinear regression model coefficient of determination double r^2 value of the regression, if calculated, otherwise null num arguments int number of arguments in the machine learning model data rmse double root mean square error of the regression adjusted r2 double adjusted r^2 value of the regression sys polynomial regression models this table contains all model parameters for polynomial regression models in the system column name column type column description machine learning model id uuid universally unique identifier (uuid) of the machine learning model (sys machine learning models) coefficients array(double) list of model coefficients associated with the polynomial regression model y intercept double y intercept of the regression coefficient of determination double r^2 value of the regression, if calculated, otherwise null num arguments int number of arguments in the machine learning model data rmse double root mean square error of the regression adjusted r2 double adjusted r^2 value of the regression sys principal component analysis models this table contains all model parameters for principal component analysis (pca) models in the system column name column type column description machine learning model id uuid universally unique identifier (uuid) of the machine learning model (sys machine learning models) coefficients array(double) list of coefficients associated with the pca model num features int number of features returned by the pca model importance array(double) importance of each of the output features that represents the data means array(double) means of each of the feature columns in the data standard deviations array(double) standard deviations of each of the feature columns in the data sys random forest models this table contains all model parameters for random forest models in the system column name column type column description machine learning model id uuid universally unique identifier (uuid) of the machine learning model (sys machine learning models) vote expression char the vote expression that pulls information from the child decision trees num arguments int number of arguments in the machine learning model data num children int number of child trees in the forest correctly classified double percentage of training data that the random forest model correctly classifies area under roc double area under the roc curve of the random forest model sys simple linear regression models this table contains the slope, y intercept, and coefficient of determination values for single linear regression machine learning models column name column type column description machine learning model id uuid universally unique identifier (uuid) of the machine learning model (sys machine learning models) slope double slope of the regression y intercept double the y intercept of the regression coefficient of determination double r^2 value of the regression, if calculated, otherwise null rmse double root mean square error of the regression adjusted r2 double adjusted r^2 value of the regression sys support vector machine models this table contains all model parameters for support vector machine (svm) models in the system column name column type column description machine learning model id uuid universally unique identifier (uuid) of the machine learning model (sys machine learning models) coefficients array(double) list of coefficients associated with the svm model correctly classified double percentage of training data that is correctly classified by the svm model num arguments int number of arguments in the machine learning model data negative case char case when the svm model classifies data as negative positive case char case when the svm model classifies data as positive classes array(char) target classes for the svm model sys vector autoregression models this table contains all model parameters for vector autoregression models in the system column name column type column description machine learning model id uuid universally unique identifier (uuid) of the machine learning model (sys machine learning models) coefficients array(double) list of coefficients associated with the vector autoregression model coefficient of determination double r^2 value of the autoregression, if calculated, otherwise null monitoring sys active operator instances this table contains information about operator instances that are active in the database column name column type column description query id uuid a unique identifier of the query to which the operator belongs operator id uuid a unique identifier of the finalized operator node id uuid the unique identifier of the node that stores the information about this operator silo id long the unique identifier of the silo that stores the information about this operator core id long the unique identifier of the virtual machine core that stores the information about this operator op runtime id long the unique identifier for the operator instance that the system assigns at runtime op instance type char the name of the type for this operator instance bloom filtered rows long the rows filtered by bloom filters rows received long the number of rows fetched by the operator instance rows processed long the number of rows processed by this operator instance during execution rows emitted long the number of rows returned by the operator instance blocks emitted long the number of data blocks returned by the operator instance first block receive time timestamp the timestamp that specifies the receipt of the first data block first block emitted time timestamp the timestamp that specifies the return of the first data block num cycles long the number of cycles that run on this operator instance num oom cycles long the number of run cycles that an operator received for processing out of memory issues num failed oom cycles long the number of out of memory cycles received that failed to do any work num no work oom cycles long the number of out of memory cycles received that reported they had no work to do run count long the number of times that the scheduler has reviewed this operator and isrunnable is set to true no work cycles long the number of times that the read and write cycle executed and performed no work backed up cycles long the number of times a cycle stopped because a backup of the parent exists leaf branch blocked cycles long the number of times a cycle stopped on a leaf operator because of multi child scheduling heuristics num eof cycles long the number of end of file cycles received normal run time in ms double the time, in milliseconds, of the normal run for the operator instance dispatch queue time in ms double the time spent, in milliseconds, processing incoming message events for the operator instance oom run time in ms double the time, in milliseconds, of the out of memory issue for the operator instance max hp mem usage long the maximum heap memory usage by the operator instance num blocks written long the number of data blocks written to temporary disk num blocks read long the number of data blocks read from temporary disk num fragments written long the number of written memory fragments num fragments read long the number of read memory fragments cycles over 1 sec long the count of cycles that ran over 1 second for this operator instance cycles over 3 sec long the count of cycles that ran over 3 seconds for this operator instance long dispatch queue events long the count of dispatch queue events processed by the operator with a runtime greater than 0 5 seconds total bin stream allocated bytes long the total amount of memory allocated in output blocks for variable length column data total bin stream used bytes long the total amount of memory used in output blocks for variable length column data total col stream allocated bytes long the total amount of memory allocated in output blocks for fixed length column data total col stream used bytes long the total amount of memory used in output blocks for fixed length column data blocked received long the total number of input data blocks received by this operator instance blocked created long the total number of non trivial output data blocks created by this operator instance received block bin stream unused space bytes long the total amount of wasted space across all binary streams in received data blocks (includes over allocations as well as projected columns and dead memory) this number is null unless configuration parameters allow recording this statistic for each block because the calculation is expensive received block col stream unused space bytes long the total amount of wasted space across all column streams in received data blocks (includes over allocations as well as projected columns and dead memory) this number is null unless configuration parameters allow recording this statistic for each block because the calculation is expensive mandatory alloc attempts long the count of cycles where the scheduler enabled mandatory allocation mandatory alloc success count long the count of cycles where the scheduler enabled mandatory allocation and this operator broke an out of memory deadlock max num pending blocks long the maximum number of pending blocks across all partitions during the lifetime of this operator max num consecutive backup cycles long the maximum number of consecutive scheduler cycles where this operator has a backup the scheduler can use this information to help detect certain resource deadlocks longest time since unblocked cycle long the maximum time between successful attempts to run this operator from the scheduler the scheduler can use this information to help detect certain resource deadlocks compiled level long the level within a hierarchy of distinct operators to execute a single plan operator can be compiled into this hierarchy additional json char additional statistics for an operator instance in json format is runnable boolean whether the operator has available data to process current num pending blocks long the current number of pending blocks across all partitions of this operator sys completed operator instances this table contains information about operator instances that have finalized in the virtual machine column name column type column description database name char the database associated with the query to which the operator belongs user name char the user associated with the query to which the operator belongs query id uuid a unique identifier of the query to which the operator belongs operator id uuid a unique identifier of the finalized operator node id uuid the unique identifier of the node that stores the information about this operator silo id long the unique identifier of the silo that stores the information about this operator core id long the unique identifier of the virtual machine core that stores the information about this operator op runtime id long the unique identifier for the operator instance that the system assigns at runtime op instance type char the name of the type for this operator instance bloom filtered rows long the rows filtered by bloom filters rows received long the number of rows fetched by the operator instance rows processed long the number of rows processed by this operator instance during execution rows emitted long the number of rows returned by the operator instance blocks emitted long the number of data blocks returned by the operator instance finalization time timestamp the timestamp that represents when the operator completed all work first block receive time timestamp the timestamp that specifies the receipt of the first data block first block emitted time timestamp the timestamp that specifies the return of the first data block num cycles long the number of cycles that run on this operator instance num oom cycles long the number of run cycles that an operator received for processing out of memory issues num failed oom cycles long the number of out of memory cycles received that failed to do any work num no work oom cycles long the number of out of memory cycles received that reported they had no work to do run count long the number of times that the scheduler has reviewed this operator and isrunnable is set to true no work cycles long the number of times that the read and write cycle executed and performed no work backed up cycles long the number of times a cycle stopped because a backup of the parent exists leaf branch blocked cycles long the number of times a cycle stopped on a leaf operator because of multi child scheduling heuristics num eof cycles long the number of end of file cycles received normal run time in ms double the time, in milliseconds, of the normal run for the operator instance dispatch queue time in ms double the time spent, in milliseconds, processing incoming message events for the operator instance oom run time in ms double the time, in milliseconds, of the out of memory issue for the operator instance max hp mem usage long the maximum heap memory usage by the operator instance num blocks written long the number of data blocks written to temporary disk num blocks read long the number of data blocks read from temporary disk num fragments written long the number of written memory fragments num fragments read long the number of read memory fragments cycles over 1 sec long the count of cycles that ran over 1 second for this operator instance cycles over 3 sec long the count of cycles that ran over 3 seconds for this operator instance long dispatch queue events long the count of dispatch queue events processed by the operator with a runtime greater than 0 5 seconds total bin stream allocated bytes long the total amount of memory allocated in output blocks for variable length column data total bin stream used bytes long the total amount of memory used in output blocks for variable length column data total col stream allocated bytes long the total amount of memory allocated in output blocks for fixed length column data total col stream used bytes long the total amount of memory used in output blocks for fixed length column data blocked received long the total number of input data blocks received by this operator instance blocked created long the total number of non trivial output data blocks created by this operator instance received block bin stream unused space bytes long the total amount of wasted space across all binary streams in received data blocks (includes over allocations as well as projected columns and dead memory) this number is null unless configuration parameters allow recording this statistic for each block because the calculation is expensive received block col stream unused space bytes long the total amount of wasted space across all column streams in received data blocks (includes over allocations as well as projected columns and dead memory) this number is null unless configuration parameters allow recording this statistic for each block because the calculation is expensive mandatory alloc attempts long the count of cycles where the scheduler enabled mandatory allocation mandatory alloc success count long the count of cycles where the scheduler enabled mandatory allocation and this operator broke an out of memory deadlock max num pending blocks long the maximum number of pending blocks across all partitions during the lifetime of this operator max num consecutive backup cycles long the maximum number of consecutive scheduler cycles where this operator has a backup the scheduler can use this information to help detect certain resource deadlocks longest time since unblocked cycle long the maximum time between successful attempts to run this operator from the scheduler the scheduler can use this information to help detect certain resource deadlocks compiled level long the level within a hierarchy of distinct operators to execute a single plan operator can be compiled into this hierarchy additional json char additional statistics for an operator instance in json format sys completed queries this table contains information about queries that finished execution in the database column name column type column description query id uuid a unique identifier of the query that ran user char the name of the user that executed the query database name char the name of the database that runs this query database id uuid the unique identifier of the database this query ran in sql char the executed sql statement sql text length long the length of the sql statement referenced tables array(char) the tables and views referenced by the query total time long the total time in milliseconds the query took to run this time includes generation time, optimization time, and execution time generation time long the time in milliseconds it took to generate the query before any processing happened optimization time long the time in milliseconds the optimizer processed the query and built an optimized plan for the query execution time long time in milliseconds the query was executed by the database on the lts nodes to return the query result timestamp start timestamp a timestamp that represents the point in time when the query entered the system parsing time long the time in milliseconds the query was parsing cache lookup time long the time in milliseconds the query spent in lookup up matching cached result sets validation time long the time in milliseconds the query was validating plangen time long the time in milliseconds the query plan was being generated queue time long the time in milliseconds the query was queued in the system before any processing happened timestamp optimization start timestamp a timestamp that represents the point in time when optimization of the query started timestamp execution start timestamp a timestamp that represents the point in time when execution of the query started tree probe time long the time in milliseconds taken by the vm tree probe during query execution vm initialization time long time in milliseconds the query was initializing on all participating nodes during execution timestamp first byte sent timestamp a timestamp that represents the point in time when the first byte of the result set from the query was returned to the application timestamp complete timestamp a timestamp that represents the point in time when the execution of the query completed from the client's perspective timestamp execution complete timestamp a timestamp that represents the point in time when the internal execution of the query completed awaiting client eof fetch time long time in milliseconds that represents the difference between when the client fetched the eof for the query and when the eof was queued internally rows returned long the number of rows returned by the query bytes returned long the number of bytes returned by the query rows inserted long the number of rows that the query inserts this value is null when the database does not insert any rows the value is 0 when the database does not identify any rows to insert from a create table as select or insert as select sql statement rows deleted long the number of rows that the query deletes this value is null when the database does not delete any rows the value is 0 when the database does not identify any rows to delete from a delete from table sql statement update subquery execution time long the time in milliseconds taken by the virtual machine (vm) to execute a subquery that identifies the rows for insertion or deletion this value is null when you execute a sql statement that is not one of these statements create table as select , insert as select , or delete from table transferred bytes per second long the transfer rate in bytes per second for the result set of the query code int the sql code returned at the end of the query state char the sql state returned at the end of the query reason char a message associated with the sql code and sql state initial priority double priority based on the service class, session, and query level limits initial effective priority double initial priority adjusted for total cost and memory usage final effective priority double final dynamically adjusted priority cost estimate double the cost estimate of the optimizer concurrency service class name char name of the service class this query executes in concurrency service class id uuid the unique identifier of the service class used for the query priority adjust factor double the percentage amount by which the database adjusts the priority priority adjust time int how frequently the database adjusts the priority during query execution cached query boolean flag that indicates whether the result was returned from the result set cache resultset cached boolean flag that indicates whether the result of the query was stored in the result set cache temp disk consumed long flag that indicates the approximate total disk usage in bytes during query execution protocol version char the version of the client server protocol for this connection client ip char the ip address of the client that executed the query client name char the name of the client that executed the query client session id char the session id of the client that executed the query num client threads int the maximum number of client threads determined by the server node id uuid the unique identifier of the node that stores the information about this query participating nodes array(char) the nodes that participated in the execution of this query ocient db version char the ocient database version used to run this query ocient db commit char the ocient database git commit used to run this query ocient db dirtied commit char the dirtied ocient database git commit used to run this query max temp disk usage int the maximum temporary disk usage for this query, expressed as a percentage max elapsed time int the maximum elapsed time for this query, in seconds max rows returned long the maximum number of rows this query can return num root operator instances int the number of created root operator instances approx system peak vm node heap mem bytes long the max observed heap memory in use during execution on a single non sql vm node the memory in use is not necessarily associated with this query approx system peak vm cluster heap mem bytes long the max observed heap memory in use during execution totaled across all non sql vm nodes the memory in use is not necessarily associated with this query approx system peak vm node huge mem bytes long the max observed huge page memory in use during execution on a single non sql vm node the memory in use is not necessarily associated with this query approx system peak vm cluster huge mem bytes long the max observed huge page memory in use during execution totaled across all non sql vm nodes the memory in use is not necessarily associated with this query approx system peak sql node heap mem bytes long the max observed heap memory in use during execution on the sql node the memory in use is not necessarily associated with this query approx system peak sql node huge mem bytes long the max observed huge page memory in use during execution on the sql node the memory in use is not necessarily associated with this query driver version char the version of the client driver join order optimization time long the time, in milliseconds, the join order of the query was optimized join order optimization algorithm char the algorithm used for optimizing the join order of the query sys metric levels this table contains settings for metric levels column name column type column description match char metric name match match type char the type of match for the name of the metric level char metric level node id uuid the unique node identifier for this setting this setting might be null for system wide metrics sys node status this table contains the status of nodes in the system and the core node monitoring metrics column name column type column description node id uuid the universally unique identifier (uuid) of the node operational status char the operational status of the node values are active, starting, stopping, error, unknown, or unreachable loadavg 1 double average load on the node over the last 1 minute represents the average number of processes in the system run queue loadavg 5 double average load on the node over the last 5 minutes represents the average number of processes in the system run queue loadavg 15 double average load on the node over the last 15 minutes represents the average number of processes in the system run queue max rss long maximum resident set size (rss) of the process on the node in bytes heap long heap memory allocated on the node in bytes software start timestamp timestamp for the last start of the ocient software on the node system start timestamp timestamp for the last start of the node hardware sys op inst debug info op inst debug info test table column name column type column description operator id uuid the universally unique identifier (uuid) of the operator node id uuid the unique identifier of the node that stores the information about this operator silo id long the unique identifier of the silo that stores the information about this operator vm core id long the unique identifier of the vm core that stores the information about this operator runtime id int the process wide unique identifier of this operator instance key char debuginfo key value char debuginfo value op inst type char type of the operator instance query id uuid the uuid of the query that owns the operator sys osn acquisitions client ids for osn acquisitions column name column type column description node id uuid the universally unique identifier (uuid) of the node client id uuid the query id of the osn acquisition osn long the osn locked acquisition time timestamp timestamp that represents when the osn was acquired sys plans this table contains information about the plan for each sql statement not all sql statements have a corresponding plan (e g , some ddl statements, sql statements that have failed parsing or optimization) column name column type column description query id uuid the unique identifier of the sql query that executed user char the name of the user that executed the sql query database name char the name of the database that executes this sql query timestamp start timestamp a timestamp that represents the point in time when the query entered the system plan char the plan for the sql query sys queries this table contains information about queries that the database is currently executing column name column type column description query id uuid a unique identifier of the query that is currently running user char the name of the user that executes the query database name char the name of the database that runs this query database id uuid a unique identifier of the database this query is running in status char the statuses represent how the virtual machine (vm) tracks a specific query the statuses are awaiting slot (the query waits for a service class slot for optimization or execution ), optimizing (the ocient system optimizes the query if the system cannot optimize the query, the query skips this status and changes to the queued status ), queued (the system initializes the query in the vm ), running (the system executes the query in the vm, either by compiling the result from the foundation nodes or by fetching the results from the cache ), and finalizing (the query is complete ) sql char the sql statement that is executing sql text length long the length of the sql statement referenced tables array(char) the tables and views referenced by the query total time long the total time in milliseconds the query has run this time includes generation time, optimization time, and execution time generation time long the time in milliseconds the query was generated or is still generating this number might increase if generation is in progress optimization time long the time in milliseconds the optimizer processed or is still processing the query this number might be 0 if optimization of the query has not started yet this number might increase if optimization is in progress execution time long time in milliseconds the query executes this number might be 0 if execution of the query has not started yet this number might increase if execution of the query is still in progress timestamp start timestamp a timestamp that represents the point in time when the query entered the system parsing time long time in milliseconds the query was parsing or is still parsing this number might be 0 if parsing of the query has not started yet this number might increase if the query is still parsing cache lookup time long the time in milliseconds the query spent in lookup up matching cached result sets validation time long time in milliseconds the query was validating or is still being validated this number might be 0 if validation of the query has not started yet this number might increase if the query is still validating plangen time long time in milliseconds the query plan was being generated or is still generating this number might be 0 if generation of the query plan has not started yet this number might increase if the query plan is still generating queue time long time in milliseconds the query was queued or is still queuing this number might be 0 if queuing of the query has not started yet this number might increase if the query is still in the queue timestamp optimization start timestamp a timestamp that represents the point in time when optimization of the query started this value might be 0 if optimization has not started yet timestamp execution start timestamp a timestamp that represents the point in time when execution of the query started this value might be 0 if execution has not started yet tree probe time long time in milliseconds the query was in the vm tree probe stage during execution this number might be 0 if vm tree probe has not started yet this number might increase if the probe is still happening vm initialization time long time in milliseconds the query was initializing on all participating nodes during execution this number might be 0 if the vm has not begin initializing the query for execution yet timestamp first byte sent timestamp a timestamp that represents the point in time when the first byte of the result set from the query was returned to the application this value might be 0 if execution of the query has not started yet or no bytes have been transferred yet rows returned long the number of rows returned by the query this value might be 0 if no rows have been transferred so far bytes returned long the number of bytes returned by the query this value might be 0 if no rows have been transferred so far rows inserted long the number of rows that the query inserts this value is null when the database does not insert any rows the value is 0 when the database does not identify any rows to insert from a create table as select or insert as select sql statement rows deleted long the number of rows that the query deletes this value is null when the database does not delete any rows the value is 0 when the database does not identify any rows to delete from a delete from table sql statement update subquery execution time long the time in milliseconds taken by the vm to execute a subquery that identifies the rows for insertion and deletion this value is null when you execute a sql statement that is not one of these statements create table as select , insert as select , or delete from table initial priority double priority based on the service class, session, and query level limits initial effective priority double initial priority adjusted for total cost and memory usage effective priority double current dynamically adjusted priority estimated time int the estimate of the optimizer for the time in milliseconds to process the query estimated result rows long the estimate of the optimizer for the number of rows in the result set estimated result size long the estimate of the optimizer for the size of the result set in bytes concurrency service class name char name of the service class this query executes in concurrency service class id uuid the unique identifier of the service class used for the query priority adjust factor double the percentage amount by which the database adjusts the priority priority adjust time int how frequently the database adjusts the priority during query execution cached query boolean flag that indicates whether the result is returned from the result set cache temp disk consumed long flag that indicates the approximate total disk usage in bytes during query execution server ip ipv4 the ip address of the sql node that executed the query protocol version char the version of the client server protocol for this connection driver version char the version of the client driver client ip char the ip address of the client that executed the query client name char the name of the client that executed the query client session id char the session id of the client that executed the query num client threads int the maximum number of client threads determined by the server node id uuid the unique identifier of the node that provided the information about this query participating nodes array(varchar) the nodes that are currently known to be participating in the execution of this query if the query is not in the running state, this list might not include all nodes that participate max temp disk usage int the maximum temporary disk usage for this query, expressed as a percentage max elapsed time int the maximum elapsed time for this query, in seconds max rows returned long the maximum number of rows this query can return num root operator instances int the number of created root operator instances approx system peak vm node heap mem bytes long the max observed heap memory in use during execution on a single non sql vm node the memory in use is not necessarily associated with this query approx system peak vm cluster heap mem bytes long the max observed heap memory in use during execution totaled across all non sql vm nodes the memory in use is not necessarily associated with this query approx system peak vm node huge mem bytes long the max observed huge page memory in use during execution on a single non sql vm node the memory in use is not necessarily associated with this query approx system peak vm cluster huge mem bytes long the max observed huge page memory in use during execution totaled across all non sql vm nodes the memory in use is not necessarily associated with this query approx system peak sql node heap mem bytes long the max observed heap memory in use during execution on the sql node the memory in use is not necessarily associated with this query approx system peak sql node huge mem bytes long the max observed huge page memory in use during execution on the sql node the memory in use is not necessarily associated with this query join order optimization time long the time, in milliseconds, the join order of the query was optimized join order optimization algorithm char the algorithm used for optimizing the join order of the query sys result cache this table contains queries that have cached results in the system column name column type column description node id uuid the universally unique identifier (uuid) of the node that holds the cache results query id uuid the uuid of the query database id uuid the database of the query service class id uuid the uuid of the service class of the query timestamp long the timestamp in seconds after the unix epoch when the result set entered the cache time char the human readable time when the result set entered the cache time remaining long the amount of time remaining in seconds before the cached result set expires referenced tables array(char) all referenced tables in this query sys service role status this table contains the status of each service role on the system column name column type column description node id uuid the universally unique identifier (uuid) of the node service role id uuid the uuid of the service role (sys service roles) service role name char the human readable name of the service role on the node status char the current status of the role on this node sys storage device metrics this table contains monitoring metrics collected on each storage device that is controlled by ocient column name column type column description id char unique and persistent serial number of the drive this serial number is not a universally unique identifier (uuid) key char name of the measured statistic on the drive value char value of the named statistic on the drive transient boolean when the value is true, the value indicates that it is transient in nature and is reset when the node is restarted node id uuid the uuid of the node that contains the storage device sys storage device status this table contains real time information about the storage devices for each online node column name column type column description node id uuid the universally unique identifier (uuid) of the node that contains the storage device device id int id of the drive role name char the name of the role or roles active on the node that contains the storage device id char unique and persistent serial number of the drive this serial number is not a uuid pci address char pci address where the drive is mounted device model char model information about the drive manufacturer char manufacturer information about the drive firmware version char firmware version active on the drive capacity long capacity, in bytes, of the drive utilization long utilization, in bytes, of the drive endurance percentage used double value from 0 to 1 that represents an estimate of the percentage of the drive used, as it applies to drive endurance device status char human readable version of the drive status values are active, failed, or not present assigned drive slots array(int) list of drive slots assigned to this device the list may be empty if no slot are assigned to a device encryption drive locking supported boolean indicates whether encryption drive locking (e g , opal) is enabled on the device encryption drive locking enabled boolean indicates whether encryption drive locking (e g , opal) is supported on the device encryption drive locking status char indicates the status of drive locking (e g , opal) locked, or unlocked if drive locking is not supported, this value is unlocked silo id long the unique identifier of the silo where this device is located sys subtasks this table contains the status and details of subtasks in the system column name column type column description id uuid the task identifier name char the name of the task task type char the type of the task execution type char the type of the task execution location type char the type of the location where the task must run location id char the location where the task must run task options char the task arguments start time timestamp the start time of the task end time timestamp the end time of the task last poll time timestamp the last time that the task was polled for a status duration long the duration, in milliseconds, of the task status char the current status of the task details char the details or results of the status for the current task task owner id uuid the identifier of the node that is running the task admin owner id uuid the identifier of the node that is monitoring the task parent task id uuid the identifier of the parent task for the current task root task id uuid the identifier of the root task for the current task database id uuid the database identifier parallelization char the parallelization type of the task state binary the internal state of the task sys tasks the tasks view shows the root tasks that have been started in the system column name column type column description id uuid task identifier name char task name task type char task type execution type char task execution type location type char location type where the task must run location id char location where the task must run task options char task arguments start time timestamp task start time end time timestamp task end time last poll time timestamp last time the task was polled for status duration long task duration in milliseconds status char current task status details char current task status details or results task owner id uuid identifier of the node that is running the task admin owner id uuid identifier of the node that is monitoring the task parallelization char parallelization type of the task network sys channel endpoint parameters this table contains details for the endpoints defined on the nodes in the system column name column type column description id uuid universally unique identifier (uuid) of the channel endpoint node id uuid uuid of the node where the endpoint is located (sys nodes) name char name of the channel endpoint endpoint type char type of the channel endpoint (full or external) port int port that the channel endpoint is using ip address char ip address of the channel endpoint context type char context type of the channel endpoint listener type char listener type of the channel endpoint initiator type char initiator type of the channel endpoint encrypted boolean specifies whether the channel endpoint is encrypted sys network interface models this table contains the network devices registered on the system column name column type column description id uuid universally unique identifier (uuid) of the nic manufacturer char manufacturer of the nic model name char model name of the nic pci id char pci identifier pci subsys id char pci subsystem identifier driver type char driver type of nic bits per second long bits per second sys network interface usage types this table contains the uses of each network device in the system column name column type column description network interface id uuid universally unique identifier (uuid) of the network interface (sys network interfaces) network interface model id uuid uuid of the network interface model (sys network interface models) network type char usage type of nic (admin, data, external, local hsi) sys node network interfaces this table contains the network interfaces on each node column name column type column description network interface model id uuid universally unique identifier (uuid) of the network interface model (sys network interface models) network interface id uuid uuid of the network interface node id uuid uuid of the node where this interface exists (sys nodes) interface type char type of interface (physical, bond slave, bond master) address char mac address of the nic name char name of the nic netmask char netmask of the nic gateway char gateway of the nic pci address char pci address of the nic master interface name char master interface name of the nic bond type char network bond type of the nic sys service role channel endpoints this table contains the channel endpoint parameters that are enabled for each network type and service role column name column type column description service role id uuid the universally unique identifier (uuid) of the service role of this endpoint (sys service roles) channel endpoint parameters id uuid uuid of the parameters for this endpoint (sys channel endpoint parameters) network type char network type for this endpoint (admin, data, external, local hsi) pipelines sys pipeline errors while running a pipeline, you might experience errors these errors are often due to a mismatch between the expectation of the pipeline and the source data system or networking errors can also occur while the pipeline is running the sys pipeline errors system catalog table lists extraction, transformation, and pipeline errors column name column type column description pipeline id uuid universally unique identifier (uuid) of the pipeline (sys pipelines) that loads this partition extractor task id uuid uuid of the task associated with this pipeline run (sys subtasks) error index long error indexes start at 1 and increase monotonically as the ocient system finds them error type char the type of error values are extraction, transformation, and pipeline error error code char this 5 character code identifies the type of error source name char for file loads, this value is the absolute path of the file that includes the s3 bucket for kafka loads, the value is the topic name and partition number error message char the error message partition id char the identifier of the partition for file loads, the value is the stream source identifier where the file is located for kafka loads, this value is the partition number the combination of the partition id and record number columns uniquely identifies a record in a specific load record number long the zero based indexed record number assigned to the record in its partition that is defined according to the record number format option record offset long the zero based indexed offset in bytes of the record data in the escaped byte buffer from a chunk of the source file field index int the zero based index of the expression in the select clause of the create pipeline sql statement column name char the name of the column in the target table created at timestamp timestamp that represents when this error was created sys pipeline events while your pipeline is running, the pipeline generates events in the sys pipeline events system catalog table to mark significant checkpoints when something has occurred for details about the lists of files, see the sys pipeline files system catalog table pipeline events include messages from many different tasks these events are the background processes that execute across different loader nodes during pipeline operation for details about tasks, you can query the sys tasks and sys subtasks system catalog tables column name column type column description pipeline id uuid universally unique identifier (uuid) of the pipeline (sys pipelines) task id uuid uuid of the task associated with this pipeline run (sys subtasks) user id uuid the user who initiated the event (sys users) event type char the type of the event you can generate events with these types created, replaced, renamed, started, stopping, and stopped the ocient system generates events with these types automatically file listing started, file listing completed, completed, failed, extraction started, extraction completed, extraction failed, skipping partially loaded file, and kafka partition rebalance event message char message that provides more details about the event event timestamp timestamp timestamp that represents when this event occurred sys pipeline files for file based loads, the sys pipeline files system catalog table contains one row for each file that shows the status of the file column name column type column description pipeline id uuid universally unique identifier (uuid) of the pipeline (sys pipelines) extractor task id uuid the unique identifier of the task requested to load this file (sys subtasks) name char name of the file create timestamp timestamp timestamp that represents when this file is created modified timestamp timestamp timestamp that represents when this file is last modified size long size of the file status char the status of the file that updates throughout the process of a pipeline load values are pending (listed file but not assigned to an extractor task), queued (assigned to an extractor task but not confirmed the existence of the file), loading (confirmed existence of the file and began loading), loaded (loaded data with complete success), loaded with errors (loaded data with at least one error), failed (failed to load), and skipped (skipped loading the file) stream source id char the unique identifier of the associated partition stream source sys pipeline functions this table contains all of the pipeline functions in the system column name column type column description id uuid the universally unique identifier (uuid) of the pipeline function name char the name of the pipeline function database id uuid the uuid of the database for this pipeline function (sys databases) language char the language used to write the pipeline function return type char the return type of the pipeline function return type nullable boolean the nullable property of the return type for the pipeline function definition char the definition of the pipeline function creator id uuid the uuid of the user or group who created the pipeline function (sys users/sys groups) created at timestamp the timestamp when this pipeline function was created altered at timestamp the timestamp when this pipeline function was last updated argument names array(varchar) the argument names of the pipeline function, specified as an array argument types array(varchar) the argument types of the pipeline function, specified as an array argument nullability array(boolean) whether the argument types for the pipeline function are nullable, specified as an array imported libraries array(varchar) the import statements for the pipeline function, specified as an array sys pipeline metrics find metrics that measure the performance and activity of a pipeline in the sys pipeline metrics view this view contains one row for each metric at a specified point in time metrics are either instantaneous or incremental instantaneous metrics reflect the current value of a counter at the time of the metric collection incremental metrics increase over time and reflect the cumulative value for a specified counter the first snapshot of a metric appears when it is initialized afterward, the system updates the metric every 10 seconds each metric has a scope that defines its uniqueness do not aggregate metrics across different scopes the scope columns are pipeline id, extractor task id, partition id, and sink index if the value of any of these columns is null, the scope applies to all values in that dimension column name column type column description pipeline id uuid uuid of the pipeline (sys pipelines) loading this partition extractor task id uuid uuid of the task associated with this pipeline run (sys subtasks) partition id char the partition identifier for file based loads, this identifier is the stream source identifier for kafka loads, this identifier is the partition number sink index long the sink index this number is always null or 0 name char the name of the metric value long the value of the metric updated at timestamp timestamp that represents when this metric was updated sys pipeline metrics info find the full list of available metrics in the sys pipeline metrics info built in view this static view provides metric units, type, and descriptions column name column type column description name char name of the metric units char units of the metric metric type char type of the metric one of incremental or instantaneous description char description of the metric sys pipeline partitions for apache® kafka® partition based loads, the sys pipeline partitions system catalog table contains one row for each partition, which contains the current offsets and record counts column name column type column description pipeline id uuid universally unique identifier (uuid) of the pipeline (sys pipelines) loading this partition extractor task id uuid uuid of the task associated with this pipeline run (sys subtasks) group id char the group identifier (group id) of the pipeline that loads this partition topic name char the name of the kafka topic where this partition belongs partition number long the partition number on the kafka topic max offset long the current maximum offset on this partition last committed durable offset long the last committed offset on the partition that was indicated as durable by the ocient system this offset might lag slightly behind the actual durability of tables lag int the number of records yet to be processed in a partition, calculated as the difference between the maximum offset and the last committed durable offset records processed int the number of records processed (but not necessarily made durable) for this partition records failed int the number of failed records for this partition updated at timestamp the timestamp when the ocient system last updated the details of this partition sys pipeline tables this table contains all of the table identifiers currently associated with pipeline objects in the system column name column type column description pipeline id uuid universally unique identifier (uuid) of the pipeline (sys pipelines) table id uuid uuid of the table (sys tables) sys pipeline tasks the ocient system implements the internals of a pipeline using distributed tasks each pipeline has a unique pipeline identifier pipeline id every time that a start pipeline sql statement is executed, the ocient system generates a run pipeline task that serves as the main coordinator task this task automatically partitions the source data into smaller units and creates a run extractor task for each one then, the ocient system sends each run extractor task and executes it on a loader node in the sys pipeline tasks system catalog table, you can see the run pipeline and run extractor tasks column name column type column description pipeline id uuid universally unique identifier (uuid) of the pipeline task id uuid task identifier execution type char the type of the task parent task id uuid identifier of the parent task of the task location type char the type of location where the task must run location id char the identifier for the location where the task must run task owner id uuid identifier of the node that is running the task admin owner id uuid identifier of the node that is monitoring the task status char current task status details char the details or results of the status for the current task start time timestamp the start time of the task end time timestamp the end time of the task duration long task duration in milliseconds sys pipelines this table contains all of the pipelines in the system column name column type column description id uuid universally unique identifier (uuid) of the pipeline name char name of the pipeline database id uuid uuid of the database of the pipeline (sys databases) loading mode char specifies whether the pipeline runs in a one time (batch) or continuous (continuous) way source type char source of the data (s3, kafka, filesystem) data format char structure of the data (delimited, csv, json) created at timestamp timestamp that indicates when this pipeline was created updated at timestamp timestamp that indicates when this pipeline was last updated creator id uuid the uuid of the user or group who created the pipeline (sys users/sys groups) status char status of the pipeline (created, replaced, altered, running, stopped, completed, failed) status message char status message of the pipeline task id uuid universally unique identifier (uuid) of the task (sys tasks) pending files count long the number of files with the pending status (sys pipeline files) queued files count long the number of files with the queued status (sys pipeline files) loading files count long the number of files with the loading status (sys pipeline files) loaded files count long the number of files with the loaded status (sys pipeline files) loaded with errors files count long the number of files with the loaded with errors status (sys pipeline files) failed files count long the number of files with the failed status (sys pipeline files) skipped files count long the number of files with the skipped status (sys pipeline files) security sys security settings this table contains security settings column name column type column description database id uuid the database for this setting this might be null for system wide settings group id uuid the group for this setting when the setting is for a group password minimum length int minimum password length password complexity level int password complexity requirement password lifetime days int password lifetime in days password no repeat count int password repetition count password invalid attempt limit int invalid password attempt limit security integrations sys oidc integrations this table enumerates the configuration for openid connect single sign on integrations (i e okta®) you can modify this configuration using the alter database alter sso integration oidc ddl statement where is the name of your database column name column type column description security integration id uuid the id of this openid connect (oidc) single sign on integration database id uuid the id of the database using this single sign on authorization to this integration disabled boolean when true, all new connections made using this single sign on integration will fail default group char the group which all users of this single sign on intergation are granted membership to issuer char the complete url for the oauth 2 0 / openid connect authorization server this is the expected "iss" claim in an access token client id char the provider supplied id of this single sign on integration public client boolean when true, pkce is used in place of a client authentication method enable id token authentication boolean when true, a fat id token is sufficient to connect to the database user id claims array(char) the id token claim(s) used to identify users in audit trails additional scopes array(char) request scopes for authorization requests additional audiences array(char) additional token audience to accept when validating tokens this is useful for authorization servers without a token exchange capability groups claim ids array(char) the token claims that can be used to map the user to a database group you must provide groups claim ids if groups claim mappings is provided groups claim mappings char the mappings from provider group => database group roles claim ids array(char) the token claims that can be used to map the user to a database role you must provide roles claim ids if roles claim mappings is provided roles claim mappings char the mappings from provider role => database role blocked groups array(char) provider groups that are restricted from connecting to the database blocked roles array(char) provider roles that are restricted from connecting to the database enable debug flow boolean request scopes array(char) all request scopes for authorization requests sys oidc sessions the sys oidc sessions table contains information about active database connections established using an openid connect (oidc) single sign on integration column name column type column description id uuid the unique identifier for this session user char the fully qualified user name (fqun) of this user database id uuid the id of the database associated with this session security integration id uuid the id of the openid connect (oidc) single sign on integration that authorized has access token boolean true if the identity provider supplied an access token has refresh token boolean true if the identity provider supplied a refresh token compact id token char the jws compact serialization form of the id token id token json char the id token claims sys security integrations this table contains the oidc security integrations installed on the system column name column type column description id uuid uuid of the oidc security integration database id uuid uuid of the database associated with this security integration (sys databases) integration type char the type of the security integration (sso, scim, ldap, etc ) table descriptor char an indirect pointer to the table where you can view the objects of this integration sso integration name char sso integration name, if the security integration is of type sso is database default boolean when true, the security integration is used as the default sso integration for the database sys sessions this table contains information about active client connections column name column type column description id uuid the unique identifier for this session user char the fully qualified user name (fqun) of this user sso protocol char the single sign on (sso) protocol used to authorize the connection request null if basic password authentication was used tables exists for each sso protocol using the following naming scheme " sessions" for example, all sessions created using the openid connect (oidc) protocol will be listed in the "sys oidc sessions" table database id uuid the id of the database associated with this session default schema char the default schema used for queries submitted by this user created at timestamp long the number of seconds from epoch the session was established duration long the number of seconds since the session was established expires at timestamp long the number of seconds from epoch the session will expire is renewable boolean when true, the database will attempt to extend the session when it expires client ip char the ip address of the client client name char the human readable name of the client client session id char an opaque identifier provided by client implementations used to correlate events across application boundaries protocol version char the version of the client server protocol for this connection driver version char the version of the client driver tls enabled boolean true if tls is enabled for this client connection node id uuid the unique identifier of the node the client is connected to connectivity pool id uuid the unique identifier of the connectivity pool the client is connected on group names char names of all groups in the session role names char names of all roles in the session active service class names char names of all active service classes in the session inactive service class names char names of all inactive service classes in the session statistics sys average bb sizes this table contains the average size of bounding boxes in the database for geospatial data types column name column type column description table id uuid universally unique identifier (uuid) of the table (sys tables) column id uuid uuid of the column (sys columns) avg width double average width of bounding boxes in this column avg height double average height of bounding boxes in this column sys average column sizes this table contains the average size of each column in the database column name column type column description table id uuid universally unique identifier (uuid) of the table (sys tables) column id uuid uuid of the column (sys columns) size double average size of the column sys column cardinalities this table contains the number of unique values of each column in the database column name column type column description table id uuid universally unique identifier (uuid) of the table (sys tables) column id uuid uuid of the column (sys columns) cardinality long number of unique values in this column stats type char represents the type of values, either 'column' or 'inner array' sys column distributions this table contains some statistical characteristics of the calculated kernel density distribution of data in the database columns column name column type column description table id uuid universally unique identifier (uuid) of the table (sys tables) column id uuid uuid of the column (sys columns) bandwidth double smoothing parameter for the distribution minimum value double minimum value found in the distribution maximum value double maximum value found in the distribution stats type char represents the type of values in the distribution, either 'table' or 'inner array' sys columns compression info this table contains column level compression statistics for fixed length columns the system calculates statistics from the column data across all segments column name column type column description node id uuid universally unique identifier (uuid) of the node that owns the segments included in these statistics table id uuid uuid of the table of this column (sys tables) ordinal int ordinal of the column is deltadelta enabled boolean specifies whether deltadelta compression is enabled is rle enabled boolean specifies whether rle compression scheme is enabled is ne enabled boolean specifies whether the null elimination compression scheme is enabled raw size long size of the data in bytes before compression compressed size long size of the data in bytes after compression num deltadelta blocks long number of data blocks compressed using the deltadelta compression num rle blocks long number of data blocks compressed using the rle (run length encoding) compression scheme num nerle blocks long number of data blocks compressed using a combination of the rle and ne (null elimination) compression schemes num uncompressed blocks long number of uncompressed data blocks num total blocks long total number of data blocks id uuid uuid of the column name char name of the column sys segments compression info this table contains segment level compression statistics the system calculates statistics from the data within the specified segment all block statistics apply only to fixed length columns within the segment non block specific statistics (e g , size information) include both fixed and variable length columns column name column type column description table id uuid universally unique identifier (uuid) of the table relevant to this segment (sys tables) segment id uuid uuid for the segment num deltadelta blocks long number of data blocks compressed using deltadelta compression num rle blocks long number of data blocks compressed using rle (run length encoding) compression scheme num nerle blocks long number of data blocks compressed using a combination of rle and ne (null elimination) compression schemes num uncompressed blocks long number of uncompressed data blocks num total blocks long total number of data blocks raw size long size of the data part before any compression and without any parity data compressed size long size of the data part after compression and without any parity data + size of the manifest part compressed data part size long size of the data part after compression and without any parity data num cluster keys long number of unique cluster keys in the segment num time buckets long number of time buckets in the segment sys stats files this table contains information about the on disk cache for each foundation node of the local table probability density functions (pdfs) and array pdfs column name column type column description node id uuid the universally unique identifier (uuid) of the node references id in sys nodes table id uuid the uuid of the table references id in sys tables file id uuid the uuid of the file file type char the type of this file values are array pdf, table pdf, or table cde file size long size in bytes of the file column ordinal long ordinal of the column where the stats file applies the ordinal references sys columns for the specified table the value is null when file type is table pdf updated at timestamp timestamp of the last update to this file is stale boolean whether any rows are present on disk that were not present when this stats file was last updated rows computed from long number of rows present on the node when this stats file was last updated marked stale at timestamp timestamp of this file being marked stale sys table cardinalities this table contains the overall cardinality of the individual tables in the database column name column type column description table id uuid universally unique identifier (uuid) of the table (sys tables) cardinality long number of elements in this table sys vl columns compression info this table contains column level compression statistics for variable length columns the system calculates statistics from the column data across all segments column name column type column description node id uuid universally unique identifier (uuid) of the node that owns the segments included in these statistics table id uuid uuid of the table (sys tables) ordinal int ordinal of the column is compression enabled boolean whether compression is enabled raw size long size of the data in bytes before compression compressed size long size of the data in bytes after compression num lz4 rows long number of lz4 compressed rows num uncompressed rows long number of uncompressed rows num null rows long number of null rows num total rows long total number of rows id uuid uuid of the column name char name of the column storage sys addendum directories this table contains all addendum directories with details about their associated directories and metadata column name column type column description id uuid the identifier of the addendum directory within the storage cluster state associated directory group id char the group identifier of the associated directory associated directory ida offset int the ida offset (the logical segment in a segment directory group) of the associated directory parent segment group id char the segment group identifier of the associated parent segment (sys segment groups) parent ida offset int the ida offset of the associated parent segment segment part inventory name uuid the name of the segment part inventory for the addendum part this name references the id column of the segment part inventory system catalog table segment part inventory storage id char the storage identifier of the segment part inventory num deleted rows long if the segment part inventory houses a delete part, this number is the number of rows subtracted from the parent segment is replica for ida offset int the ida offset of the parent segment that this segment part inventory replicates sys data usage by file type and table this table contains information about the amount of queryable data by file type column name column type column description segment type char the type of the segment table name char the name for the table num segments long the number of segments of a specific segment type total rows long the total number of rows for segments of a specific segment type avg rows per segment double the average amount of rows per segment for a segment of a specific segment type total size gb double the total size in gigabytes for all segments of a specific segment type avg size mb double the average size in megabytes for segments of a specific segment type sys degraded segment groups this table contains information about degraded segment groups and the clusters where they are located column name column type column description cluster id uuid the unique identifier of the cluster cluster name char the name of the cluster segment group status char the segment group status degraded segment groups long the total number of damaged segment groups in a cluster sys degraded segment groups by table this table contains information about degraded segment groups in addition to the clusters and tables where they are located column name column type column description cluster id uuid the unique identifier of the cluster cluster name char the name of the cluster segment group status char the segment group status table name char the table name degraded segment groups long the total number of damaged segment groups in a cluster sys effective merge policy per table this table computes and displays the effective merge policy (enabled or disabled) for each table in the system the system bases the policy on the default configuration and any overrides that are present for each table column name column type column description id uuid universally unique identifier (uuid) of the table (sys tables) schema char name of the schema name char name of the table merge eligible boolean the effective merge policy for the table where true means that the table is eligible for merging its segment groups into segment directory groups sys nodes with unhealthy stored segments this table contains information about nodes with damaged, missing, or invalid segments column name column type column description node id uuid the unique identifier of the node node name char the name of the node status char the status of the stored segment values include intact, missing, and damaged num unhealthy segments long the total number of unhealthy segments in the node sys segment directories this table contains all segment directories with details about parents, associated buckets, and metadata column name column type column description segment group id char the identifier of the segment group (sys segment groups) ida offset int the unique index of the segment storage id uuid the storage identifier of the segment directory owner long the owner identifier of this stored segment begin time long start time of the bucket of this segment directory in the time bucket column of its table end time long end time of the bucket of this segment directory in the time bucket column of its table depth int the depth of the segment group a non zero value indicates a segment directory group parent segment group id char the parent identifier of the segment directory group (sys segment groups) parent ida offset int the unique index of the parent segment, if it exists parent storage id uuid the storage identifier of the parent segment directory, if it exists parent owner long the owner of the parent storage identifier a zero value indicates an unowned storage identifier whereas a non zero value indicates a segment owned after rebuild row count long if the directory depth equals 1, then this count is the number of rows in the base leaf segment (not factoring in any delete sql statements) if the depth is greater than 1, then this count is the total number of rows spanned by the intermediate directory sys segment group transfers this table contains all segment group transfers between clusters column name column type column description id uuid universally unique identifier (uuid) of the segment group transfer src cluster id uuid uuid of the source cluster (sys clusters) dst cluster id uuid uuid of the destination cluster (sys clusters) status char the status of the transfer segment group ids array(char) list of the identifiers of segment groups in this transfer (sys segment groups) src committed osn char the ownership storage number (osn) in which the segment groups are considered fully transferred from the source cluster dst committed osn char the osn in which the segment groups are considered fully transferred from the destination cluster sys segment groups this table contains all segment groups stored on the cluster with details about the ownership, associated table, data structure, and other metadata column name column type column description id char the identifier of the segment group cluster id uuid universally unique identifier (uuid) of the internal cluster of this segment group segment type char type of the segment (tkt, page, etc ) status char the availability and health status of the segment group primary owner uuid for a replicated segment group, the uuid of the node that serves the segment (sys nodes) loader id uuid the streamloader node that wrote the segment group (sys nodes) table id uuid uuid of the table (sys tables) scope id uuid uuid of the storage scope (sys storage scopes) block size long disk block size used to store segments in this group in bytes begin time long minimum bucket value, specified as an integer, for all rows in this bucket if the bucket column is a date or time value, this column has the same unit of measure as defined by the timekey column and can be converted or compared to other dates or times with appropriate conversion functions when you specify a timestamp timekey, the value represents nanoseconds since the epoch end time long maximum bucket value, specified as an integer, for all rows in this bucket if the bucket column is a date or time value, this column has the same unit of measure as defined by the timekey column and can be converted or compared to other dates or times with appropriate conversion functions when you specify a timestamp timekey, the value represents nanoseconds since the epoch coding algorithm char coding algorithm used to erasure code this group (no coding, pq parity, reed solomon) coding block size int the unit size that is erasure coded in bytes coding threshold int the number of coding blocks required to rebuild all blocks in a coding line coding width int the number of coding blocks in a coding line replication int the number of replicas of each segment in the group parity cycle int parity cycle that the system calculates by multiplying by the coding width to return the number of segments in the segment group created time timestamp specifies the time, in nanoseconds, when this segment group was created rolehostd version char the version of the rolehostd binary at the time of the segment group generation commit hash char the commit hash of the rolehostd binary at the time of the segment group generation timestamp char the build timestamp or commit timestamp of the rolehostd binary at the time of the segment group generation build user char the build user of the rolehostd binary at the time of the segment group generation depth int the depth of the segment directory group a non zero value indicates a segment directory group removal type char the method by which a segment group was removed visibility char the visibility of the segment group sys segment part inventory this table contains information about the inventory of markers for segments for example, a marker denotes whether the database can delete a specific segment part one segment can have multiple inventories, whereas each inventory contains only one marker column name column type column description id uuid the universally unique identifier (uuid) of the inventory that stores the markers for segments ida offset int the ida offset (the logical part of the segment) denotes the position within the segment parent segment group id char the identifier of the segment group where the parent segment is located parent ida offset int the ida offset where the parent segment is located within the segment group num deleted rows long the number of deleted rows operation id uuid the uuid of the query where the ocient system creates the inventory (the delete sql statement) the system shares this uuid across all inventories created in the same operation subsuming type char the type of the marker within the inventory cluster id uuid the uuid of the cluster (sys clusters) sys segment part redundancy info this table contains the redundancy strategy for each table and the segment part type column name column type column description table id uuid universally unique identifier (uuid) of the table (sys tables) part name char name of the segment part redundancy type char the redundancy strategy for this part (copy, parity) sys segment parts this table contains the segment parts associated with each segment group these segment parts belong to queryable segments the table does not display parts that belong to quarantined segments or segments not yet activated column name column type column description segment group id char the identifier of the segment group (sys segment groups) ida offset int unique index of the segment the original copy of this segment part belongs to this segment name char name of the segment part part type char partial identifier of a segment part (data, index, manifest, stats) size long size of the segment part in bytes segment ida offset int unique index of a segment within a segment group segment lba offset long offset of this segment part within the logical block address (lba) on disk sys segments this table contains the individual segments stored in each storage cluster including basic information about the segment and the segment group where the segment belongs the table contains queryable segments only quarantined segments or segments not yet activated do not appear in this table (they are present in the sys stored segments table) column name column type column description segment group id char the identifier of the segment group (sys segment groups) segment type char type of the segment (tkt or page) ida offset int unique index of the segment in the segment group row count long count of accessible rows in the segment if the count is unknown, the value is null storage id uuid universally unique identifier (uuid) for the stored segment (sys stored segments storage id) segment size long size of the segment in bytes root segment directory group id char root segment directory id, if it has been subsumed root segment directory group ida offset int root segment directory ida offset of the segment group, if it has been subsumed into a directory begin time long minimum bucket value, specified as an integer, for all rows in this bucket if the bucket column is a date or time value, this column has the same unit of measure as defined by the timekey column and can be converted or compared to other dates or times with appropriate conversion functions when you specify a timestamp timekey, the value represents nanoseconds since the epoch end time long maximum bucket value, specified as an integer, for all rows in this bucket if the bucket column is a date or time value, this column has the same unit of measure as defined by the timekey column and can be converted or compared to other dates or times with appropriate conversion functions when you specify a timestamp timekey, the value represents nanoseconds since the epoch owner long owner identifier of this stored segment num deleted rows long number of rows deleted from this segment page size with replication long specifies the replication of stored pages sys storage capacity this table contains information about storage capacity for each node column name column type column description node id uuid universally unique identifier (uuid) of the node (sys nodes) capacity bytes long approximate storage capacity of the node in bytes cluster id uuid uuid of the cluster (sys clusters) sys storage device files this table contains the list of all files for each storage device column name column type column description node id uuid the unique identifier of the node device id int the numeric identifier of the drive storage id uuid the unique identifier of the file owner int owner of the storage identifier the zero value indicates an unowned storage identifier a non zero value indicates a segment owned after the rebuild segment type char the type of the segment (tkt, page, etc ) parent id uuid the unique identifier of the parent file (for addendum parts) drive slot int theoretical drive slot, if relevant, that the ocient system computes from the segment group identifier abnormal placement boolean specifies whether the segment is placed abnormally sys storage scopes this table contains the storage scopes defined in the system with the number of rows, page groups, and segment groups in each storage scope column name column type column description id uuid universally unique identifier (uuid) of the storage scope row count long the number of rows that have been currently loaded onto the scope num page groups long the number of page groups currently present in the scope num tkt segment groups long number of tkt segment groups currently present in the scope cluster id uuid uuid of the cluster (sys clusters) sys storage spaces this table contains information for all defined storage spaces column name column type column description id uuid universally unique identifier (uuid) of the storage space name char name of the storage space is system storage space boolean is this storage space the system storage space block size int unit size that is erasure coded in bytes total width int the coding width (the n in an m of n parity configuration ) parity width int within a coding line, the number of blocks dedicated to storing parity information parity type char the methodology used to compute parity blocks (p+q, xor, reed solomon, replication, none) parity cycles int parity cycles calculated by multiplying by total width to return the number of segments in the segment group page replication int the total number of page replicas, which includes the original page sys storage used this table contains information about storage utilization for each node column name column type column description node id uuid universally unique identifier (uuid) of the node (sys nodes) table id uuid uuid of the table (sys tables) used bytes long approximate storage utilization of the table on the node in bytes cluster id uuid uuid of the cluster (sys clusters) sys stored segments this table contains details for each segment that is saved to disk column name column type column description segment group id char the identifier of the segment group (sys segment groups) cluster id uuid universally unique identifier (uuid) of the cluster (sys clusters) ida offset int index of the segment in the segment group storage id uuid uuid of this stored segment owner long owner identifier of this stored segment node id uuid uuid of the node (sys nodes) status char the current status of the segment (missing, intact, etc ) kind char the kind of segment (disk, virtual) start osn char the start osn for the latest osn range of the segment end osn char the end osn for the latest osn range of the segment visibility char whether the segment is visible abnormal placement boolean whether the segment is placed abnormally row count long count of rows in the segment segment size long size of the segment in bytes system sys clusters this table contains all clusters defined in the system column name column type column description id uuid universally unique identifier (uuid) of the cluster (sys clusters id) name char name of the cluster cluster type char type of the cluster storage space ids array(uuid) uuids of the storage spaces used in this cluster (sys storage spaces id) sys compute configurations this table contains the compute configurations for nodes and clusters in the system column name column type column description cluster id uuid universally unique identifier (uuid) of the cluster that this node belongs to (sys clusters id) node id uuid uuid of the node (sys nodes id) level long execution level for this node or cluster csn long compute sequence number sys locks this table contains information of the currently queued and granted lock requests column name column type column description request id uuid the unique identifier of the lock owner identifier char the unique identifier of the owner of the lock should be of format \<node uuid with lowercase chars> \<locking system> \<locking reason> \<process uuid> lock scope id char an identifier on the scope of the lock, should be of format \<system> \<type> \<target unique identifier> lock type char whether the lock is to read or write on the elements in its scope status char the status of the lock, queued means that it is waiting to be accepted, granted means it is currently active create time long the creation time, in milliseconds, of the lock relative to the underlying raft consensus log this value is not a unix timestamp last refresh time long the time, in milliseconds, when the lock was last refreshed relative to the underlying raft consensus log this value is not a unix timestamp priority id uuid the identifier to facilitate lock prioritization sys lts cluster info this table contains the storage clusters defined in the system column name column type column description cluster id uuid universally unique identifier (uuid) of the storage cluster (sys clusters id) storage space ids array(uuid) uuids of the storage spaces used in this cluster (sys storage spaces id) sys node clusters this table contains nodes that are members of each cluster column name column type column description cluster id uuid universally unique identifier (uuid) of the cluster that this node belongs to node id uuid uuid of the node ordinal int ordinal of this node sys nodes this table contains all nodes defined in the system column name column type column description id uuid universally unique identifier (uuid) of the node unique node number int ordinal number assigned to the node name char name of the node status char status of the node (accepted, unaccepted, invalid) hostname char hostname of the node software version char version of the software running on this node kernel version char version of the kernel running on this node system version char version of linux® running on this node system memory long amount of available system memory in bytes sockets int number of cpu sockets cores per socket int number of cores per cpu socket hugepages 1gb int number of configured 1gb huge pages hugepages 2mb int number of configured 2mb huge pages hyperthreaded boolean whether the node is hyperthreaded sys service roles this table contains the service roles defined on each node column name column type column description id uuid universally unique identifier (uuid) of the service role service role type char type of the service role node id uuid uuid of the node (sys nodes id) level char execution level of the node system information sys function signatures this table contains all function signatures defined in the system column name column type column description id uuid universally unique identifier (uuid) of the function signature name char name of the function return type char return type of the function arg types array(varchar) the types of all arguments in the function function type char type of the function sys reserved words this table contains all reserved words defined in ocient column name column type column description reserved word char a word that is a reserved keyword for use by ocient sys sql messages this table contains information about the sql errors and warnings that the ocient system can produce column name column type column description name char sql error or warning name code int sql error or warning code state char sql error or warning state reason char description of the sql error or warning is error boolean whether or not this sql message is an error or warning sys system information this table contains information about the ocient system column name column type column description id uuid universally unique identifier (uuid) for the overall system name char the name of the system this system assigns this name randomly using a uuid by default you can change the name using the alter system rename sql statement current compatible software version int the minimum software version for the system compatibility allowed compatible software version int the software version that prevents the use of features in the newest version of the system to keep backward compatibility with the specified version in the current compatible software version column feature directory merge char the value of the directory merge feature flag for segment directory groups sys system table columns this table contains all columns for tables available in the system catalog column name column type column description id uuid the universally unique identifier (uuid) of this column (sys columns) name char the name of this column data type char the data type of the column nullable boolean whether or not this column is nullable ordinal long the ordinal of this column table name char the name of the table to which this column belongs description char description of the column sys system tables this table contains all tables available in the system catalog column name column type column description id uuid universally unique identifier (uuid) of the table (sys tables) schema char schema of the table name char name of the table table type char type of the table category char category of the table description char description of the table user management sys group roles this table contains roles that belong to each group column name column type column description group id uuid universally unique identifier (uuid) of the group (sys groups) role id uuid uuid of the role (sys roles) sys groups this table contains information, including the service class, related to each group column name column type column description id uuid universally unique identifier (uuid) of the group name char name of the group database id uuid uuid of the database (sys databases) service class id uuid uuid of the service class of this group (sys service classes) sys privileges this table contains information related to the privileges granted in ocient column name column type column description timestamp timestamp timestamp of the grant given grantor char the user who granted this privilege grantee char the user who received this privilege privilege char the privilege for the grant privilege target char the type of object to which the privilege applies this value is null if the privilege applies to the granted object object type char the type of object on which this privilege was granted object id uuid universally unique identifier (uuid) of the object grantable boolean whether the user can grant this privilege to another user sys rights this table contains information related to the rights granted in ocient column name column type column description entity type char owner of the right (user, group, role) entity id uuid universally unique identifier (uuid) of the owner target type char type of the target target id uuid uuid of the target value char the right being given (create, read, update, delete, security) sys roles this table contains roles in the system column name column type column description id uuid universally unique identifier (uuid) of the role database id uuid uuid of the database of this role (sys databases) name char name of this role description char detailed description of this role sys user groups this table contains the users that belong to groups in ocient column name column type column description user id uuid universally unique identifier (uuid) of the user (sys users) group id uuid uuid of the group where the user belongs (sys groups) sys user roles this table contains roles associated with each user column name column type column description user id uuid universally unique identifier (uuid) of the user (sys users) role id uuid uuid of the role (sys roles) sys users this table contains information about users in ocient column name column type column description id uuid universally unique identifier (uuid) of the user user name char username database id uuid uuid of the database first name char first name of the user last name char last name of the user email char email address of the user password updated at timestamp timestamp that represents the date and time for the last time the password for this user was updated state char state invalid login attempts int number of invalid login attempts since last successful login workload management sys service classes this table shows information about the service classes used for workload management in ocient for more details on workload management, see the corresponding section of the user documentation column name column type column description id uuid the id of the service class database id uuid the id of the database that has the service class name char the name of the service class max temp disk usage long the maximum temporary disk usage for a query running with this service class max elapsed time long the maximum time, in seconds, that a query running with this service class can run max concurrent queries long the maximum number of queries that can run concurrently with this service class max rows returned long the maximum number of rows a query running with this service class can return scheduling priority double the initial priority for a query running with this service class cache max bytes long the maximum number of bytes in a result set, if it is eligible for cache storage, for a query running with this service class cache max time long the maximum amount of time, in seconds, that the system caches rows for a query running with this service class max elapsed time for caching long the maximum amount of time, in seconds, that a query running with this service class can run and have its result set cached this value must be higher than the max elapsed time value max columns in result set long the maximum number of columns allowed in the result set of a query running with this service class priority adjustment factor double the amount that the system adjusts the query priority in each time interval, as specified by the priority adjustment time value, for a query running with this service class priority adjustment time long the frequency, in seconds, of each priority adjustment for a query running with this service class min priority double the minimum value of the adjusted priority for a query running with this service class max priority double the maximum value of the adjusted priority for a query running with this service class statement text char specifies the comparison string to use for matching statement text to queries this string takes the format specified by the statement text matcher type field statement text matcher type char specifies the type of string comparison to use for matching statement text to queries this value must be like or regex and is required if you specify a 'statement text' field half parallelism boolean determines whether the vm uses half of the available cores for each operator in this query rather than the maximum possible parallelism setting this value can reduce overhead and latency for queries, but it significantly decreases data throughput so, updating this value should be rare outside of ocient support work load balance shuffle boolean determines whether the optimizer includes a load balancing network operator above i/o for each query this field can add latency to queries, but it will likely increase data throughput if unset, the choice is left to the optimizer so, updating this value should be rare outside of ocient support work parallelism int determines the number of parallel cores to use for each operator in the vm this value must be nonzero if unset, the choice is left to the vm so, updating this value should be rare outside of ocient support work memory optimal strategy boolean this value determines whether the optimizer and vm should attempt to lower the memory requirements of a query regardless of potential execution time penalties so, updating this value should be rare outside of ocient support work sys service classes for user the service classes for user view shows groups that each user belongs to and the service class for each group column name column type column description user name char username group name char name of the group service class name char the name of the service class related links information schema https //docs ocient com//information schema