Problems with CTE

Answered

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

2 comments
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?

0
Comment actions Permalink

Thanks Yuriy, I voted!

0

Please sign in to leave a comment.