Transform api : Can't find destination index in kibana

Hi!

I run the follwoing query to create a new index using the TRANSFORM API . While the query runs correctly, I can't find the new index (in my case kibana_sample_data_ecommerce_transform_210520) in the kibana UI.

Can you please help me?

The query I run is the following:

PUT _transform/ecomm_210520
{
  "source": {
    "index": "kibana_sample_data_ecommerce"
  },
  "pivot": {
    "group_by": {
      "day": {
        "terms": {
          "field": "day_of_week"
        }
      }
    },
    "aggregations": {
      "sumprice": {
        "sum": {
          "field": "products.price"
        }
      },
      "sumquantity": {
        "sum": {
          "field": "products.quantity"
        }
      },
      "ratio": {
        "bucket_script": {
          "buckets_path": {
            "sumPrice": "sumprice",
            "sumQuantity": "sumquantity"
          },
          "script": "params.sumPrice / params.sumQuantity"
        }
      }
    }
  },
    "dest": {
      "index": "kibana_sample_data_ecommerce_transform_210520"
    },
    "frequency": "5m"
}

POST _transform/ecomm_210520/_start 

The solution I found is to create the destination index from the kibana UI. See instructions : https://www.elastic.co/guide/en/elasticsearch/reference/current/ecommerce-transforms.html

1 Like