Specifies whether the pseudocolumns _PARTITIONDATE and _PARTITIONTIME are hidden in partitioned tables.

データ型

bool

デフォルト値

false

解説

When this property is set to false, partitioned tables include the pseudocolumns _PARTITIONDATE and _PARTITIONTIME in the reported schema. These columns can help filter queries and understand partition structure.

When set to true, the 本製品 hides these columns, matching the behavior of the native Google BigQuery 本製品 and the Google BigQuery web console.

Enable this property to suppress internal partition columns from metadata and result sets when they are not needed by your application.

Hiding these columns does not affect query execution, but may simplify schema handling in environments where internal fields are unnecessary.