I’m trying some queries in Dremio to build a good virtual source from a SQL Server Dataset.
I am getting invalid syntax when trying to set a variable. I can not find anything that shows all the valid SQL language commands in Dremio. I want to find the equivalent to DECLARE in T-SQL but can not find reference material to help me do this.
Also, I am getting some validation errors when I try different window functions.
Can anyone point me to a robust language reference for Dremio SQL?