Class ProjectedField

Represents a field selected in the query, analogous to an item in a SQL SELECT clause. It specifies the source field and optionally applies transformations like aggregation, casting, regex extraction, or assigns an alias. Use ProjectedField when you need more than just the raw source field name (for which you might use FieldSource directly in QueryBuilderConfig's field_sources list if no transformations or specific operation type are needed).

Inheritance
object
ProjectedField
Implements
Inherited Members
Namespace: Google.Apis.Logging.v2.Data
Assembly: Google.Apis.Logging.v2.dll
Syntax
public class ProjectedField : IDirectResponseSchema

Properties

Alias

The alias name for the field. Valid alias examples are: - single word alias: TestAlias - numbers in an alias: Alias123 - multi word alias should be enclosed in quotes: "Test Alias" Invalid alias examples are: - alias containing keywords: WHERE, SELECT, FROM, etc. - alias starting with a number: 1stAlias

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

Cast

The cast for the field. This can any SQL cast type. Examples: - STRING - CHAR - DATE - TIMESTAMP - DATETIME

  • INT - FLOAT
Declaration
[JsonProperty("cast")]
public virtual string Cast { get; set; }
Property Value
Type Description
string

ETag

The ETag of the item.

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

Field

The field name. This will be the field that is selected using the dot notation to display the drill down value.

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

Operation

Specifies the role of this field (direct selection, grouping, or aggregation).

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

RegexExtraction

The re2 extraction for the field. This will be used to extract the value from the field using REGEXP_EXTRACT. More information on re2 can be found here: https://github.com/google/re2/wiki/Syntax. Meta characters like +?()| will need to be escaped. Examples: - ".(autoscaler.)$" will be converted to REGEXP_EXTRACT(JSON_VALUE(field),"request(.(autoscaler.*)\()")in SQL. - "\(test_value\)\)" will be converted to REGEXP_EXTRACT(JSON_VALUE(field),"request((test_value)$)") in SQL.

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

SqlAggregationFunction

The function to apply to the field.

Declaration
[JsonProperty("sqlAggregationFunction")]
public virtual FunctionApplication SqlAggregationFunction { get; set; }
Property Value
Type Description
FunctionApplication

TruncationGranularity

The truncation granularity when grouping by a time/date field. This will be used to truncate the field to the granularity specified. This can be either a date or a time granularity found at https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_trunc_granularity_date and https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_trunc_granularity_time respectively.

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

Implements