# Google Cloud Data Loss Prevention v2 API - Class BigQueryOptions (4.26.0)

4.26.0 (latest) 4.25.0 4.24.0 4.23.0 4.22.0 4.21.0 4.20.0 4.19.0 4.18.0 4.17.0 4.16.0 4.15.0 4.14.0 4.13.0 4.12.0 4.11.0 4.10.0 4.9.0 4.8.0 4.7.0 4.6.0 4.5.0 4.4.0 4.3.0 4.2.0 4.1.0 4.0.0 3.5.0 3.4.0 3.3.0 3.2.0 2.16.0 2.15.0

    public sealed class BigQueryOptions : IMessage<BigQueryOptions>, IEquatable<BigQueryOptions>, IDeepCloneable<BigQueryOptions>, IBufferMessage, IMessage

Reference documentation and code samples for the Google Cloud Data Loss Prevention v2 API class BigQueryOptions.

Options defining BigQuery table and row identifiers.

## Inheritance

[object](https://learn.microsoft.com/dotnet/api/system.object) \> BigQueryOptions

## Implements

[IMessage](https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.IMessage-1.html)[BigQueryOptions](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dlp.V2/latest/Google.Cloud.Dlp.V2.BigQueryOptions), [IEquatable](https://learn.microsoft.com/dotnet/api/system.iequatable-1)[BigQueryOptions](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dlp.V2/latest/Google.Cloud.Dlp.V2.BigQueryOptions), [IDeepCloneable](https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.IDeepCloneable-1.html)[BigQueryOptions](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dlp.V2/latest/Google.Cloud.Dlp.V2.BigQueryOptions), [IBufferMessage](https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.IBufferMessage.html), [IMessage](https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.IMessage.html)

## Inherited Members

[object.GetHashCode()](https://learn.microsoft.com/dotnet/api/system.object.gethashcode) [object.GetType()](https://learn.microsoft.com/dotnet/api/system.object.gettype) [object.ToString()](https://learn.microsoft.com/dotnet/api/system.object.tostring)

## Namespace

[Google.Cloud.Dlp.V2](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dlp.V2/latest/Google.Cloud.Dlp.V2)

## Assembly

Google.Cloud.Dlp.V2.dll

## Constructors

### BigQueryOptions()

    public BigQueryOptions()

### BigQueryOptions(BigQueryOptions)

    public BigQueryOptions(BigQueryOptions other)

| **Parameter** ||
|---|---|
| **Name** | **Description** |
| `other` | `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dlp.V2/latest/Google.Cloud.Dlp.V2.BigQueryOptions` |

## Properties

### ExcludedFields

    public RepeatedField<FieldId> ExcludedFields { get; }

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.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.Collections.RepeatedField-1.htmlhttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dlp.V2/latest/Google.Cloud.Dlp.V2.FieldId` |   |

### IdentifyingFields

    public RepeatedField<FieldId> IdentifyingFields { get; }

Table fields that may uniquely identify a row within the table. When
`actions.saveFindings.outputConfig.table` is specified, the values of
columns specified here are available in the output table under
`location.content_locations.record_location.record_key.id_values`. Nested
fields such as `person.birthdate.year` are allowed.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.Collections.RepeatedField-1.htmlhttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dlp.V2/latest/Google.Cloud.Dlp.V2.FieldId` |   |

### IncludedFields

    public RepeatedField<FieldId> IncludedFields { get; }

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.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.Collections.RepeatedField-1.htmlhttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dlp.V2/latest/Google.Cloud.Dlp.V2.FieldId` |   |

### RowsLimit

    public long RowsLimit { get; set; }

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.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://learn.microsoft.com/dotnet/api/system.int64` |   |

### RowsLimitPercent

    public int RowsLimitPercent { get; set; }

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: A [known
issue](https://cloud.google.com/sensitive-data-protection/docs/known-issues#bq-sampling)
is causing the `rowsLimitPercent` field to behave unexpectedly. We
recommend using `rowsLimit` instead.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://learn.microsoft.com/dotnet/api/system.int32` |   |

### SampleMethod

    public BigQueryOptions.Types.SampleMethod SampleMethod { get; set; }

How to sample the data.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dlp.V2/latest/Google.Cloud.Dlp.V2.BigQueryOptionshttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dlp.V2/latest/Google.Cloud.Dlp.V2.BigQueryOptions.Typeshttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dlp.V2/latest/Google.Cloud.Dlp.V2.BigQueryOptions.Types.SampleMethod` |   |

### TableReference

    public BigQueryTable TableReference { get; set; }

Complete BigQuery table reference.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dlp.V2/latest/Google.Cloud.Dlp.V2.BigQueryTable` |   |