Configuration settings

Answered

Few questions about configuration. For some reason I didn't export the settings when I moved companies and now I can't configure it to the same way I used to have it. Any help would be appreciated:

1. When I type schema + table name and click enter, the table name gets double quotes around it like `schema."table"`, which causes an error in BigQuery. In CodeStyle -> SQL -> General -> Case -> Quotation character 

I have `Grave Accents` only, yet I'm getting double quotes

2. Every time I run a query a dropdown pops up with Statements. It's quite annoying and I didn't used to have it. How do I disable it and force it to run the inner most query each time?

3. Again having problems finding the line wrapping. I want the code to wrap to whatever the window size but still considering it the same line (no carriage return)

4. Previewing the table structure and sample of its content when hovering over its name - one of the most useful features by the way!

7 comments
Comment actions Permalink

Hello,

1. Please update to latest 2019.3.3 version, it contains the fix for BigQuery.

2. Please go to Settings -> Database -> General and change options in 'Execute in Console' section as you need.

3. it's under View -> Active editor -> Soft-wraps

0
Comment actions Permalink

Thank you Yuriy Vinogradov!

I also assigned a shortcut CTRL+N to a New Console but it doesn't work unless I open up Databases section and select the database. I usually work with one connection, is there a way to change it?

0
Comment actions Permalink

No, but you can open new console from existing one without selecting database in object window.

0
Comment actions Permalink

That's what I've been trying to achieve. Meaning that while I'm inside a console window writing some SQL I would like to hit CTRL+N to open a fresh tab

0
Comment actions Permalink

When you inside console window please open File-> New -> Console. Will it work? then try to set keymap for this action like 'ctrl+alt+q', it should work also.

0
Comment actions Permalink

Yuriy Vinogradov

Would you be able to shed some light on something.

 

I'm using a lot of CTEs recently but when I place my cursor within the final SELECT statement, I'm getting errors that tables I'm referencing are missing a dataset. 

I do have this setting applied:

2. Please go to Settings -> Database -> General and change options in 'Execute in Console' section as you need. 

 

As Largest statement or batch.. The query works fine if I select it the whole query but it would be nicer to be able to run it while the cursor is anywhere in the whole statement..

0
Comment actions Permalink

Still having huge problems with styling..

 

I have the JDBC driver for BigQuery and in Options I have GENERIC SQL selected for it.

Then in Colour Scheme -> SQL I have specific styles. For some reason the styles are applied if I write a query in a new console but it's not using the colour scheme when I open a *.sql file

 

Above is the sql file and below simple copy + paste to a new console window:

0

Please sign in to leave a comment.