How to disable automatically adding "database name" from autocomplete?

Avatar
Colin
创建于

I am using Snowflake with Datagrip,  in snowflake I have RAW, DEV, PROD database

I think since the 2024 or 2023 new version when I type select * from prod.

it will automatically suggest to write in to

select *
from "Snowflake".prod.;

can we stop this behaviour and just write

select *
from prod.xxxxx. ?

 

thanks,

Votes

1

分享

10 条评论
Avatar
Aleksandr Molchanov
创建于
Hi Colin,

Please ensure you don't have Qualify Objects WIth - Database radio button selected in your code completion settings in File | Settings | Editor | General | Code Completion
0
Avatar
Marcin Binkowski
创建于

Hey, I have the same issue, but it happens only in Live templates. Setting Qualify object with Database as well as Qualify object in Live templates to “Never” didn't help.

0
Avatar
Aleksandr Molchanov
创建于
Please specify your database, IDE version, and jdbc drivers version for testing purposes.
0
Avatar
Marcin Binkowski
创建于

Hi, it's DataGrip 2024.2.2

It happens in both Trino (io.trino.jdbc.TrinoDriver ver 425) and Redshift (com.amazon.redshift.jdbc.Driver ver 2.1.0.28)

0
Avatar
Aleksandr Molchanov
创建于
Thanks for the update.

I tested live templates in both data sources with identical setup and couldn't reproduce it. May I know what are your settings in File | Settings | Editor | General | Code Completion  starting from the SQL qualify section , please include a screenshot. Also, when you type your live template, do you observe the same database qualify in the preview or is it only shown after you hit enter and it auto completes in the editor?
0
Avatar
Marcin Binkowski
创建于

Hi, here are the settings:

The database completion happens when I put the period after entering schema name. But it doesn't happen if I use completion with Tab to complete the schema name. The issue appears only if I enter full schema name on my own and put a period.

I recorded a short video of the behavior: https://drive.google.com/file/d/186PfwL0wmVqSDekJcHRy0X3wR3THBfkR/view?usp=sharing (you'll need to request access to view it, my company forbids sharing stuff publicly)
 

 

 

0
Avatar
Aleksandr Molchanov
创建于
We have watched the video you uploaded and were able to partially reproduce this issue. Presumably, it's related to the basic completion setting affecting the completion within live templates. Please try setting Basic Completion to Never and see how it works. I'd also appreciate if you could provide a screenshot of the live template you're using as demonstrated in your video capture.
0
Avatar
Aleksandr Molchanov
创建于
To keep track of the progress, please follow this issue:

https://youtrack.jetbrains.com/issue/DBE-21988/Code-completion-ignores-scope-Qualify-Objects-In-Live-templates
0
Avatar
Marcin Binkowski
创建于

Hi, thank you! 

Setting Basic completion to Never solved the issue. 

And here's a screenshot of the template

0
Avatar
Aleksandr Molchanov
创建于
Thanks for the update.

Please follow the youtrack issue to stay updated on the progress.
0

请先登录再写评论。