Canvas Increase Result Count

[glen.smith]

Hi Everyone,

I'm new here so I'm not sure if this is the best place for this. I'm new to using the Canvas feature in Kibana. I'm using essql SELECT requests like:

SELECT * from index

but I'm only returned the first 1000 documents by default. I can change this by setting

count = 10000

but that's as far as I can go, and it is slow to generate a plot. I noticed that Visualizations (bar charts for instance) created in the "Visualize" tab use all of the data in my index (roughly 700,000 records). Is there a way to use ALL of my data in Canvas? Otherwise, I don't know how to create meaningful metrics here that reflect all of my data.

Thanks!

[LizaD (Liza Dayoub)]

@Joe_Fleming can you help?

[Catherine_Liu]

@glen.smith You can use the LIMIT clause in your SQL query to set the number of results you want to retrieve.

You could also pass the count argument in the essql function in the expression.

Example:
essql "SELECT * from index" count=10000