Snowflake database encountered an error - unexpected "as"

 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.

89530165-d33a-451c-a5f5-e8af219ab2de.png
1
0 0 196
0 REPLIES 0
Top Labels in this Space
Top Solution Authors