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 v1beta1 API class CompilationResultAction.Types.Relation.
[[["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-08-28 UTC."],[[["\u003cp\u003eThe \u003ccode\u003eCompilationResultAction.Types.Relation\u003c/code\u003e class in the Dataform v1beta1 API represents a database relation and is part of the Google Cloud Platform's data management tools.\u003c/p\u003e\n"],["\u003cp\u003eThis class inherits from \u003ccode\u003eobject\u003c/code\u003e and implements several interfaces, including \u003ccode\u003eIMessage\u003c/code\u003e, \u003ccode\u003eIEquatable\u003c/code\u003e, \u003ccode\u003eIDeepCloneable\u003c/code\u003e, and \u003ccode\u003eIBufferMessage\u003c/code\u003e, providing functionalities for message handling, comparison, deep cloning, and buffer management.\u003c/p\u003e\n"],["\u003cp\u003e\u003ccode\u003eCompilationResultAction.Types.Relation\u003c/code\u003e offers properties to configure various aspects of a relation, such as \u003ccode\u003eRelationType\u003c/code\u003e, \u003ccode\u003ePartitionExpression\u003c/code\u003e, \u003ccode\u003eClusterExpressions\u003c/code\u003e, and \u003ccode\u003eIncrementalTableConfig\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eThe class supports pre- and post-operations via the \u003ccode\u003ePreOperations\u003c/code\u003e and \u003ccode\u003ePostOperations\u003c/code\u003e properties, allowing for custom SQL statements to be run before and after the relation creation.\u003c/p\u003e\n"],["\u003cp\u003eIt also allows you to disable actions with \u003ccode\u003eDisabled\u003c/code\u003e, define dependencies with \u003ccode\u003eDependencyTargets\u003c/code\u003e, manage tags with \u003ccode\u003eTags\u003c/code\u003e, and use additional key/value pairs for statement options with \u003ccode\u003eAdditionalOptions\u003c/code\u003e.\u003c/p\u003e\n"]]],[],null,["# Dataform v1beta1 API - Class CompilationResultAction.Types.Relation (1.0.0-beta08)\n\nVersion latestkeyboard_arrow_down\n\n- [1.0.0-beta08 (latest)](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/latest/Google.Cloud.Dataform.V1Beta1.CompilationResultAction.Types.Relation)\n- [1.0.0-beta07](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/1.0.0-beta07/Google.Cloud.Dataform.V1Beta1.CompilationResultAction.Types.Relation) \n\n public sealed class CompilationResultAction.Types.Relation : IMessage\u003cCompilationResultAction.Types.Relation\u003e, IEquatable\u003cCompilationResultAction.Types.Relation\u003e, IDeepCloneable\u003cCompilationResultAction.Types.Relation\u003e, IBufferMessage, IMessage\n\nReference documentation and code samples for the Dataform v1beta1 API class CompilationResultAction.Types.Relation.\n\nRepresents a database relation. \n\nInheritance\n-----------\n\n[object](https://learn.microsoft.com/dotnet/api/system.object) \\\u003e CompilationResultAction.Types.Relation \n\nImplements\n----------\n\n[IMessage](https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.IMessage-1.html)[CompilationResultAction](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/latest/Google.Cloud.Dataform.V1Beta1.CompilationResultAction)[Types](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/latest/Google.Cloud.Dataform.V1Beta1.CompilationResultAction.Types)[Relation](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/latest/Google.Cloud.Dataform.V1Beta1.CompilationResultAction.Types.Relation), [IEquatable](https://learn.microsoft.com/dotnet/api/system.iequatable-1)[CompilationResultAction](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/latest/Google.Cloud.Dataform.V1Beta1.CompilationResultAction)[Types](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/latest/Google.Cloud.Dataform.V1Beta1.CompilationResultAction.Types)[Relation](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/latest/Google.Cloud.Dataform.V1Beta1.CompilationResultAction.Types.Relation), [IDeepCloneable](https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.IDeepCloneable-1.html)[CompilationResultAction](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/latest/Google.Cloud.Dataform.V1Beta1.CompilationResultAction)[Types](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/latest/Google.Cloud.Dataform.V1Beta1.CompilationResultAction.Types)[Relation](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/latest/Google.Cloud.Dataform.V1Beta1.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) \n\nInherited Members\n-----------------\n\n[object.GetHashCode()](https://learn.microsoft.com/dotnet/api/system.object.gethashcode) \n[object.GetType()](https://learn.microsoft.com/dotnet/api/system.object.gettype) \n[object.ToString()](https://learn.microsoft.com/dotnet/api/system.object.tostring)\n\nNamespace\n---------\n\n[Google.Cloud.Dataform.V1Beta1](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/latest/Google.Cloud.Dataform.V1Beta1)\n\nAssembly\n--------\n\nGoogle.Cloud.Dataform.V1Beta1.dll\n\nConstructors\n------------\n\n### Relation()\n\n public Relation()\n\n### Relation(Relation)\n\n public Relation(CompilationResultAction.Types.Relation other)\n\nProperties\n----------\n\n### AdditionalOptions\n\n public MapField\u003cstring, string\u003e AdditionalOptions { get; }\n\nAdditional options that will be provided as key/value pairs into the\noptions clause of a create table/view statement. See\n\u003chttps://cloud.google.com/bigquery/docs/reference/standard-sql/data-definition-language\u003e\nfor more information on which options are supported.\n\n### ClusterExpressions\n\n public RepeatedField\u003cstring\u003e ClusterExpressions { get; }\n\nA list of columns or SQL expressions used to cluster the table.\n\n### DependencyTargets\n\n public RepeatedField\u003cTarget\u003e DependencyTargets { get; }\n\nA list of actions that this action depends on.\n\n### Disabled\n\n public bool Disabled { get; set; }\n\nWhether this action is disabled (i.e. should not be run).\n\n### IncrementalTableConfig\n\n public CompilationResultAction.Types.Relation.Types.IncrementalTableConfig IncrementalTableConfig { get; set; }\n\nConfigures `INCREMENTAL_TABLE` settings for this relation. Only set if\n`relation_type` is `INCREMENTAL_TABLE`.\n\n### PartitionExpirationDays\n\n public int PartitionExpirationDays { get; set; }\n\nSets the partition expiration in days.\n\n### PartitionExpression\n\n public string PartitionExpression { get; set; }\n\nThe SQL expression used to partition the relation.\n\n### PostOperations\n\n public RepeatedField\u003cstring\u003e PostOperations { get; }\n\nSQL statements to be executed after creating the relation.\n\n### PreOperations\n\n public RepeatedField\u003cstring\u003e PreOperations { get; }\n\nSQL statements to be executed before creating the relation.\n\n### RelationType\n\n public CompilationResultAction.Types.Relation.Types.RelationType RelationType { get; set; }\n\nThe type of this relation.\n\n### RequirePartitionFilter\n\n public bool RequirePartitionFilter { get; set; }\n\nSpecifies whether queries on this table must include a predicate filter\nthat filters on the partitioning column.\n\n### SelectQuery\n\n public string SelectQuery { get; set; }\n\nThe SELECT query which returns rows which this relation should contain.\n\n### Tags\n\n public RepeatedField\u003cstring\u003e Tags { get; }\n\nArbitrary, user-defined tags on this action."]]
