Adding Calculated Columns to Datasets for Simple Data Transformations

📄️ Calculated Column FAQs

This section answers the most frequently asked questions (FAQs) about creating and using calculated columns in an AtScale model.

📄️ AtScale Internal Data Types

The following table lists the AtScale internal data types and the corresponding external SQL data types supported by data warehouses.

📄️ Add a Calculated Column to a Dataset

You can add a calculated column to any dataset that you have imported into a project. Calculated columns are retained in the repository even when you remove the dataset from the model.

📄️ Troubleshoot Invalid Calculated Columns

When you add a calculated column to a dataset, AtScale tests the validity of the formula. If the formula is invalid, you must fix it and retest before saving. This section describes the most common causes of invalid formulas.

📄️ Extract Values from a Map

A MAP type column contains a delimited list of key:value pairs. Map columns are imported into AtScale as STRING type columns. Although AtScale does not support the MAP data type, you can create calculated columns from strings containing maps. This generates a calculated column formula using the REGEXP_EXTRACT function.