I tried to get the 2 dimensions order ID and the date and SQL automatically adds another LIMIT clause in between. When I remove this LIMIT in SQL runner, the query runs fine. But I want to run it in the explorer so that I can add it to my dashboard. The SQL query is not editable in explore. Any way I can get rid of this LIMIT clause?(the “LIMIT 10”)
I know it is the only thing causing the error.