SQL Reference
System Catalog Reference

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