source Step Type Properties

Use the sources property to add columns, groups, filters, and formulas to a step query.

Field NameDescription
columnsThe columns for the source. For more information, see columns Properties.
groupsThe dimensions to group the data in the source.
filtersThe filters applied to the columns in the source. For more information, see filters Properties
nameThe name of the data source. If the query has formula columns, they’re added as the last source without the name property.
cogroupTypeWhen there are multiple data sources with different name properties, this parameter is used to define which records are included in the blended data for this query. Valid values for cogroupType are left, right inner full. For left and right blends, the initial dataset or blend is considered the left one. For more information on data blending, see Explore Multiple Datasets with a Single Query.

When a query isn’t grouped by a dimension, set groups to ["all"]

Formula columns are defined in a separate source without a name property.