Create New Data Columns With 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
Concurrent edit conflict warningIf another user has saved a newer version of the same Data Cleaning transformation since you opened the editor, clicking Save will surface a warning showing who made the more recent change and when. You can cancel to review their update or explicitly overwrite it.