Specifies which types of tables are visible when listing tables in the dataset.

データ型

string

デフォルト値

"TABLE,EXTERNAL,VIEW,MATERIALIZED_VIEW"

解説

This property accepts a comma-separated list of table type values. The 本製品 includes only the table types you specify when listing tables during metadata discovery. All other table-like entities are excluded from the results.

• TABLE: Standard Google BigQuery tables
• EXTERNAL: Read-only tables stored outside Google BigQuery, such as in Google Cloud Storage or Google Drive
• SNAPSHOT: Read-only tables that preserve the state of another table at a specific point in time
• VIEW: Standard Google BigQuery views
• MATERIALIZED_VIEW: Views that are automatically cached and refreshed when their base tables change

For example, to return only standard tables and views, set this property to: TABLE,VIEW.

Use this property to filter out unnecessary table types and streamline metadata results based on your application's needs.