[BigQuery] Data editor with require partition filter enabled showing error
When you enable Require partition filter in big query and then open data editor error “Cannot query over table XXX without a filter over column(s) XXX that can be used for partition elimination” immediately shows up.
Is it possible to set default filter which will be used every time edit view is opened?
请先登录再写评论。
To investigate this issue, please upload the following logs onto our FTP server https://uploads.jetbrains.com/
- idea log from Help - Show Log in Files
- database log from Help - Show SQL Log in Files
Please provide the upload id in your reply
We'll have a look and get back to you
I'm not sure if my post was clear. This is not a bug in a Datagrip - datagrip works fine but the intearction with bigquery is cumbersome in this specific case.
When “require partition filter" is enabled big query forces you to filter records by partition. But when data editor is opened it queries bigquery without any filter. But because partition filter is required bigquery returns error.
Data editor can still be used if user adds partition filter in the data editor. But it is annoying to do this every time data editor is opened. There is not event column suggestion probably because the initial load failed.
idea.log - Upload id: 2024_10_14_c4rXmZnKi13k8cjuAcdgnj (file: idea.log)
database log - Upload id: 2024_10_14_HFvxPqghTQ9zzjYDgDkDb4 (file: database.0.log)
You're correct, we generate an invalid select statement when opening such tables via Database Explorer. I have reported this issue on our tracker:
https://youtrack.jetbrains.com/issue/DBE-22011/Tables-with-requirepartitionfilter-generate-invalid-statements
While we are working on a fix, the only workaround is to manually query tables in query console.
Thank you