Built-In Views

The system catalog exposes a set of built-in views to merge results from various system tables.
Schema sys
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
Schema information_schema
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.
Related Links
﻿SQL Reference﻿﻿
﻿Database Administration﻿﻿

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.

Updated 21 Jun 2024

Did this page help you?

System Catalog

Connection Driver Reference