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
export const nativeQuestionWithParametersData = {
data: {
rows: [
[
15,
"258 Opal Road",
"[email protected]",
"2734ae7a-aa25-4907-9d2e-a6992750db60",
"Bertrand Romaguera",
"El Paso",
-92.0101859,
"AR",
"Twitter",
"2000-02-14T00:00:00Z",
"72045",
35.1080351,
"2024-12-20T17:50:32.296Z",
],
[
25,
"1201-2099 Plumberosa Drive",
"[email protected]",
"51421352-6fdf-456e-93c9-41875c275480",
"Araceli Stiedemann",
"Fayetteville",
-94.20265719999999,
"AR",
"Twitter",
"1979-02-05T00:00:00Z",
"72701",
36.0479853,
"2022-08-16T02:51:36.698Z",
],
],
results_timezone: "UTC",
download_perms: "full",
results_metadata: {
columns: [
{
database_type: "BIGINT",
semantic_type: "type/PK",
"lib/deduplicated-name": "ID",
"lib/original-name": "ID",
name: "ID",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"ID",
{
"base-type": "type/BigInteger",
},
],
effective_type: "type/BigInteger",
display_name: "ID",
fingerprint: null,
base_type: "type/BigInteger",
},
{
database_type: "CHARACTER VARYING",
semantic_type: null,
"lib/deduplicated-name": "ADDRESS",
"lib/original-name": "ADDRESS",
name: "ADDRESS",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"ADDRESS",
{
"base-type": "type/Text",
},
],
effective_type: "type/Text",
display_name: "ADDRESS",
fingerprint: {
global: {
"distinct-count": 49,
"nil%": 0,
},
type: {
"type/Text": {
"percent-json": 0,
"percent-url": 0,
"percent-email": 0,
"percent-state": 0,
"average-length": 19.163265306122447,
},
},
},
base_type: "type/Text",
},
{
database_type: "CHARACTER VARYING",
semantic_type: null,
"lib/deduplicated-name": "EMAIL",
"lib/original-name": "EMAIL",
name: "EMAIL",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"EMAIL",
{
"base-type": "type/Text",
},
],
effective_type: "type/Text",
display_name: "EMAIL",
fingerprint: {
global: {
"distinct-count": 49,
"nil%": 0,
},
type: {
"type/Text": {
"percent-json": 0,
"percent-url": 0,
"percent-email": 1,
"percent-state": 0,
"average-length": 24.26530612244898,
},
},
},
base_type: "type/Text",
},
{
database_type: "CHARACTER VARYING",
semantic_type: null,
"lib/deduplicated-name": "PASSWORD",
"lib/original-name": "PASSWORD",
name: "PASSWORD",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"PASSWORD",
{
"base-type": "type/Text",
},
],
effective_type: "type/Text",
display_name: "PASSWORD",
fingerprint: {
global: {
"distinct-count": 49,
"nil%": 0,
},
type: {
"type/Text": {
"percent-json": 0,
"percent-url": 0,
"percent-email": 0,
"percent-state": 0,
"average-length": 36,
},
},
},
base_type: "type/Text",
},
{
database_type: "CHARACTER VARYING",
semantic_type: "type/Name",
"lib/deduplicated-name": "NAME",
"lib/original-name": "NAME",
name: "NAME",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"NAME",
{
"base-type": "type/Text",
},
],
effective_type: "type/Text",
display_name: "NAME",
fingerprint: {
global: {
"distinct-count": 49,
"nil%": 0,
},
type: {
"type/Text": {
"percent-json": 0,
"percent-url": 0,
"percent-email": 0,
"percent-state": 0,
"average-length": 13.816326530612244,
},
},
},
base_type: "type/Text",
},
{
database_type: "CHARACTER VARYING",
semantic_type: "type/City",
"lib/deduplicated-name": "CITY",
"lib/original-name": "CITY",
name: "CITY",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"CITY",
{
"base-type": "type/Text",
},
],
effective_type: "type/Text",
display_name: "CITY",
fingerprint: {
global: {
"distinct-count": 44,
"nil%": 0,
},
type: {
"type/Text": {
"percent-json": 0,
"percent-url": 0,
"percent-email": 0,
"percent-state": 0,
"average-length": 8.551020408163266,
},
},
},
base_type: "type/Text",
},
{
database_type: "DOUBLE PRECISION",
semantic_type: "type/Longitude",
"lib/deduplicated-name": "LONGITUDE",
"lib/original-name": "LONGITUDE",
name: "LONGITUDE",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"LONGITUDE",
{
"base-type": "type/Float",
},
],
effective_type: "type/Float",
display_name: "LONGITUDE",
fingerprint: {
global: {
"distinct-count": 49,
"nil%": 0,
},
type: {
"type/Number": {
min: -94.5138154,
q1: -93.53949217499999,
q3: -91.599448025,
max: -90.246799,
sd: 1.1850640123925205,
avg: -92.42678023265306,
},
},
},
base_type: "type/Float",
},
{
database_type: "CHARACTER",
semantic_type: null,
"lib/deduplicated-name": "STATE",
"lib/original-name": "STATE",
name: "STATE",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"STATE",
{
"base-type": "type/Text",
},
],
effective_type: "type/Text",
display_name: "STATE",
fingerprint: {
global: {
"distinct-count": 1,
"nil%": 0,
},
type: {
"type/Text": {
"percent-json": 0,
"percent-url": 0,
"percent-email": 0,
"percent-state": 1,
"average-length": 2,
},
},
},
base_type: "type/Text",
},
{
database_type: "CHARACTER VARYING",
semantic_type: "type/Source",
"lib/deduplicated-name": "SOURCE",
"lib/original-name": "SOURCE",
name: "SOURCE",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"SOURCE",
{
"base-type": "type/Text",
},
],
effective_type: "type/Text",
display_name: "SOURCE",
fingerprint: {
global: {
"distinct-count": 5,
"nil%": 0,
},
type: {
"type/Text": {
"percent-json": 0,
"percent-url": 0,
"percent-email": 0,
"percent-state": 0,
"average-length": 7.26530612244898,
},
},
},
base_type: "type/Text",
},
{
database_type: "DATE",
semantic_type: null,
"lib/deduplicated-name": "BIRTH_DATE",
"lib/original-name": "BIRTH_DATE",
name: "BIRTH_DATE",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"BIRTH_DATE",
{
"base-type": "type/Date",
},
],
effective_type: "type/Date",
display_name: "BIRTH_DATE",
fingerprint: {
global: {
"distinct-count": 49,
"nil%": 0,
},
type: {
"type/DateTime": {
earliest: "1960-01-13",
latest: "2000-02-14",
},
},
},
base_type: "type/Date",
},
{
database_type: "CHARACTER",
semantic_type: null,
"lib/deduplicated-name": "ZIP",
"lib/original-name": "ZIP",
name: "ZIP",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"ZIP",
{
"base-type": "type/Text",
},
],
effective_type: "type/Text",
display_name: "ZIP",
fingerprint: {
global: {
"distinct-count": 44,
"nil%": 0,
},
type: {
"type/Text": {
"percent-json": 0,
"percent-url": 0,
"percent-email": 0,
"percent-state": 0,
"average-length": 5,
},
},
},
base_type: "type/Text",
},
{
database_type: "DOUBLE PRECISION",
semantic_type: "type/Latitude",
"lib/deduplicated-name": "LATITUDE",
"lib/original-name": "LATITUDE",
name: "LATITUDE",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"LATITUDE",
{
"base-type": "type/Float",
},
],
effective_type: "type/Float",
display_name: "LATITUDE",
fingerprint: {
global: {
"distinct-count": 49,
"nil%": 0,
},
type: {
"type/Number": {
min: 33.1818402,
q1: 33.96992525,
q3: 35.808187849999996,
max: 36.4587022,
sd: 1.0305278500002746,
avg: 34.88922432653061,
},
},
},
base_type: "type/Float",
},
{
database_type: "TIMESTAMP",
semantic_type: "type/CreationTimestamp",
"lib/deduplicated-name": "CREATED_AT",
"lib/original-name": "CREATED_AT",
name: "CREATED_AT",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"CREATED_AT",
{
"base-type": "type/DateTime",
},
],
effective_type: "type/DateTime",
display_name: "CREATED_AT",
fingerprint: {
global: {
"distinct-count": 49,
"nil%": 0,
},
type: {
"type/DateTime": {
earliest: "2022-05-19T05:23:03.686Z",
latest: "2025-03-01T08:21:10.872Z",
},
},
},
base_type: "type/DateTime",
},
],
},
"format-rows?": true,
"pivot-export-options": {
"show-row-totals": true,
"show-column-totals": true,
},
cols: [
{
database_type: "BIGINT",
"lib/deduplicated-name": "ID",
"lib/original-name": "ID",
name: "ID",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"ID",
{
"base-type": "type/BigInteger",
},
],
effective_type: "type/BigInteger",
display_name: "ID",
base_type: "type/BigInteger",
},
{
database_type: "CHARACTER VARYING",
"lib/deduplicated-name": "ADDRESS",
"lib/original-name": "ADDRESS",
name: "ADDRESS",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"ADDRESS",
{
"base-type": "type/Text",
},
],
effective_type: "type/Text",
display_name: "ADDRESS",
base_type: "type/Text",
},
{
database_type: "CHARACTER VARYING",
"lib/deduplicated-name": "EMAIL",
"lib/original-name": "EMAIL",
name: "EMAIL",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"EMAIL",
{
"base-type": "type/Text",
},
],
effective_type: "type/Text",
display_name: "EMAIL",
base_type: "type/Text",
},
{
database_type: "CHARACTER VARYING",
"lib/deduplicated-name": "PASSWORD",
"lib/original-name": "PASSWORD",
name: "PASSWORD",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"PASSWORD",
{
"base-type": "type/Text",
},
],
effective_type: "type/Text",
display_name: "PASSWORD",
base_type: "type/Text",
},
{
database_type: "CHARACTER VARYING",
"lib/deduplicated-name": "NAME",
"lib/original-name": "NAME",
name: "NAME",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"NAME",
{
"base-type": "type/Text",
},
],
effective_type: "type/Text",
display_name: "NAME",
base_type: "type/Text",
},
{
database_type: "CHARACTER VARYING",
"lib/deduplicated-name": "CITY",
"lib/original-name": "CITY",
name: "CITY",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"CITY",
{
"base-type": "type/Text",
},
],
effective_type: "type/Text",
display_name: "CITY",
base_type: "type/Text",
},
{
database_type: "DOUBLE PRECISION",
"lib/deduplicated-name": "LONGITUDE",
"lib/original-name": "LONGITUDE",
name: "LONGITUDE",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"LONGITUDE",
{
"base-type": "type/Float",
},
],
effective_type: "type/Float",
display_name: "LONGITUDE",
base_type: "type/Float",
},
{
database_type: "CHARACTER",
"lib/deduplicated-name": "STATE",
"lib/original-name": "STATE",
name: "STATE",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"STATE",
{
"base-type": "type/Text",
},
],
effective_type: "type/Text",
display_name: "STATE",
base_type: "type/Text",
},
{
database_type: "CHARACTER VARYING",
"lib/deduplicated-name": "SOURCE",
"lib/original-name": "SOURCE",
name: "SOURCE",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"SOURCE",
{
"base-type": "type/Text",
},
],
effective_type: "type/Text",
display_name: "SOURCE",
base_type: "type/Text",
},
{
database_type: "DATE",
"lib/deduplicated-name": "BIRTH_DATE",
"lib/original-name": "BIRTH_DATE",
name: "BIRTH_DATE",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"BIRTH_DATE",
{
"base-type": "type/Date",
},
],
effective_type: "type/Date",
display_name: "BIRTH_DATE",
base_type: "type/Date",
},
{
database_type: "CHARACTER",
"lib/deduplicated-name": "ZIP",
"lib/original-name": "ZIP",
name: "ZIP",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"ZIP",
{
"base-type": "type/Text",
},
],
effective_type: "type/Text",
display_name: "ZIP",
base_type: "type/Text",
},
{
database_type: "DOUBLE PRECISION",
"lib/deduplicated-name": "LATITUDE",
"lib/original-name": "LATITUDE",
name: "LATITUDE",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"LATITUDE",
{
"base-type": "type/Float",
},
],
effective_type: "type/Float",
display_name: "LATITUDE",
base_type: "type/Float",
},
{
database_type: "TIMESTAMP",
"lib/deduplicated-name": "CREATED_AT",
"lib/original-name": "CREATED_AT",
name: "CREATED_AT",
"lib/source": "source/native",
source: "native",
field_ref: [
"field",
"CREATED_AT",
{
"base-type": "type/DateTime",
},
],
effective_type: "type/DateTime",
display_name: "CREATED_AT",
base_type: "type/DateTime",
},
],
native_form: {
"lib/type": "mbql.stage/native",
params: ["AR"],
query: "SELECT\n *\nFROM\n people\nWHERE\n state = ?",
},
is_sandboxed: false,
insights: null,
},
cached: null,
database_id: 1,
started_at: "2025-09-29T05:53:34.028607Z",
json_query: {
constraints: {
"max-results": 10000,
"max-results-bare-rows": 2000,
},
type: "native",
middleware: {
"js-int-to-string?": true,
"ignore-cached-results?": false,
"process-viz-settings?": false,
"userland-query?": true,
},
"cache-strategy": null,
native: {
"template-tags": {
State: {
type: "text",
name: "State",
id: "92792d2c-9c80-4174-ae55-a2f521e4d080",
"display-name": "State",
},
city: {
type: "text",
name: "city",
id: "370cc09b-d3f7-47e4-b062-391fb6f3b0f2",
"display-name": "City",
},
},
query:
"SELECT\n *\nFROM\n people\nWHERE\n state = {{State}} [[ and city = {{city}} ]]",
},
"viz-settings": {
"table.pivot_column": "COUNT(*)",
},
database: 1,
parameters: [
{
id: "92792d2c-9c80-4174-ae55-a2f521e4d080",
type: "string/=",
target: ["variable", ["template-tag", "State"]],
value: ["AR"],
},
{
id: "370cc09b-d3f7-47e4-b062-391fb6f3b0f2",
type: "string/=",
target: ["variable", ["template-tag", "city"]],
value: null,
},
],
},
average_execution_time: null,
status: "completed",
context: "question",
row_count: 49,
running_time: 36,
};