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 {
loadQuestionSdk,
runQuestionQuerySdk,
} from "embedding-sdk-bundle/lib/sdk-question";
import { getIsGuestEmbed } from "embedding-sdk-bundle/store/selectors";
import type { SdkStore } from "embedding-sdk-bundle/store/types";
import type {
MetabaseQuestion,
SdkQuestionId,
SqlParameterValues,
} from "embedding-sdk-bundle/types/question";
import { transformSdkQuestion } from "metabase/embedding-sdk/lib/transform-question";
import { createRawSeries } from "metabase/viz-core";
import type { DatasetColumn, RowValues } from "metabase-types/api";
export type QueryQuestionParams = {
questionId: SdkQuestionId;
initialSqlParameters?: SqlParameterValues;
};
export type QueryQuestionResult = {
id: MetabaseQuestion["id"];
name: MetabaseQuestion["name"];
description: MetabaseQuestion["description"];
entityId: MetabaseQuestion["entityId"];
rowCount: number | null;
runningTime: number | null;
columns: DatasetColumn[];
rows: RowValues[];
};
export const queryQuestion =
(reduxStore: SdkStore) =>
async ({
questionId,
initialSqlParameters,
}: QueryQuestionParams): Promise<QueryQuestionResult> => {
const dispatch = reduxStore.dispatch;
const getState = reduxStore.getState;
const isGuestEmbed = getIsGuestEmbed(getState());
const questionState = await dispatch(
loadQuestionSdk({
questionId,
token: undefined,
initialSqlParameters,
}),
);
const resultState = await runQuestionQuerySdk({
question: questionState.question,
isGuestEmbed,
token: undefined,
originalQuestion: questionState.originalQuestion,
parameterValues: questionState.parameterValues,
signal: new AbortController().signal,
dispatch,
});
const question = resultState.question ?? questionState.question;
const transformedQuestion = transformSdkQuestion(question);
const data = resultState.queryResults?.[0] ?? null;
const rawSeries =
createRawSeries({
card: question.card(),
queryResult: data,
}) ?? null;
return {
id: transformedQuestion.id,
name: transformedQuestion.name,
description: transformedQuestion.description,
entityId: transformedQuestion.entityId,
rowCount: data?.row_count ?? null,
runningTime: data?.running_time ?? null,
columns: data?.data.cols ?? [],
rows: rawSeries?.[0]?.data.rows ?? [],
};
};