Required credentials

Under the hood, Embeddable relies on Cube (opens in a new tab) to connect to your database.

Below are the type and credentials fields you’ll need when connecting your database.

BigQuery

type: 'bigquery',
credentials: {
  projectId: '...',
  credentials: {
    "type": "service_account",
    "project_id": "...",
    "private_key_id": "...",
    "private_key": "...",
    // ...
  }
}

Clickhouse

Cube docs (opens in a new tab)

type: 'clickhouse',
credentials: {
  database: '...',
  host: '...',
  user: '...',
  password: '...',
  port: 8443
}

Druid

Cube docs (opens in a new tab)

type: 'druid',
credentials: {
  url: '...',
  user: '...',
  password: '...',
  // database: '...'
}

MongoDB (BI-Connector)

Cube docs (opens in a new tab)

type: 'mongobi',
credentials: {
  database: '...',
  host: '...',
  user: '...',
  password: '...',
  port: 3307,
  ssl: true
}

MySQL / MariaDB

Cube docs (opens in a new tab)

type: 'mysql',
credentials: {
  database: '...',
  host: '...',
  user: '...',
  password: '...',
  port: 3306,
  ssl: true
}

Postgres

Cube docs (opens in a new tab)

type: 'postgres',
credentials: {
  database: '...',
  host: '...',
  user: '...',
  password: '...',
  port: 5432,
  ssl: true // or { rejectUnauthorized: false }
}

Redshift

Cube docs (opens in a new tab)

type: 'redshift',
credentials: {
  database: '...',
  host: '...',
  user: '...',
  password: '...',
  port: 5439,
  ssl: true
}

Snowflake

Cube docs (opens in a new tab)

type: 'snowflake',
credentials: {
  account: '...',
  warehouse: '...',
  database: '...',
  username: '...',
  password: '...',
  // role: '...',
  // region: '...',
}

MS SQL / SQL Server

Cube docs (opens in a new tab)

type: 'mssql',
credentials: {
  server: '...',
  port: 1433,
  user: '...',
  password: '...',
  database: '...',
  options: {
    // trustServerCertificate: true
  }
}

Trino

Cube docs (opens in a new tab)

type: 'trino',
credentials: {
  host: "...",
  port: "...",
  catalog: "...",
  schema: "...",
  user: "...",
  basic_auth: {
    user: "...",
    password: "..."
  },
  ssl: {}
}

For the full list of supported databases, click here (opens in a new tab).

Connections API Troubleshooting