1. Home
  2. Previous Releases
  3. Latest Release
  4. Guides
  5. Concepts
  6. Tools
  7. References
    1. Apache Spark
    2. Built-in Functions
    3. Incorta Component SDK
    4. Incorta Connector SDK
    5. Connectors
    6. Data Studio
      1. Enabling the Data Studio
      2. Aggregation Recipe
      3. Change Type Recipe
      4. Data Quality Recipe
      5. Filter Recipe
      6. Formula Recipe
      7. Fuzzy Join Recipe
      8. Join Recipe
      9. Python Recipe
      10. Rename Recipe
      11. Sample Recipe
      12. Save MV Recipee
      13. Select Recipe
      14. Sort Recipe
      15. Split Recipe
      16. SQL Recipe
      17. Union Recipe
      18. Unpivot Recipe
    7. Public API
    8. Security
    9. SQL Interface
    10. Visualizations
    11. Other
  8. Integrations
  9. Data applications
  10. Releases
  11. Incorta Premium
    1. Incorta Copilot
    2. Incorta Data Studio
    3. Notebook for Business Users
    4. Spark SQL View

References → All Data Studio Recipes

The Data Studio is a rapid low-code/no-code MV development enviroment. With the Data Studio, developers can connect a series of analytical steps (Recipes) to develop an enriched dataset. Once the analytics steps are defined in the Data Studio, the developer will output the Dataflow as pySpark into a Physical Schema of their choice.

Activating the Data Studio

To activate the data studio, please refer to this guide.

Recipe Index

Recipes are foundational tools to performing data quality checks, cleansing, analysis, blending and much more.

Content Transformation

Change Type - Change the data type of column(s).
Filter - Remove records from a dataset based on a condition.
Select - Select which columns to keep or remove from a dataset.
Sort - Sort data within a dataset.
Unpivot - Transpose your dataset based into columns and values.
Formula - Add customer logic to create a new calculated field.
Sample - Select a subset of records within your dataset.
Aggregation - Aggregate youdata set and set granularity through 'group by' logic.
Rename - Rename column labels in your dataset.
Split - Split the dataset into two datasets.

Structure Transformation

Join - Join two datasets based on a set of join logic.
Union - Union two datasets together.

Data Quality and Validation

Fuzzy Join - Cleanse data through providing a lookup table.
Data Quality - Write a set of conditions and flag any violations in your dataset.

Advanced Querying

Python - Inject custom pySpark into your data flow.
SQL - Inject custom SQL into your data flow.

Deploy and Eject Operations

Save MV - Save your data flow output to a Materialized View.