Skip to main content

​
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:
ComponentPurpose
em-data-insights-agentData analysis and insights generation A2A agent
em-redshift-query-connectorAWS Redshift query connector service

​
Quick start

1

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>
2

Create namespace

kubectl create namespace em-data-insights
3

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
4

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

ValueDefaultDescription
em-core.hostnamelocalhostExternal hostname (passed to em-core subchart)
em-core.schemahttphttp or https
em-data-insights-agent.image.repositoryghcr.io/emergenceai/em-data-insights-agentAgent image
em-redshift-query-connector.image.repositoryghcr.io/emergenceai/em-redshift-query-connectorRedshift connector image
postgresql.enabledtrueDeploy bundled PostgreSQL
redis.enabledtrueDeploy 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.