1.1.0 (latest) 1.0.0

    public sealed class CompilationResultAction.Types.Relation : IMessage<CompilationResultAction.Types.Relation>, IEquatable<CompilationResultAction.Types.Relation>, IDeepCloneable<CompilationResultAction.Types.Relation>, IBufferMessage, IMessage

Reference documentation and code samples for the Dataform v1 API class CompilationResultAction.Types.Relation.

Represents a database relation.

## Inheritance

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

## Implements

[IMessage](https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.IMessage-1.html)[CompilationResultAction](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction)[Types](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types)[Relation](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types.Relation), [IEquatable](https://learn.microsoft.com/dotnet/api/system.iequatable-1)[CompilationResultAction](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction)[Types](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types)[Relation](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types.Relation), [IDeepCloneable](https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.IDeepCloneable-1.html)[CompilationResultAction](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction)[Types](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types)[Relation](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types.Relation), [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.Dataform.V1](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1)

## Assembly

Google.Cloud.Dataform.V1.dll

## Constructors

### Relation()

    public Relation()

### Relation(Relation)

    public Relation(CompilationResultAction.Types.Relation other)

| **Parameter** ||
|---|---|
| **Name** | **Description** |
| `other` | `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultActionhttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Typeshttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types.Relation` |

## Properties

### AdditionalOptions

    public MapField<string, string> AdditionalOptions { get; }

Additional options that will be provided as key/value pairs into the
options clause of a create table/view statement. See
<https://cloud.google.com/bigquery/docs/reference/standard-sql/data-definition-language>
for more information on which options are supported.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.Collections.MapField-2.htmlhttps://learn.microsoft.com/dotnet/api/system.stringhttps://learn.microsoft.com/dotnet/api/system.string` |   |

### ClusterExpressions

    public RepeatedField<string> ClusterExpressions { get; }

A list of columns or SQL expressions used to cluster the table.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.Collections.RepeatedField-1.htmlhttps://learn.microsoft.com/dotnet/api/system.string` |   |

### Connection

    public string Connection { get; set; }

Optional. The connection specifying the credentials to be used to read
and write to external storage, such as Cloud Storage. The connection can
have the form `{project}.{location}.{connection_id}` or
`projects/{project}/locations/{location}/connections/{connection_id}`,
or be set to DEFAULT.

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

### DependencyTargets

    public RepeatedField<Target> DependencyTargets { get; }

A list of actions that this action depends on.

| **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.Dataform.V1/latest/Google.Cloud.Dataform.V1.Target` |   |

### Disabled

    public bool Disabled { get; set; }

Whether this action is disabled (i.e. should not be run).

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

### FileFormat

    public CompilationResultAction.Types.Relation.Types.FileFormat FileFormat { get; set; }

Optional. The file format for the BigQuery table.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultActionhttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Typeshttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types.Relationhttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types.Relation.Typeshttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types.Relation.Types.FileFormat` |   |

### IncrementalTableConfig

    public CompilationResultAction.Types.Relation.Types.IncrementalTableConfig IncrementalTableConfig { get; set; }

Configures `INCREMENTAL_TABLE` settings for this relation. Only set if
`relation_type` is `INCREMENTAL_TABLE`.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultActionhttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Typeshttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types.Relationhttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types.Relation.Typeshttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types.Relation.Types.IncrementalTableConfig` |   |

### PartitionExpirationDays

    public int PartitionExpirationDays { get; set; }

Sets the partition expiration in days.

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

### PartitionExpression

    public string PartitionExpression { get; set; }

The SQL expression used to partition the relation.

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

### PostOperations

    public RepeatedField<string> PostOperations { get; }

SQL statements to be executed after creating the relation.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.Collections.RepeatedField-1.htmlhttps://learn.microsoft.com/dotnet/api/system.string` |   |

### PreOperations

    public RepeatedField<string> PreOperations { get; }

SQL statements to be executed before creating the relation.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.Collections.RepeatedField-1.htmlhttps://learn.microsoft.com/dotnet/api/system.string` |   |

### RelationType

    public CompilationResultAction.Types.Relation.Types.RelationType RelationType { get; set; }

The type of this relation.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultActionhttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Typeshttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types.Relationhttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types.Relation.Typeshttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types.Relation.Types.RelationType` |   |

### RequirePartitionFilter

    public bool RequirePartitionFilter { get; set; }

Specifies whether queries on this table must include a predicate filter
that filters on the partitioning column.

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

### SelectQuery

    public string SelectQuery { get; set; }

The SELECT query which returns rows which this relation should contain.

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

### StorageUri

    public string StorageUri { get; set; }

Optional. The fully qualified location prefix of the external folder
where table data is stored. The URI should be in the format
`gs://bucket/path_to_table/`.

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

### TableFormat

    public CompilationResultAction.Types.Relation.Types.TableFormat TableFormat { get; set; }

Optional. The table format for the BigQuery table.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultActionhttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Typeshttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types.Relationhttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types.Relation.Typeshttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Dataform.V1/latest/Google.Cloud.Dataform.V1.CompilationResultAction.Types.Relation.Types.TableFormat` |   |

### Tags

    public RepeatedField<string> Tags { get; }

Arbitrary, user-defined tags on this action.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.Collections.RepeatedField-1.htmlhttps://learn.microsoft.com/dotnet/api/system.string` |   |