AllowedTableTypes
Specifies what kinds of tables will be visible.
Data Type
string
Default Value
"TABLE,EXTERNAL,VIEW,MATERIALIZED_VIEW"
Remarks
This option is a comma-separated list of the table type values that the add-in displays. Any table-like or view-like entity that doesn't have a matching type will not be reported when listing tables.
- TABLE Standard tables
- EXTERNAL Read-only table stored on another service (like GCS or Drive)
- SNAPSHOT A read-only table that preserves the data of another table at a specific point in time
- VIEW Standard views
- MATERIALIZED_VIEW A view that is recalculated and cached each time its base table changes
For example, to restrict the add-in to listing only simple tables and views, this option would be set to TABLE,VIEW