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 type { Table } from "metabase-types/api";
import { propagateErrorResponse } from "./propagate-error-response";
interface Options {
table: Table;
databaseId: number;
collectionId: number | null;
cookie: string;
instanceUrl: string;
}
export async function createModelFromTable(options: Options) {
const { databaseId, collectionId, table, instanceUrl, cookie = "" } = options;
const datasetQuery = {
type: "query",
database: databaseId,
query: { "source-table": table.id },
};
// Create a new model
const res = await fetch(`${instanceUrl}/api/card`, {
method: "POST",
headers: { "content-type": "application/json", cookie },
body: JSON.stringify({
name: table.display_name,
type: "model",
display: "table",
result_metadata: null,
collection_id: collectionId,
visualization_settings: {},
dataset_query: datasetQuery,
description: `A model created via the embedding sdk's CLI`,
}),
});
await propagateErrorResponse(res);
// Unjustified type cast. FIXME
const { id: modelId } = (await res.json()) as { id: number };
return {
modelId,
modelName: table.display_name,
};
}