# Copyright Materialize, Inc. and contributors. All rights reserved. # # Use of this software is governed by the Business Source License # included in the LICENSE file at the root of this repository. # # As of the Change Date specified in that file, in accordance with # the Business Source License, use of this software will be governed # by the Apache License, Version 2.0. mode cockroach # Start from a pristine server reset-server statement ok CREATE DATABASE other statement ok CREATE TABLE other.public.ignored (a int) statement ok CREATE TABLE t (a int) statement ok CREATE VIEW v AS SELECT 1 statement ok CREATE MATERIALIZED VIEW mv AS SELECT 1 statement ok CREATE SOURCE s FROM LOAD GENERATOR COUNTER; mode standard query TTTT rowsort SELECT * FROM information_schema.tables; ---- materialize information_schema applicable_roles VIEW materialize information_schema character_sets VIEW materialize information_schema columns VIEW materialize information_schema enabled_roles VIEW materialize information_schema key_column_usage VIEW materialize information_schema referential_constraints VIEW materialize information_schema role_table_grants VIEW materialize information_schema routines VIEW materialize information_schema schemata VIEW materialize information_schema table_constraints VIEW materialize information_schema table_privileges VIEW materialize information_schema tables VIEW materialize information_schema triggers VIEW materialize information_schema views VIEW materialize mz_catalog mz_array_types BASE TABLE materialize mz_catalog mz_audit_events BASE TABLE materialize mz_catalog mz_aws_privatelink_connections BASE TABLE materialize mz_catalog mz_base_types BASE TABLE materialize mz_catalog mz_cluster_replica_frontiers SOURCE materialize mz_catalog mz_cluster_replica_sizes BASE TABLE materialize mz_catalog mz_cluster_replicas BASE TABLE materialize mz_catalog mz_clusters BASE TABLE materialize mz_catalog mz_columns BASE TABLE materialize mz_catalog mz_connections BASE TABLE materialize mz_catalog mz_databases BASE TABLE materialize mz_catalog mz_default_privileges BASE TABLE materialize mz_catalog mz_egress_ips BASE TABLE materialize mz_catalog mz_functions BASE TABLE materialize mz_catalog mz_index_columns BASE TABLE materialize mz_catalog mz_indexes BASE TABLE materialize mz_catalog mz_kafka_connections BASE TABLE materialize mz_catalog mz_kafka_sinks BASE TABLE materialize mz_catalog mz_kafka_sources BASE TABLE materialize mz_catalog mz_list_types BASE TABLE materialize mz_catalog mz_map_types BASE TABLE materialize mz_catalog mz_materialized_views BASE TABLE materialize mz_catalog mz_objects VIEW materialize mz_catalog mz_operators BASE TABLE materialize mz_catalog mz_pseudo_types BASE TABLE materialize mz_catalog mz_recent_storage_usage VIEW materialize mz_catalog mz_relations VIEW materialize mz_catalog mz_role_members BASE TABLE materialize mz_catalog mz_role_parameters BASE TABLE materialize mz_catalog mz_roles BASE TABLE materialize mz_catalog mz_schemas BASE TABLE materialize mz_catalog mz_secrets BASE TABLE materialize mz_catalog mz_sinks BASE TABLE materialize mz_catalog mz_sources BASE TABLE materialize mz_catalog mz_ssh_tunnel_connections BASE TABLE materialize mz_catalog mz_storage_usage VIEW materialize mz_catalog mz_system_privileges BASE TABLE materialize mz_catalog mz_tables BASE TABLE materialize mz_catalog mz_timezone_abbreviations VIEW materialize mz_catalog mz_timezone_names VIEW materialize mz_catalog mz_types BASE TABLE materialize mz_catalog mz_views BASE TABLE materialize mz_internal mz_activity_log_thinned VIEW materialize mz_internal mz_aggregates BASE TABLE materialize mz_internal mz_aws_connections BASE TABLE materialize mz_internal mz_aws_privatelink_connection_status_history SOURCE materialize mz_internal mz_aws_privatelink_connection_statuses VIEW materialize mz_internal mz_cluster_deployment_lineage VIEW materialize mz_internal mz_cluster_replica_history VIEW materialize mz_internal mz_cluster_replica_metrics VIEW materialize mz_internal mz_cluster_replica_metrics_history SOURCE materialize mz_internal mz_cluster_replica_name_history VIEW materialize mz_internal mz_cluster_replica_status_history SOURCE materialize mz_internal mz_cluster_replica_statuses VIEW materialize mz_internal mz_cluster_replica_utilization VIEW materialize mz_internal mz_cluster_replica_utilization_history VIEW materialize mz_internal mz_cluster_schedules BASE TABLE materialize mz_internal mz_cluster_workload_classes BASE TABLE materialize mz_internal mz_comments BASE TABLE materialize mz_internal mz_compute_dependencies SOURCE materialize mz_internal mz_compute_error_counts_raw_unified SOURCE materialize mz_internal mz_compute_hydration_statuses VIEW materialize mz_internal mz_compute_hydration_times SOURCE materialize mz_internal mz_compute_operator_hydration_statuses VIEW materialize mz_internal mz_compute_operator_hydration_statuses_per_worker SOURCE materialize mz_internal mz_console_cluster_utilization_overview VIEW materialize mz_internal mz_continual_tasks BASE TABLE materialize mz_internal mz_frontiers SOURCE materialize mz_internal mz_global_frontiers VIEW materialize mz_internal mz_history_retention_strategies BASE TABLE materialize mz_internal mz_hydration_statuses VIEW materialize mz_internal mz_index_advice VIEW materialize mz_internal mz_internal_cluster_replicas BASE TABLE materialize mz_internal mz_kafka_source_tables BASE TABLE materialize mz_internal mz_license_keys BASE TABLE materialize mz_internal mz_materialization_dependencies VIEW materialize mz_internal mz_materialization_lag VIEW materialize mz_internal mz_materialized_view_refresh_strategies BASE TABLE materialize mz_internal mz_materialized_view_refreshes SOURCE materialize mz_internal mz_mysql_source_tables BASE TABLE materialize mz_internal mz_network_policies BASE TABLE materialize mz_internal mz_network_policy_rules BASE TABLE materialize mz_internal mz_notices VIEW materialize mz_internal mz_notices_redacted VIEW materialize mz_internal mz_object_dependencies BASE TABLE materialize mz_internal mz_object_fully_qualified_names VIEW materialize mz_internal mz_object_history VIEW materialize mz_internal mz_object_lifetimes VIEW materialize mz_internal mz_object_oid_alias VIEW materialize mz_internal mz_object_transitive_dependencies VIEW materialize mz_internal mz_objects_id_namespace_types VIEW materialize mz_internal mz_optimizer_notices BASE TABLE materialize mz_internal mz_pending_cluster_replicas BASE TABLE materialize mz_internal mz_postgres_source_tables BASE TABLE materialize mz_internal mz_postgres_sources BASE TABLE materialize mz_internal mz_prepared_statement_history SOURCE materialize mz_internal mz_recent_activity_log VIEW materialize mz_internal mz_recent_activity_log_redacted VIEW materialize mz_internal mz_recent_activity_log_thinned VIEW materialize mz_internal mz_recent_sql_text VIEW materialize mz_internal mz_recent_sql_text_redacted VIEW materialize mz_internal mz_session_history SOURCE materialize mz_internal mz_sessions BASE TABLE materialize mz_internal mz_show_all_my_privileges VIEW materialize mz_internal mz_show_all_objects VIEW materialize mz_internal mz_show_all_privileges VIEW materialize mz_internal mz_show_cluster_privileges VIEW materialize mz_internal mz_show_cluster_replicas VIEW materialize mz_internal mz_show_clusters VIEW materialize mz_internal mz_show_columns VIEW materialize mz_internal mz_show_connections VIEW materialize mz_internal mz_show_continual_tasks VIEW materialize mz_internal mz_show_database_privileges VIEW materialize mz_internal mz_show_databases VIEW materialize mz_internal mz_show_default_privileges VIEW materialize mz_internal mz_show_indexes VIEW materialize mz_internal mz_show_materialized_views VIEW materialize mz_internal mz_show_my_cluster_privileges VIEW materialize mz_internal mz_show_my_database_privileges VIEW materialize mz_internal mz_show_my_default_privileges VIEW materialize mz_internal mz_show_my_object_privileges VIEW materialize mz_internal mz_show_my_role_members VIEW materialize mz_internal mz_show_my_schema_privileges VIEW materialize mz_internal mz_show_my_system_privileges VIEW materialize mz_internal mz_show_network_policies VIEW materialize mz_internal mz_show_object_privileges VIEW materialize mz_internal mz_show_role_members VIEW materialize mz_internal mz_show_roles VIEW materialize mz_internal mz_show_schema_privileges VIEW materialize mz_internal mz_show_schemas VIEW materialize mz_internal mz_show_secrets VIEW materialize mz_internal mz_show_sinks VIEW materialize mz_internal mz_show_sources VIEW materialize mz_internal mz_show_system_privileges VIEW materialize mz_internal mz_show_tables VIEW materialize mz_internal mz_show_types VIEW materialize mz_internal mz_show_views VIEW materialize mz_internal mz_sink_statistics VIEW materialize mz_internal mz_sink_statistics_raw SOURCE materialize mz_internal mz_sink_status_history SOURCE materialize mz_internal mz_sink_statuses VIEW materialize mz_internal mz_source_references BASE TABLE materialize mz_internal mz_source_statistics VIEW materialize mz_internal mz_source_statistics_raw SOURCE materialize mz_internal mz_source_statistics_with_history VIEW materialize mz_internal mz_source_status_history SOURCE materialize mz_internal mz_source_statuses VIEW materialize mz_internal mz_sql_server_source_tables BASE TABLE materialize mz_internal mz_sql_text SOURCE materialize mz_internal mz_sql_text_redacted VIEW materialize mz_internal mz_statement_execution_history SOURCE materialize mz_internal mz_statement_execution_history_redacted VIEW materialize mz_internal mz_statement_lifecycle_history SOURCE materialize mz_internal mz_storage_shards SOURCE materialize mz_internal mz_storage_usage_by_shard BASE TABLE materialize mz_internal mz_subscriptions BASE TABLE materialize mz_internal mz_type_pg_metadata BASE TABLE materialize mz_internal mz_wallclock_global_lag VIEW materialize mz_internal mz_wallclock_global_lag_histogram VIEW materialize mz_internal mz_wallclock_global_lag_histogram_raw SOURCE materialize mz_internal mz_wallclock_global_lag_history VIEW materialize mz_internal mz_wallclock_global_lag_recent_history VIEW materialize mz_internal mz_wallclock_lag_history SOURCE materialize mz_internal mz_webhook_sources BASE TABLE materialize mz_internal pg_attrdef_all_databases VIEW materialize mz_internal pg_attribute_all_databases VIEW materialize mz_internal pg_class_all_databases VIEW materialize mz_internal pg_description_all_databases VIEW materialize mz_internal pg_namespace_all_databases VIEW materialize mz_internal pg_type_all_databases VIEW materialize mz_introspection mz_active_peeks VIEW materialize mz_introspection mz_active_peeks_per_worker SOURCE materialize mz_introspection mz_arrangement_batcher_allocations_raw SOURCE materialize mz_introspection mz_arrangement_batcher_capacity_raw SOURCE materialize mz_introspection mz_arrangement_batcher_records_raw SOURCE materialize mz_introspection mz_arrangement_batcher_size_raw SOURCE materialize mz_introspection mz_arrangement_batches_raw SOURCE materialize mz_introspection mz_arrangement_heap_allocations_raw SOURCE materialize mz_introspection mz_arrangement_heap_capacity_raw SOURCE materialize mz_introspection mz_arrangement_heap_size_raw SOURCE materialize mz_introspection mz_arrangement_records_raw SOURCE materialize mz_introspection mz_arrangement_sharing VIEW materialize mz_introspection mz_arrangement_sharing_per_worker VIEW materialize mz_introspection mz_arrangement_sharing_raw SOURCE materialize mz_introspection mz_arrangement_sizes VIEW materialize mz_introspection mz_arrangement_sizes_per_worker VIEW materialize mz_introspection mz_compute_dataflow_global_ids_per_worker SOURCE materialize mz_introspection mz_compute_error_counts VIEW materialize mz_introspection mz_compute_error_counts_per_worker VIEW materialize mz_introspection mz_compute_error_counts_raw SOURCE materialize mz_introspection mz_compute_exports VIEW materialize mz_introspection mz_compute_exports_per_worker SOURCE materialize mz_introspection mz_compute_frontiers VIEW materialize mz_introspection mz_compute_frontiers_per_worker SOURCE materialize mz_introspection mz_compute_hydration_times_per_worker SOURCE materialize mz_introspection mz_compute_import_frontiers VIEW materialize mz_introspection mz_compute_import_frontiers_per_worker SOURCE materialize mz_introspection mz_compute_lir_mapping_per_worker SOURCE materialize mz_introspection mz_compute_operator_durations_histogram VIEW materialize mz_introspection mz_compute_operator_durations_histogram_per_worker VIEW materialize mz_introspection mz_compute_operator_durations_histogram_raw SOURCE materialize mz_introspection mz_dataflow_addresses VIEW materialize mz_introspection mz_dataflow_addresses_per_worker SOURCE materialize mz_introspection mz_dataflow_arrangement_sizes VIEW materialize mz_introspection mz_dataflow_channel_operators VIEW materialize mz_introspection mz_dataflow_channel_operators_per_worker VIEW materialize mz_introspection mz_dataflow_channels VIEW materialize mz_introspection mz_dataflow_channels_per_worker SOURCE materialize mz_introspection mz_dataflow_global_ids VIEW materialize mz_introspection mz_dataflow_operator_dataflows VIEW materialize mz_introspection mz_dataflow_operator_dataflows_per_worker VIEW materialize mz_introspection mz_dataflow_operator_parents VIEW materialize mz_introspection mz_dataflow_operator_parents_per_worker VIEW materialize mz_introspection mz_dataflow_operator_reachability VIEW materialize mz_introspection mz_dataflow_operator_reachability_per_worker VIEW materialize mz_introspection mz_dataflow_operator_reachability_raw SOURCE materialize mz_introspection mz_dataflow_operators VIEW materialize mz_introspection mz_dataflow_operators_per_worker SOURCE materialize mz_introspection mz_dataflow_shutdown_durations_histogram VIEW materialize mz_introspection mz_dataflow_shutdown_durations_histogram_per_worker VIEW materialize mz_introspection mz_dataflow_shutdown_durations_histogram_raw SOURCE materialize mz_introspection mz_dataflows VIEW materialize mz_introspection mz_dataflows_per_worker VIEW materialize mz_introspection mz_expected_group_size_advice VIEW materialize mz_introspection mz_lir_mapping VIEW materialize mz_introspection mz_mappable_objects VIEW materialize mz_introspection mz_message_batch_counts_received_raw SOURCE materialize mz_introspection mz_message_batch_counts_sent_raw SOURCE materialize mz_introspection mz_message_counts VIEW materialize mz_introspection mz_message_counts_per_worker VIEW materialize mz_introspection mz_message_counts_received_raw SOURCE materialize mz_introspection mz_message_counts_sent_raw SOURCE materialize mz_introspection mz_peek_durations_histogram VIEW materialize mz_introspection mz_peek_durations_histogram_per_worker VIEW materialize mz_introspection mz_peek_durations_histogram_raw SOURCE materialize mz_introspection mz_records_per_dataflow VIEW materialize mz_introspection mz_records_per_dataflow_operator VIEW materialize mz_introspection mz_records_per_dataflow_operator_per_worker VIEW materialize mz_introspection mz_records_per_dataflow_per_worker VIEW materialize mz_introspection mz_scheduling_elapsed VIEW materialize mz_introspection mz_scheduling_elapsed_per_worker VIEW materialize mz_introspection mz_scheduling_elapsed_raw SOURCE materialize mz_introspection mz_scheduling_parks_histogram VIEW materialize mz_introspection mz_scheduling_parks_histogram_per_worker VIEW materialize mz_introspection mz_scheduling_parks_histogram_raw SOURCE materialize pg_catalog pg_aggregate VIEW materialize pg_catalog pg_am VIEW materialize pg_catalog pg_attrdef VIEW materialize pg_catalog pg_attribute VIEW materialize pg_catalog pg_auth_members VIEW materialize pg_catalog pg_authid VIEW materialize pg_catalog pg_class VIEW materialize pg_catalog pg_collation VIEW materialize pg_catalog pg_constraint VIEW materialize pg_catalog pg_database VIEW materialize pg_catalog pg_depend VIEW materialize pg_catalog pg_description VIEW materialize pg_catalog pg_enum VIEW materialize pg_catalog pg_event_trigger VIEW materialize pg_catalog pg_extension VIEW materialize pg_catalog pg_index VIEW materialize pg_catalog pg_indexes VIEW materialize pg_catalog pg_inherits VIEW materialize pg_catalog pg_language VIEW materialize pg_catalog pg_locks VIEW materialize pg_catalog pg_matviews VIEW materialize pg_catalog pg_namespace VIEW materialize pg_catalog pg_operator VIEW materialize pg_catalog pg_policy VIEW materialize pg_catalog pg_proc VIEW materialize pg_catalog pg_range VIEW materialize pg_catalog pg_rewrite VIEW materialize pg_catalog pg_roles VIEW materialize pg_catalog pg_settings VIEW materialize pg_catalog pg_shdescription VIEW materialize pg_catalog pg_tables VIEW materialize pg_catalog pg_tablespace VIEW materialize pg_catalog pg_timezone_abbrevs VIEW materialize pg_catalog pg_timezone_names VIEW materialize pg_catalog pg_trigger VIEW materialize pg_catalog pg_type VIEW materialize pg_catalog pg_user VIEW materialize pg_catalog pg_views VIEW materialize public mv MATERIALIZED VIEW materialize public s SOURCE materialize public s_progress SOURCE materialize public t BASE TABLE materialize public v VIEW