public sealed class CompilationResultAction.Types.Relation.Types.IncrementalTableConfig : IMessage<CompilationResultAction.Types.Relation.Types.IncrementalTableConfig>, IEquatable<CompilationResultAction.Types.Relation.Types.IncrementalTableConfig>, IDeepCloneable<CompilationResultAction.Types.Relation.Types.IncrementalTableConfig>, IBufferMessage, IMessage
Reference documentation and code samples for the Dataform v1beta1 API class CompilationResultAction.Types.Relation.Types.IncrementalTableConfig.
Contains settings for relations of type INCREMENTAL_TABLE.
public RepeatedField<string> UniqueKeyParts { get; }
A set of columns or SQL expressions used to define row uniqueness.
If any duplicates are discovered (as defined by unique_key_parts),
only the newly selected rows (as defined by incremental_select_query)
will be included in the 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.Types.IncrementalTableConfig\u003c/code\u003e class in the Dataform v1beta1 API manages settings for \u003ccode\u003eINCREMENTAL_TABLE\u003c/code\u003e type relations.\u003c/p\u003e\n"],["\u003cp\u003eThis class allows you to define SQL statements to execute before (\u003ccode\u003eIncrementalPreOperations\u003c/code\u003e) and after (\u003ccode\u003eIncrementalPostOperations\u003c/code\u003e) inserting new rows.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eIncrementalSelectQuery\u003c/code\u003e property determines which rows should be inserted into an existing relation, and \u003ccode\u003eUniqueKeyParts\u003c/code\u003e helps identify row uniqueness.\u003c/p\u003e\n"],["\u003cp\u003e\u003ccode\u003eRefreshDisabled\u003c/code\u003e can be used to prevent the table from being refreshed, while \u003ccode\u003eUpdatePartitionFilter\u003c/code\u003e constrains the rows involved in a merge operation.\u003c/p\u003e\n"],["\u003cp\u003eThis class implements interfaces such as IMessage, IEquatable, and IDeepCloneable, and inherits members from the base object class.\u003c/p\u003e\n"]]],[],null,["# Dataform v1beta1 API - Class CompilationResultAction.Types.Relation.Types.IncrementalTableConfig (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.Types.IncrementalTableConfig)\n- [1.0.0-beta07](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/1.0.0-beta07/Google.Cloud.Dataform.V1Beta1.CompilationResultAction.Types.Relation.Types.IncrementalTableConfig) \n\n public sealed class CompilationResultAction.Types.Relation.Types.IncrementalTableConfig : IMessage\u003cCompilationResultAction.Types.Relation.Types.IncrementalTableConfig\u003e, IEquatable\u003cCompilationResultAction.Types.Relation.Types.IncrementalTableConfig\u003e, IDeepCloneable\u003cCompilationResultAction.Types.Relation.Types.IncrementalTableConfig\u003e, IBufferMessage, IMessage\n\nReference documentation and code samples for the Dataform v1beta1 API class CompilationResultAction.Types.Relation.Types.IncrementalTableConfig.\n\nContains settings for relations of type `INCREMENTAL_TABLE`. \n\nInheritance\n-----------\n\n[object](https://learn.microsoft.com/dotnet/api/system.object) \\\u003e CompilationResultAction.Types.Relation.Types.IncrementalTableConfig \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)[Types](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/latest/Google.Cloud.Dataform.V1Beta1.CompilationResultAction.Types.Relation.Types)[IncrementalTableConfig](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/latest/Google.Cloud.Dataform.V1Beta1.CompilationResultAction.Types.Relation.Types.IncrementalTableConfig), [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)[Types](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/latest/Google.Cloud.Dataform.V1Beta1.CompilationResultAction.Types.Relation.Types)[IncrementalTableConfig](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/latest/Google.Cloud.Dataform.V1Beta1.CompilationResultAction.Types.Relation.Types.IncrementalTableConfig), [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)[Types](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/latest/Google.Cloud.Dataform.V1Beta1.CompilationResultAction.Types.Relation.Types)[IncrementalTableConfig](/dotnet/docs/reference/Google.Cloud.Dataform.V1Beta1/latest/Google.Cloud.Dataform.V1Beta1.CompilationResultAction.Types.Relation.Types.IncrementalTableConfig), [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### IncrementalTableConfig()\n\n public IncrementalTableConfig()\n\n### IncrementalTableConfig(IncrementalTableConfig)\n\n public IncrementalTableConfig(CompilationResultAction.Types.Relation.Types.IncrementalTableConfig other)\n\nProperties\n----------\n\n### IncrementalPostOperations\n\n public RepeatedField\u003cstring\u003e IncrementalPostOperations { get; }\n\nSQL statements to be executed after inserting new rows into the\nrelation.\n\n### IncrementalPreOperations\n\n public RepeatedField\u003cstring\u003e IncrementalPreOperations { get; }\n\nSQL statements to be executed before inserting new rows into the\nrelation.\n\n### IncrementalSelectQuery\n\n public string IncrementalSelectQuery { get; set; }\n\nThe SELECT query which returns rows which should be inserted into the\nrelation if it already exists and is not being refreshed.\n\n### RefreshDisabled\n\n public bool RefreshDisabled { get; set; }\n\nWhether this table should be protected from being refreshed.\n\n### UniqueKeyParts\n\n public RepeatedField\u003cstring\u003e UniqueKeyParts { get; }\n\nA set of columns or SQL expressions used to define row uniqueness.\nIf any duplicates are discovered (as defined by `unique_key_parts`),\nonly the newly selected rows (as defined by `incremental_select_query`)\nwill be included in the relation.\n\n### UpdatePartitionFilter\n\n public string UpdatePartitionFilter { get; set; }\n\nA SQL expression conditional used to limit the set of existing rows\nconsidered for a merge operation (see `unique_key_parts` for more\ninformation)."]]
