curl -X POST "http://localhost:9200/_transform/tf_momo_pre_validation_result_n_daily/_stop"
curl -X DELETE "http://localhost:9200/_transform/tf_momo_pre_validation_result_n_daily"
curl -X DELETE "http://localhost:9200/momo_pre_validation_result_n_daily"
curl -X PUT "http://localhost:9200/_transform/tf_momo_pre_validation_result_n_daily" -H 'Content-Type: application/json' -d'
{
  "source": {
    "index": "momo_smartfds_login*",
	"query": {
      "term": {
        "pre_validation_result": "N"
      }
    }
  },
  "pivot": {
    "group_by": {
      "datetime_field": {
        "date_histogram": {
          "field": "create_datetime",
          "calendar_interval": "day"
        }
      }
    },
    "aggregations": {
      "total_count": {
        "value_count": {
          "field": "_id"
        }
      },
      "decision_code_pass": {
        "filter": {
          "term": { "decision_code": "pass" }
        }
      },
      "decision_code_reject": {
        "filter": {
          "term": { "decision_code": "reject" }
        }
      },
      "decision_code_challenge": {
        "filter": {
          "term": { "decision_code": "challenge" }
        }
      }
    }
  },
  "dest": {
    "index": "momo_pre_validation_result_n_daily"
  },
  "sync": {
	  "time": {
		"field": "create_datetime",
		"delay": "60s"
	  }
  },
  "frequency": "1h"
}'

curl -X POST "http://localhost:9200/_transform/tf_momo_pre_validation_result_n_daily/_start"