Grouping: aggregating data

The “grouping” recipe allows you to perform aggregations on any dataset in Dataiku DSS, whether it’s a SQL dataset or not. This is the equivalent of a SQL “group by” statement. The recipe offers visual tools to setup the (custom) aggregations and aliases.

The “grouping” recipe can have pre-filters and post-filters. The filters documentation is available here.

See also

For more information, see also the following articles in the Knowledge Base:

• Concept | Group recipe

• Tutorial | Group recipe

Engines

Depending on the input dataset types, Dataiku DSS will adjust the engine it uses to execute the recipe, and choose between Hive, Impala, SparkSQL, plain SQL, and internal Dataiku DSS. The available engines can be seen and selected by clicking on the cog below the “Run” button.