Class Relation

Represents a database relation.

Inheritance
object
Relation
Implements
Inherited Members
Namespace: Google.Apis.Dataform.v1beta1.Data
Assembly: Google.Apis.Dataform.v1beta1.dll
Syntax
public class Relation : IDirectResponseSchema

Properties

AdditionalOptions

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.

Declaration
[JsonProperty("additionalOptions")]
public virtual IDictionary<string, string> AdditionalOptions { get; set; }
Property Value
Type Description
IDictionary<string, string>

ClusterExpressions

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

Declaration
[JsonProperty("clusterExpressions")]
public virtual IList<string> ClusterExpressions { get; set; }
Property Value
Type Description
IList<string>

Connection

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.

Declaration
[JsonProperty("connection")]
public virtual string Connection { get; set; }
Property Value
Type Description
string

DependencyTargets

A list of actions that this action depends on.

Declaration
[JsonProperty("dependencyTargets")]
public virtual IList<Target> DependencyTargets { get; set; }
Property Value
Type Description
IList<Target>

Disabled

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

Declaration
[JsonProperty("disabled")]
public virtual bool? Disabled { get; set; }
Property Value
Type Description
bool?

ETag

The ETag of the item.

Declaration
public virtual string ETag { get; set; }
Property Value
Type Description
string

FileFormat

Optional. The file format for the BigQuery table.

Declaration
[JsonProperty("fileFormat")]
public virtual string FileFormat { get; set; }
Property Value
Type Description
string

IncrementalTableConfig

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

Declaration
[JsonProperty("incrementalTableConfig")]
public virtual IncrementalTableConfig IncrementalTableConfig { get; set; }
Property Value
Type Description
IncrementalTableConfig

PartitionExpirationDays

Sets the partition expiration in days.

Declaration
[JsonProperty("partitionExpirationDays")]
public virtual int? PartitionExpirationDays { get; set; }
Property Value
Type Description
int?

PartitionExpression

The SQL expression used to partition the relation.

Declaration
[JsonProperty("partitionExpression")]
public virtual string PartitionExpression { get; set; }
Property Value
Type Description
string

PostOperations

SQL statements to be executed after creating the relation.

Declaration
[JsonProperty("postOperations")]
public virtual IList<string> PostOperations { get; set; }
Property Value
Type Description
IList<string>

PreOperations

SQL statements to be executed before creating the relation.

Declaration
[JsonProperty("preOperations")]
public virtual IList<string> PreOperations { get; set; }
Property Value
Type Description
IList<string>

RelationDescriptor

Descriptor for the relation and its columns.

Declaration
[JsonProperty("relationDescriptor")]
public virtual RelationDescriptor RelationDescriptor { get; set; }
Property Value
Type Description
RelationDescriptor

RelationType

The type of this relation.

Declaration
[JsonProperty("relationType")]
public virtual string RelationType { get; set; }
Property Value
Type Description
string

RequirePartitionFilter

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

Declaration
[JsonProperty("requirePartitionFilter")]
public virtual bool? RequirePartitionFilter { get; set; }
Property Value
Type Description
bool?

SelectQuery

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

Declaration
[JsonProperty("selectQuery")]
public virtual string SelectQuery { get; set; }
Property Value
Type Description
string

StorageUri

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/.

Declaration
[JsonProperty("storageUri")]
public virtual string StorageUri { get; set; }
Property Value
Type Description
string

TableFormat

Optional. The table format for the BigQuery table.

Declaration
[JsonProperty("tableFormat")]
public virtual string TableFormat { get; set; }
Property Value
Type Description
string

Tags

Arbitrary, user-defined tags on this action.

Declaration
[JsonProperty("tags")]
public virtual IList<string> Tags { get; set; }
Property Value
Type Description
IList<string>

Implements