Table fields that may uniquely identify a row within the table. Whenactions.saveFindings.outputConfig.tableis specified, the values of columns specified here are available in the output table underlocation.content_locations.record_location.record_key.id_values. Nested fields such asperson.birthdate.yearare allowed.
↳ rows_limit
int|string
Max number of rows to scan. If the table has more rows than this value, the rest of the rows are omitted. If not set, or if set to 0, all rows will be scanned. Only one of rows_limit and rows_limit_percent can be specified. Cannot be used in conjunction with TimespanConfig.
↳ rows_limit_percent
int
Max percentage of rows to scan. The rest are omitted. The number of rows scanned is rounded down. Must be between 0 and 100, inclusively. Both 0 and 100 means no limit. Defaults to 0. Only one of rows_limit and rows_limit_percent can be specified. Cannot be used in conjunction with TimespanConfig. Caution: Aknown issueis causing therowsLimitPercentfield to behave unexpectedly. We recommend usingrowsLimitinstead.
References to fields excluded from scanning. This allows you to skip inspection of entire columns which you know have no findings. When inspecting a table, we recommend that you inspect all columns. Otherwise, findings might be affected because hints from excluded columns will not be used.
Limit scanning only to these fields. When inspecting a table, we recommend that you inspect all columns. Otherwise, findings might be affected because hints from excluded columns will not be used.
Table fields that may uniquely identify a row within the table. Whenactions.saveFindings.outputConfig.tableis specified, the values of
columns specified here are available in the output table underlocation.content_locations.record_location.record_key.id_values. Nested
fields such asperson.birthdate.yearare allowed.
Table fields that may uniquely identify a row within the table. Whenactions.saveFindings.outputConfig.tableis specified, the values of
columns specified here are available in the output table underlocation.content_locations.record_location.record_key.id_values. Nested
fields such asperson.birthdate.yearare allowed.
Max number of rows to scan. If the table has more rows than this value, the
rest of the rows are omitted. If not set, or if set to 0, all rows will be
scanned. Only one of rows_limit and rows_limit_percent can be specified.
Cannot be used in conjunction with TimespanConfig.
Returns
Type
Description
int|string
setRowsLimit
Max number of rows to scan. If the table has more rows than this value, the
rest of the rows are omitted. If not set, or if set to 0, all rows will be
scanned. Only one of rows_limit and rows_limit_percent can be specified.
Cannot be used in conjunction with TimespanConfig.
Parameter
Name
Description
var
int|string
Returns
Type
Description
$this
getRowsLimitPercent
Max percentage of rows to scan. The rest are omitted. The number of rows
scanned is rounded down. Must be between 0 and 100, inclusively. Both 0 and
100 means no limit. Defaults to 0. Only one of rows_limit and
rows_limit_percent can be specified. Cannot be used in conjunction with
TimespanConfig.
Caution: Aknown
issueis causing therowsLimitPercentfield to behave unexpectedly. We
recommend usingrowsLimitinstead.
Returns
Type
Description
int
setRowsLimitPercent
Max percentage of rows to scan. The rest are omitted. The number of rows
scanned is rounded down. Must be between 0 and 100, inclusively. Both 0 and
100 means no limit. Defaults to 0. Only one of rows_limit and
rows_limit_percent can be specified. Cannot be used in conjunction with
TimespanConfig.
Caution: Aknown
issueis causing therowsLimitPercentfield to behave unexpectedly. We
recommend usingrowsLimitinstead.
Parameter
Name
Description
var
int
Returns
Type
Description
$this
getSampleMethod
How to sample the data.
Returns
Type
Description
int
setSampleMethod
How to sample the data.
Parameter
Name
Description
var
int
Returns
Type
Description
$this
getExcludedFields
References to fields excluded from scanning. This allows you to skip
inspection of entire columns which you know have no findings.
When inspecting a table, we recommend that you inspect all columns.
Otherwise, findings might be affected because hints from excluded columns
will not be used.
References to fields excluded from scanning. This allows you to skip
inspection of entire columns which you know have no findings.
When inspecting a table, we recommend that you inspect all columns.
Otherwise, findings might be affected because hints from excluded columns
will not be used.
When inspecting a table, we recommend that you inspect all columns.
Otherwise, findings might be affected because hints from excluded columns
will not be used.
When inspecting a table, we recommend that you inspect all columns.
Otherwise, findings might be affected because hints from excluded columns
will not be used.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-09-04 UTC."],[],[],null,["# Data Loss Prevention V2 Client - Class BigQueryOptions (2.6.1)\n\nVersion latestkeyboard_arrow_down\n\n- [2.6.1 (latest)](/php/docs/reference/cloud-dlp/latest/V2.BigQueryOptions)\n- [2.6.0](/php/docs/reference/cloud-dlp/2.6.0/V2.BigQueryOptions)\n- [2.4.1](/php/docs/reference/cloud-dlp/2.4.1/V2.BigQueryOptions)\n- [2.3.0](/php/docs/reference/cloud-dlp/2.3.0/V2.BigQueryOptions)\n- [2.2.3](/php/docs/reference/cloud-dlp/2.2.3/V2.BigQueryOptions)\n- [2.1.0](/php/docs/reference/cloud-dlp/2.1.0/V2.BigQueryOptions)\n- [2.0.0](/php/docs/reference/cloud-dlp/2.0.0/V2.BigQueryOptions)\n- [1.19.0](/php/docs/reference/cloud-dlp/1.19.0/V2.BigQueryOptions)\n- [1.18.0](/php/docs/reference/cloud-dlp/1.18.0/V2.BigQueryOptions)\n- [1.17.0](/php/docs/reference/cloud-dlp/1.17.0/V2.BigQueryOptions)\n- [1.16.0](/php/docs/reference/cloud-dlp/1.16.0/V2.BigQueryOptions)\n- [1.15.1](/php/docs/reference/cloud-dlp/1.15.1/V2.BigQueryOptions)\n- [1.14.0](/php/docs/reference/cloud-dlp/1.14.0/V2.BigQueryOptions)\n- [1.13.2](/php/docs/reference/cloud-dlp/1.13.2/V2.BigQueryOptions)\n- [1.12.0](/php/docs/reference/cloud-dlp/1.12.0/V2.BigQueryOptions)\n- [1.11.0](/php/docs/reference/cloud-dlp/1.11.0/V2.BigQueryOptions)\n- [1.10.2](/php/docs/reference/cloud-dlp/1.10.2/V2.BigQueryOptions)\n- [1.9.0](/php/docs/reference/cloud-dlp/1.9.0/V2.BigQueryOptions)\n- [1.8.6](/php/docs/reference/cloud-dlp/1.8.6/V2.BigQueryOptions) \nReference documentation and code samples for the Data Loss Prevention V2 Client class BigQueryOptions.\n\nOptions defining BigQuery table and row identifiers.\n\nGenerated from protobuf message `google.privacy.dlp.v2.BigQueryOptions`\n\nNamespace\n---------\n\nGoogle \\\\ Cloud \\\\ Dlp \\\\ V2\n\nMethods\n-------\n\n### __construct\n\nConstructor.\n\n### getTableReference\n\nComplete BigQuery table reference.\n\n### hasTableReference\n\n### clearTableReference\n\n### setTableReference\n\nComplete BigQuery table reference.\n\n### getIdentifyingFields\n\nTable fields that may uniquely identify a row within the table. When\n`actions.saveFindings.outputConfig.table` is specified, the values of\ncolumns specified here are available in the output table under\n`location.content_locations.record_location.record_key.id_values`. Nested\nfields such as `person.birthdate.year` are allowed.\n\n### setIdentifyingFields\n\nTable fields that may uniquely identify a row within the table. When\n`actions.saveFindings.outputConfig.table` is specified, the values of\ncolumns specified here are available in the output table under\n`location.content_locations.record_location.record_key.id_values`. Nested\nfields such as `person.birthdate.year` are allowed.\n\n### getRowsLimit\n\nMax number of rows to scan. If the table has more rows than this value, the\nrest of the rows are omitted. If not set, or if set to 0, all rows will be\nscanned. Only one of rows_limit and rows_limit_percent can be specified.\n\nCannot be used in conjunction with TimespanConfig.\n\n### setRowsLimit\n\nMax number of rows to scan. If the table has more rows than this value, the\nrest of the rows are omitted. If not set, or if set to 0, all rows will be\nscanned. Only one of rows_limit and rows_limit_percent can be specified.\n\nCannot be used in conjunction with TimespanConfig.\n\n### getRowsLimitPercent\n\nMax percentage of rows to scan. The rest are omitted. The number of rows\nscanned is rounded down. Must be between 0 and 100, inclusively. Both 0 and\n100 means no limit. Defaults to 0. Only one of rows_limit and\nrows_limit_percent can be specified. Cannot be used in conjunction with\nTimespanConfig.\n\nCaution: A [known\nissue](https://cloud.google.com/sensitive-data-protection/docs/known-issues#bq-sampling)\nis causing the `rowsLimitPercent` field to behave unexpectedly. We\nrecommend using `rowsLimit` instead.\n\n### setRowsLimitPercent\n\nMax percentage of rows to scan. The rest are omitted. The number of rows\nscanned is rounded down. Must be between 0 and 100, inclusively. Both 0 and\n100 means no limit. Defaults to 0. Only one of rows_limit and\nrows_limit_percent can be specified. Cannot be used in conjunction with\nTimespanConfig.\n\nCaution: A [known\nissue](https://cloud.google.com/sensitive-data-protection/docs/known-issues#bq-sampling)\nis causing the `rowsLimitPercent` field to behave unexpectedly. We\nrecommend using `rowsLimit` instead.\n\n### getSampleMethod\n\nHow to sample the data.\n\n### setSampleMethod\n\nHow to sample the data.\n\n### getExcludedFields\n\nReferences to fields excluded from scanning. This allows you to skip\ninspection of entire columns which you know have no findings.\n\nWhen inspecting a table, we recommend that you inspect all columns.\nOtherwise, findings might be affected because hints from excluded columns\nwill not be used.\n\n### setExcludedFields\n\nReferences to fields excluded from scanning. This allows you to skip\ninspection of entire columns which you know have no findings.\n\nWhen inspecting a table, we recommend that you inspect all columns.\nOtherwise, findings might be affected because hints from excluded columns\nwill not be used.\n\n### getIncludedFields\n\nLimit scanning only to these fields.\n\nWhen inspecting a table, we recommend that you inspect all columns.\nOtherwise, findings might be affected because hints from excluded columns\nwill not be used.\n\n### setIncludedFields\n\nLimit scanning only to these fields.\n\nWhen inspecting a table, we recommend that you inspect all columns.\nOtherwise, findings might be affected because hints from excluded columns\nwill not be used."]]