Steps To Configure Additional Domains #

1. Open the Account Data Model #

• Under Configuration > Data Models, open the Account Data Model.

2. Update the SQL Query #

Include your additional domains as a JSONB array field.

Example:

SELECT
    account_id,
    created_at,
    domain,
    -- Add the additional_domains array here as a jsonb column
    jsonb_build_array(
        'another_domain@example.com',
        'yet_another_domain@example.com'
    ) AS additional_domains,
    name
FROM accounts
LIMIT 10;

3. Update the Model Mapping #

• Under the Map Information tab, add another field called ‘additional_domains’ which is in all small with snake casing.
• Map this field to the additional_domains column that you configured in the query.

4. Save the Model #

• Validate and save these changes.

5. Refresh the Model #

• Refresh your data model for the changes to start reflecting.

Summary #

1. Add the new additional_domains field as a JSONB array in your SELECT.
2. Add additional_domains to the mapping.
3. Save and refresh.
4. Confirm the mapping in your model and outputs.