em-data-insights Chart

em-data-insights deploys the CRAFT Data Insights solution — a superset of em-core that adds the data analysis agent and Redshift connector.

Components

em-data-insights includes all em-core components plus:

Component	Purpose
`em-data-insights-agent`	Data analysis and insights generation A2A agent
`em-redshift-query-connector`	AWS Redshift query connector service

Quick start

Set environment variables

export HOSTNAME=platform.example.com
export KEYCLOAK_ADMIN_PASSWORD=<secure-password>
export POSTGRES_PASSWORD=<secure-password>
export REDSHIFT_HOST=<your-redshift-endpoint>
export REDSHIFT_USER=<redshift-user>
export REDSHIFT_PASSWORD=<redshift-password>

Create namespace

kubectl create namespace em-data-insights

Create secrets

# Platform credentials (Keycloak + PostgreSQL)
kubectl create secret generic em-data-insights-credentials \
  --namespace em-data-insights \
  --from-literal=KEYCLOAK_ADMIN_PASSWORD=$KEYCLOAK_ADMIN_PASSWORD \
  --from-literal=POSTGRES_PASSWORD=$POSTGRES_PASSWORD

# Redshift credentials — must be named 'redshift' with these exact keys
kubectl create secret generic redshift \
  --namespace em-data-insights \
  --from-literal=redshift-host=$REDSHIFT_HOST \
  --from-literal=redshift-port=${REDSHIFT_PORT:-5439} \
  --from-literal=redshift-database=$REDSHIFT_DATABASE \
  --from-literal=redshift-username=$REDSHIFT_USER \
  --from-literal=redshift-password=$REDSHIFT_PASSWORD

Install the chart

helm install em-data-insights oci://ghcr.io/emergenceai/em-charts/em-data-insights \
  --version 0.0.8 \
  --namespace em-data-insights \
  --set em-core.hostname=$HOSTNAME \
  --set em-core.schema=http

Redshift integration

Configure the Redshift connector in your values:

em-redshift-query-connector:
  env:
    REDSHIFT_DATABASE: my_database
    REDSHIFT_PORT: "5439"
  envVars:
    - name: REDSHIFT_HOST
      valueFrom:
        secretKeyRef:
          name: redshift
          key: redshift-host
    - name: REDSHIFT_USERNAME
      valueFrom:
        secretKeyRef:
          name: redshift
          key: redshift-username
    - name: REDSHIFT_PASSWORD
      valueFrom:
        secretKeyRef:
          name: redshift
          key: redshift-password

Using external databases

Disable bundled PostgreSQL and Redis for production:

postgresql:
  enabled: false

redis:
  enabled: false

postgresql:
  existingSecret: my-external-db-credentials

redis:
  existingSecret: my-external-db-credentials

Key values

Value	Default	Description
`em-core.hostname`	`localhost`	External hostname (passed to em-core subchart)
`em-core.schema`	`http`	`http` or `https`
`em-data-insights-agent.image.repository`	`ghcr.io/emergenceai/em-data-insights-agent`	Agent image
`em-redshift-query-connector.image.repository`	`ghcr.io/emergenceai/em-redshift-query-connector`	Redshift connector image
`postgresql.enabled`	`true`	Deploy bundled PostgreSQL
`redis.enabled`	`true`	Deploy bundled Redis

The full values reference is in charts/em-data-insights/values.yaml in the em-charts repository.

em-core Chart

Core platform chart that em-data-insights extends.

Data Insights Overview

Data Insights solution capabilities.

Text-to-SQL

How the Text2SQL agent converts natural-language questions to SQL.

​em-data-insights Chart

​Components

​Quick start

​Redshift integration

​Using external databases

​Key values

​Related