Built-In Views
The system catalog exposes a set of built-in views to merge results from various system tables.
View Name | Description | View Columns | SHOW Command | SHOW Description |
---|---|---|---|---|
sys.built_in_views | The built_in_views view shows all views that are not created by a user. This view includes helper and information schema views. | id, name, database_id, schema, query, description, view_type, global_dictionary_compression_table_id, created_at, updated_at | N/A | N/A |
sys.pipeline_tasks | The pipeline_tasks view shows tasks of all pipelines in the system. | pipeline_id, task_id, execution_type, parent_task_id, location_type, location_id, task_owner_id, admin_owner_id, status, start_time, end_time, duration | N/A | N/A |
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. | user_name, group_name, service_class_name | N/A | N/A |
sys.tasks | The tasks view shows the root tasks that have been started in the system. | id, name, task_type, execution_type, location_type, location_id, task_options, start_time, end_time, last_poll_time, duration, status, details, task_owner_id, admin_owner_id, parallelization | N/A | N/A |
sys.pipeline_metrics_info | Displays information about the metrics that might appear in sys.pipeline_metrics. | name, units, metric_type, description | N/A | N/A |
sys.pipeline_errors | The pipeline_errors view shows information for the pipeline errors in the system. | pipeline_id, extractor_task_id, error_index, error_type, error_code, source_name, error_message, partition_id, record_number, record_offset, field_index, column_name, created_at | N/A | N/A |
sys.pipeline_events | The pipeline_events view shows information for the pipeline events in the system. | pipeline_id, task_id, user_id, event_type, event_message, event_timestamp | N/A | N/A |
sys.pipeline_metrics | The pipeline_metrics view shows information for the pipeline metrics in the system. | pipeline_id, extractor_task_id, partition_id, sink_index, name, value, updated_at | N/A | N/A |
sys.pipeline_partitions | The pipeline_partitions view shows information for the active pipeline partitions in the system. | pipeline_id, extractor_task_id, group_id, topic_name, partition_number, max_offset, last_committed_durable_offset, lag, records_processed, records_failed, updated_at | N/A | N/A |
View Name | Description | View Columns | SHOW Command | SHOW Description |
---|---|---|---|---|
information_schema.columns | The columns view shows information for all columns in the system. | column_name, ordinal_position, column_default, is_nullable, data_type, table_name, table_catalog, table_schema | SHOW COLUMNS | This statement returns columns from user-defined tables and views where the current user has access. |
information_schema.data_types | The data_types view shows all data types in the system. | data_type | SHOW DATA_TYPES | This statement returns all data types in the system. |
information_schema.databases | The databases view shows all databases where the current user has access. | database_name, created_at | SHOW DATABASES | This statement returns all databases where the current user has access. |
information_schema.geometry_columns | The geometry_columns view shows information about all geometry type columns in the system. | f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, type | N/A | N/A |
information_schema.groups | The groups view shows all groups in the system. | database_name, group_name | SHOW GROUPS | This statement returns all groups in the system where the current user has read access. |
information_schema.indexes | The indexes view shows all indexes used in the system. | table_catalog, table_schema, table_name, index_name, index_type, column_name | SHOW INDEXES | This statement returns all indexes on user-defined tables where the current user has access. |
information_schema.information_schema_catalog_name | The information_schema_catalog_name view shows the current database. | catalog_name | N/A | N/A |
information_schema.pipeline_status | The pipeline_status view shows the status of all pipelines in the system. | database_name, pipeline_name, table_names, status, status_message, percent_complete, duration_seconds, files_processed, files_failed, files_remaining, files_total, records_processed, records_loaded, records_failed | SHOW PIPELINE_STATUS | This statement returns the status of all pipelines in the system where the current user has read access. |
information_schema.pipelines | The pipelines view shows all pipelines in the system. | database_name, pipeline_name, loading_mode, source_type, data_format, created_at, created_by, table_names | SHOW PIPELINES | This statement returns all pipelines in the system where the current user has read access. |
information_schema.reserved_words | The reserved_words view shows all reserved words in the system. | reserved_word | SHOW RESERVED_WORDS | This statement returns all reserved words in the system. |
information_schema.schemata | The schemata view shows information for all schemas in the system. | schema_name, catalog_name | SHOW SCHEMATA | This statement returns all user-defined schemas where the current user has access. |
information_schema.table_privileges | The table_privileges view shows information for all table privileges in the system. | grantor, grantee, table_catalog, table_schema, table_name, privilege_type, is_grantable | N/A | N/A |
information_schema.tables | The tables view shows information for all tables in the system. | table_catalog, table_schema, table_name, table_type, is_insertable_into, created_at | SHOW TABLES | This statement returns all user-defined tables where the current user has access. |
information_schema.users | The users view shows all users in the system. | database_name, user_name | SHOW USERS | This statement returns all users in the system where the current user has read access. |
information_schema.views | The views view shows information for all views in the system. | table_catalog, table_schema, table_name, view_definition, created_at, updated_at | SHOW VIEWS | This statement returns all user-defined views where the current user has access. |