{
  "schemaComputation": "ONLY_IF_NO_METADATA",
  "identifierColumnsSelection": "EXPLICIT",
  "modalitySlugification": "NONE",
  "sortModalities": true,
  "preFilter": {
    "uiData": {
      "mode": "||",
      "$latestOperator": "||",
      "$filterOptions": "rules",
      "conditions": [
        {
          "input": "cardholder_fico_range",
          "col": "authorized_flag",
          "string": "bad",
          "$showList": false,
          "num": 0,
          "operator": "\u003d\u003d [string]"
        },
        {
          "input": "cardholder_fico_range",
          "col": "authorized_flag",
          "string": "fair",
          "$showList": false,
          "num": 0,
          "operator": "\u003d\u003d [string]"
        }
      ]
    },
    "$status": {},
    "distinct": false,
    "enabled": true
  },
  "engineParams": {
    "hive": {
      "skipPrerunValidate": false,
      "hiveconf": [],
      "inheritConf": "default",
      "addDkuUdf": false,
      "executionEngine": "HIVECLI_LOCAL"
    },
    "sqlPipelineParams": {
      "pipelineAllowMerge": true,
      "pipelineAllowStart": true
    },
    "impala": {
      "forceStreamMode": true
    },
    "lowerCaseSchemaIfEngineRequiresIt": true,
    "sparkSQL": {
      "skipPrerunValidate": false,
      "pipelineAllowMerge": true,
      "useGlobalMetastore": false,
      "pipelineAllowStart": true,
      "readParams": {
        "mode": "AUTO",
        "autoModeRepartitionInto": 10,
        "map": {}
      },
      "overwriteOutputSchema": false,
      "executionEngine": "SPARK_SUBMIT",
      "sparkConfig": {
        "inheritConf": "default",
        "conf": []
      }
    }
  },
  "explicitIdentifiers": [
    "authorized_flag"
  ],
  "otherColumns": [],
  "pivots": [
    {
      "valueLimit": "TOP_N",
      "minOccLimit": 0,
      "topnLimit": 20,
      "globalCount": true,
      "explicitValues": [],
      "keyColumns": [
        "cardholder_fico_range"
      ],
      "valueColumns": [
        {
          "last": false,
          "max": false,
          "column": "purchase_amount",
          "count": false,
          "sum": false,
          "concat": false,
          "type": "double",
          "$agg": "avg",
          "countDistinct": false,
          "min": false,
          "avg": true,
          "stddev": false,
          "first": false
        }
      ]
    }
  ],
  "computedColumns": [],
  "customAggregates": [],
  "enginesPreferences": {}
}