Problems with CTE


Since there's no SQL dialect and I have to use General SQL, the CTEs are ignored in my ways:

1. Their syntax highlighting doesn't work

2. When cursor is inside CTE CTRL+Enter doesn't work 

3. When I run the query with cursor inside SELECT we get errors


Even if I change the dialect to MySQL, which was something that was advised in the past, as I'm using BigQuery, it doesn't solve these problem. 


When can we expect BigQuery dialect and all those problems with CTE to be solved?


DataGrip is starting to be less usable for me because we use a lot of CTEs

Comment actions Permalink

We are working on complete BigQuery support, please follow and vote.

Could you please provide a query example with CTE that is not working as expected?

Comment actions Permalink

Thanks Yuriy, I voted!


Please sign in to leave a comment.