# Discover Not Loading Data

**URL:** <https://discuss.elastic.co/t/discover-not-loading-data/106498>\
**Category:** Kibana\
**Created:** [November 6, 2017, 9:48am UTC](https://discuss.elastic.co/t/discover-not-loading-data/106498 "2017-11-06T09:48:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Staggerlee011](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/staggerlee011/32/23466_2.png) [@Staggerlee011](https://discuss.elastic.co/u/Staggerlee011)\
**Post date:** [November 6, 2017, 9:48am UTC](https://discuss.elastic.co/t/discover-not-loading-data/106498/1 "2017-11-06T09:48:16Z")

</div>

Hi,

Im new to the elasticstack, so please bear with me.

I have created an elasticsearch template to create rolling indexes. I am then pushing data in, I can run

```
get sqltable/sqltable_size/_count

```

which returns:

```
{
  "count": 2412,
  "_shards": {
    "total": 2,
    "successful": 2,
    "skipped": 0,
    "failed": 0
  }
}

```

If i run:

```
get sqltable/sqltable_size/_search?pretty

```

I get my data (subset below):

```
{
  "took": 5,
  "timed_out": false,
  "_shards": {
    "total": 2,
    "successful": 2,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 2792,
    "max_score": 1,
    "hits": [
      {
        "_index": "sqltable-2017.11.06",
        "_type": "sqltable_size",
        "_id": "AV-QqGmYWXBSsRxAMd4n",
        "_score": 1,
        "_source": {
          "Time": {
            "value": "/Date(1509960358118)/",
            "DisplayHint": 2,
            "DateTime": "06 November 2017 09:25:58"
          },
          "Server": "server1",
          "Database": "Admin",
          "Schema": "Index",
          "Table": "DBlist",
          "IndexSpaceUsed": 8,
          "DataSpaceUsed": 8,
          "RowCount": 11
        }
      },

```

When i try and load it into Kibana however..

First in management i add the index pattern, it all looks good to me, i can see my Server, Table etc fields:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/2/f25ea005189d83962979ac3f38643ca355d64983.png)

However when i got to Discover it get no results ☹

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/5/258552b891bfde26e05a40d76a4b41109ab4b15e.png)

I thought it might be the time, but ive literally just ran it so setting time to 1 hour should collect every result.

Any ideas what i have done wrong to not load the data in?

---

<div class="post-metadata">

**Author:** ![Staggerlee011](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/staggerlee011/32/23466_2.png) [@Staggerlee011](https://discuss.elastic.co/u/Staggerlee011)\
**Post date:** [November 6, 2017, 12:07pm UTC](https://discuss.elastic.co/t/discover-not-loading-data/106498/2 "2017-11-06T12:07:53Z")

</div>

Ok solved it.. Looking for similar issues i found 1 saying that it might be because of the date formatting.

With that i have updated my template to:

```
        "TimeStamp" : {
          "type" : "date",
          "format" : "yyyy.MM.dd"
        },

```

Instead of:

```
        "TimeStamp" : {
          "type" : "date"
        },

```

And made sure my input date was in the same format.. I then deleted all the old data and reloading I can now see it in Kibana discovery!

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [November 7, 2017, 6:43pm UTC](https://discuss.elastic.co/t/discover-not-loading-data/106498/3 "2017-11-07T18:43:41Z")

</div>