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 { propagateErrorResponse } from "./propagate-error-response";
interface Options {
name: string;
engine: string;
connection: Record<string, string | boolean | number>;
cookie: string;
instanceUrl: string;
}
export async function addDatabaseConnection(options: Options) {
const { instanceUrl, name, engine, connection, cookie } = options;
const url = `${instanceUrl}/api/database`;
const { host } = connection;
if (connection.ssl) {
connection["ssl-mode"] = "require";
}
if (engine === "bigquery-cloud-sdk") {
connection["dataset-filters-type"] = "all";
}
// If the host points to localhost, we use docker's
// internal DNS to connect to the host database.
if (!host || host === "localhost" || host === "127.0.0.1") {
connection["host"] = "host.docker.internal";
}
let res = await fetch(url, {
method: "POST",
body: JSON.stringify({
name,
engine,
details: connection,
auto_run_queries: true,
is_sample: false,
is_full_sync: true,
is_on_demand: false,
refingerprint: false,
schedules: {},
cache_ttl: null,
}),
headers: { "content-type": "application/json", cookie },
});
await propagateErrorResponse(res);
const { id: databaseId } = await res.json();
// Synchronize the database schema
res = await fetch(`${instanceUrl}/api/database/${databaseId}/sync_schema`, {
method: "POST",
headers: { "content-type": "application/json", cookie },
});
await propagateErrorResponse(res);
return Number(databaseId);
}