BigQuery data types

The following table contains the BigQuery masking rule that Protect supports for a given BigQuery data type.

  • Protect supports the BigQuery Default masking value rule for all types of columns.
  • Protect does not support the BigQuery Nullify rule for any type of column.
  • Protect supports the BigQuery Hash (SHA256) rule only for the following types of columns: BYTES, STRING.
BigQuery data type BigQuery masking rule supported by Protect
ARRAY Default masking value
BIGNUMERIC Default masking value
BOOL Default masking value
BYTES
  • Default masking value
  • Hash (SHA256)
DATE Default masking value
DATETIME Default masking value
FLOAT64 Default masking value
GEOGRAPHY Default masking value
INT64 Default masking value
INTERVAL Default masking value
JSON Default masking value
NUMERIC Default masking value
STRING
  • Default masking value
  • Hash (SHA256)
STRUCT Default masking value
TIME Default masking value
TIMESTAMP Default masking value