Hi @Patrizia_Buompastore - the query timeout for the data preview is 1 min. You can still save your data set and use it in an analysis, but the timeout for any give visual to load is 2 min, so if the query for that visual takes longer than that then we will need to find a different solution.
How many rows are in your data set? Did you try importing it into SPICE? SPICE currently supports up to 500 million rows per data set (and the query timeout is something like 10 hours to import the data to SPICE).
Here my query is little bit different,
How I can increase execution time? I am already using Spice to load my data.
There are only 2 records in connected RDS database. But my sql execution is long and that’s why…
I am getting error
" Can’t show preview
Preview timed out. You can save and visualize data, or try again.
You cannot change either timeout (dataset preview = 1 min, visual = 2 min).
If it is failing to load the preview then it is taking at least 1 min, however if you save the dataset and try to build a visual you will need to see if it will complete within 2 min before it hits that timeout.