Skip to content

The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:

20.1 KB
Raw Blame
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,
};