Configuring AtScale
- Viewing and Updating Licenses
- Adding Data Warehouses
- Engine Level Configuration Settings
Managing AtScale
- Managing User Access and Security
  - Connecting to an LDAP Server
  - Configuring Kerberos
- Managing Git
  - About Git Integration
  - Managing Git Repositories in AtScale
- Managing AtScale APIs
  - Accessing the AtScale API
  - AtScale OpenAPI
- Managing Aggregates
  - Aggregate Data Security
  - Working With Aggregate Partitions
  - Dimensionally Modified Aggregates
  - Inbound SQL Hints to Control the Use and Generation of Aggregate Tables
  - Inbound SQL Session Parameters
- Monitoring Queries
  - Using the Queries Page
Working with Data Models
- AtScale Model Design Concepts

Connecting to AtScale From Business-Intelligence Software
- BI Tool Connection Support
- Getting Model Connection Information

Loading search results...

Working with Data ModelsCreating ModelsWorking with DatasetsAdding Calculated Columns to Datasets for Simple Data TransformationsExtract Values from a Map

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.

To creata a calculated column from a map, you must edit the dataset's underlying SML to include the map property. For more information, see Datasets.