ODBC Driver for Google BigQuery

Build 23.0.8839

AllowedTableTypes

Specifies what kinds of tables will be visible.

データ型

string

デフォルト値

"TABLE,EXTERNAL,VIEW,MATERIALIZED_VIEW"

解説

This option is a comma-separated list of the table type values that the 本製品 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 本製品 to listing only simple tables and views, this option would be set to TABLE,VIEW

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839