NinjaCat Data Cloud's data cleaning tools allow splitting and combining columns already existing in the data set. There are also simple calculation features for numeric data columns. The SQL Expression feature allows your SQL-experienced team members to create brand-new columns in your data set that result from performing SQL expressions on data contained in the data set. This article explains using SQL expressions in the Data Set Explore page to create new columns.

Section Links

Access SQL Expressions

Apply SQL Expressions

Access SQL Expressions

1. After clicking on the "Data Cloud" heading in the main menu, click on the "Datasets" subheading

2. Click on the desired Dataset from the list

3. Click on "Explore Dataset" near the top right

4. To show the Data Cleaning Panel, on the Data Set Explorer page click on "Clean Data" near the top right

5. To reveal the Data Cleaning Panel, click on the small calculator icon near the far left

6. Click on the icon labeled "SQL" under "Advanced"

Apply SQL Expressions

1. New Column Name - Type the name of your new column into the field

2. Field Type - Select the field differentiation between Dimension and Metric

3. Data Type - Select the data format for the field

• Boolean
• Currency
• Date
• Number (decimal)
• Number (integer)
• Text

4. Column Expression - Enter a valid SQL column expression. Columns in the dataset can be selected by typing the @ symbol, for example @Account ID. Syntax must be a valid Snowflake column expression. Use single quotes for text values.

5. Validate - Click to check the syntax of your expression

6. Result - A preview of the results of your new column

7. Save - Click to approve expression and create a new column in your Data Set