The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:
TypeScript analyticsbibusiness-intelligencebusinessintelligenceclojuredashboarddatadata-analysisdata-visualizationdatabasemetabasemysqlpostgrespostgresqlreportingslacksql-editorvisualization
import ora from "ora";
import { createCollection } from "embedding-sdk-package/cli/utils/create-collection";
import type { CliStepMethod } from "../types/cli";
import type { DashboardInfo } from "../types/dashboard";
import { createModelFromTable } from "../utils/create-model-from-table";
import { createXrayDashboardFromModel } from "../utils/xray-models";
export const createModelsAndXrays: CliStepMethod = async (state) => {
const {
instanceUrl = "",
databaseId,
cookie = "",
chosenTables = [],
} = state;
if (databaseId === undefined) {
return [{ type: "error", message: "No database selected." }, state];
}
const spinner = ora("Creating models…").start();
try {
const models = [];
// Create the "Our models" collection to store the models.
// This helps us to allow access to models when sandboxing.
const modelCollectionId = await createCollection({
name: "Our models",
instanceUrl,
cookie,
});
// Create a model for each table
for (const table of chosenTables) {
const model = await createModelFromTable({
table,
databaseId,
collectionId: modelCollectionId,
cookie,
instanceUrl,
});
models.push(model);
}
spinner.start("X-raying your data to create dashboards...");
const dashboards: DashboardInfo[] = [];
// We create dashboard sequentially to prevent multiple
// "Automatically Generated Dashboards" collection from being created.
for (const model of models) {
const dashboardId = await createXrayDashboardFromModel({
modelId: model.modelId,
instanceUrl,
cookie,
});
dashboards.push({ id: dashboardId, name: model.modelName });
}
spinner.succeed();
return [{ type: "done" }, { ...state, dashboards, modelCollectionId }];
} catch (error) {
spinner.fail();
const reason = error instanceof Error ? error.message : String(error);
const message = `Cannot create models from selected tables. Reason: ${reason}`;
return [{ type: "error", message }, state];
}
};