Databricks deployment

Fabric Experiments uses Databricks for production-scale warehouse aggregation.

Create the staging catalog/schema:

CREATE CATALOG IF NOT EXISTS fx_staging;
CREATE SCHEMA IF NOT EXISTS fx_staging.fx;
GRANT USAGE ON CATALOG fx_staging TO `fx-staging-sp`;

Set API env vars:

• DATABRICKS_HOST
• DATABRICKS_HTTP_PATH
• DATABRICKS_TOKEN
• DATABRICKS_CATALOG=fx_staging
• DATABRICKS_SCHEMA=fx

Install the optional driver in deployments that use Databricks:

pnpm add -F @fabricorg/experiments-api @databricks/sql