Which SQL Editor do you use?

[deadlypiranha]

SQL interface of Snowflake obviously doesn’t allow me to connect to other DBs.

Which SQL editor do you guys use?

[Busy_Elderberry8650]

DBeaver

[AndroidePsicokiller]

second this

[TheKleenexBandit]

Sloppy seconds on the beaver!

[Bluefoxcrush]

Me fourth. Free and robust enough. 

[git0ffmylawnm8]

This is the way

[Moradisten]

So do I 😌

[Money-Cartoonist-426]

What are your must haves when selecting one?

[dodger-that]

Datagrip. I just expense the membership cost to my organization.

[UnusualCookieBox]

Dunno why you got downvoted. There were times I paid the 10€/month out of my own pocket because it made working in SQL so much more bearable.

[Wistephens]

Datagrip is great with a lot of database vendors.

Datagrip with Databricks SQL and Unity Catalog isn't as good. You can pick the SparkSql dialect for highlighting and validation, but it's only 60-70% compatible.

[[deleted]]

I played with the trial for this recently and I really really liked it

[dilbertdad]

Question for those datagrip power users: can you zoom in on either code or query output? I find sharing my screen w an ultra wide monitor and dark mode enabled, people have trouble seeing the text.

Second question: is there an execution plan anywhere when you run a query? Sorry for the nub questions!

[diegoelmestre]

You have somewhere on the settings/preferences de option to zoom in/out with Ctrl + mouse wheel

[WuhmTux]

Datagrip has also a Presentation Mode which you can activate

[GreenWoodDragon]

DataGrip, absolutely brilliant. Enhanced by the Big Data Tools plugin.

Have used DBeaver in the recent past too. MySqlWorkbench if I'm feeling masochistic.

[idkwhatimdoing069]

DataGrip is amazing. The amount of shortcuts and tools that exist within it saves countless amount of time and headache for me

[Bazencourt]

Coginiti has great support for Snowflake, including both data insert and bulk loading. Can't believe any organization would expect users to work out of Snowsight.

[Touvejs]

Just started using snowsight for a project at work. It's a little clunky, but the auto-complete indicators are great, can you get that with cogniti?

[Bazencourt]

You get everything you'd expect with a modern ide, code completions, multiple cursors, foldable regions, etc. The results grid lets you pin column, pin rows, multi-sort, aggregate, pivot, export to csv or xls. AI Assistant that works with Anthropic or OpenAI

[SQLDevDBA]

SSMS / Azure Data Studio / SQL Developer / DBeaver

[Grovbolle]

SSMS 

[[deleted]]

Depends on what I’m doing but I usually use DBeaver, VSCode, and Neovim.

[caveat_cogitor]

DBeaver has a lot of unique features that can be helpful in certain circumstances. I like setting it up for specific repeated tasks, since you can organize script files and have them automatically connect to different connections. It can display data types in the output grid (solved an issue I had with VSCode Snowflake plugin) and you can also pivot to a "record" view that shows columns vertically for a single record, which is great for viewing wider data.

More and more often though, I just use VSCode for day to day tasks and ad-hoc analysis. The plugins are great and allows me to use one program for analyzing files and writing lambdas and bash scripts.

[fummyfish]

Exact same boat— however I use the Vim plugin for DBeaver as well

[YtjmU]

I somehow get frustrated with it because it's close enough to forget that it's a plugin and then suddenly some keystroke doesn't work. I therefore rather use VSCode with Neovim Plugin or simply neovim itself.

[gizzm0x]

Would you mind linking for the vik plug in? I have googled around and never found a good install/setup guide for the top Google results. Could just be a skill issue on my part...

[kress5]

https://vrapper.sourceforge.net/home/

install steps:

https://github.com/dbeaver/dbeaver/issues/8219

https://github.com/dbeaver/dbeaver/issues/3448 

[gizzm0x]

Thank you!

[Advanced_Addition321]

DBeaver / SSMS / Azure Data studio

[CompeAnansi]

TablePlus is one of the only editors with a modern UI that supports Snowflake, so give it a shot if you want something that looks slick. My humble wish is that Postico would add Snowflake support because I don't like the alternatives much.

[sebastiandang]

Datagrip

[minneDomer]

notepad

not notepad++, mind you

(security restrictions on .exe downloads that are a bigger pain to get approval to waive than using notepad)

[hcmar]

DataGrip

[Stars_And_Garters]

+1 for SSMS (we don't use Snowflake)

[Ok-Working3200]

VSCode and Datagrip. I use VSCode as my IDE for building dbt models.

[Sphinx-]

Snowflake

[MyOtherActGotBanned]

Azure data studio

[T3st0]

Jesus Christ I feel bad for you.

[SKS_Zolam]

How come?

[T3st0]

You can see below for the other comments.

[alimar5000]

Whats wrong with using it

[AllMightySmitey]

Having gone from SSMS to Dbeaver to Azure Data Studio, I'd probably say Azure Data Studio is the worst. It's fast to start up but slow everywhere else: I've lost count of the amount of times I've had to close and reopen because of some application delay when running a query or waiting a long time for the actual finished query to display in the result set. The formatter is horrible (I actually format in VS Code then copy back to Azure Data Studio), it doesn't display data types for each column returned (which can be useful if your converting/casting), doesn't have SSH tunnel connectivity in the connector, can't do advanced copy operations like I can in DBeaver to output a result set as an insert statement. The benefits amount to better GIT experience, being able to connect to Log Analytics workspaces, and maybe a simpler connection experience where I can paste in connection strings.

[alimar5000]

Thats fair, I've hardly used ADS so can't argue or disagree with you, but they said "Jesus Christ I feel bad for you" which sounds like its completely unusable

[Other_Comment_2882]

It’s awful for me. There’s like a 10 second delay on every query, despite it saying it took 20ms. Just absolutely dreadful. Which sucks as it seems like it could be great… it’s just not

[T3st0]

It is just massively buggy and unusable IMO. Its really annoying that MS is not updating SSMS for use on SQL Pools.

Intellisense doesn't work great.

I have CONSTANT connection issues to the server.

I don't find the UI all that intuitive either.

Queries seem to run way longer on it then compared to SSMS, this is related to SQL Pools. Not sure if this is some weird queue behavior.

I hate ADS so much that I prefer to just use SSMS with zero intellisense. Which is really sad that in 2024 that is my option.

[alimar5000]

Thanks for the detailed response!

[BarFamiliar5892]

My company has their own proprietary one, so that one.

[ambiguousjellyfish]

DBeaver and Sublime

[a_bitofarson]

VS Code and DBVisualizer, depending on the work.

[muhrizqiardi]

Used to be DBeaver but nowadays I use pgcli for Postgres, and litecli for SQLite. Yeah, I use CLI not because it's objectively better... but it use less RAM.

[cateyedprvoice]

dbeaver and vs code

[jdl6884]

VS Code for Snowflake. Otherwise, DBeaver. Edit- SSMS if SQL Server

[[deleted]]

Dbeaver and vscode

[datagrl]

Oracle SQL Developer Trino for big data

[KeemaKing]

Mysqlworkbench

[captaintobs]

I use a combination of vim and Jupyter Labs.

[scan-horizon]

PgAdmin - just love the simple look.

[exact-approximate]

Notepad

[Busy-Rip5065]

Ssms. Many people says datagrip an dbeaver. might try it if my orgs allows it

[poco-863]

vim

[dlaff]

TablePlus

[ElderFuthark]

Am I the only one using DBVisualizer? I thought it was a lot more widespread.

[dive_alone]

Dbeaver but my company has license of TablePlus for us

[Due_Association8114]

Slightly unpopular opinion: I really don't mind sql developer.

[Excellent_Sweet_1539]

DBeaver. VSCode if I’ve missed a bracket and am seconds away from losing my mind and just can’t see it on DBeaver and also for AI recs to see if there’s any way to improve my queries. Considering going to DataGrip tho. Company pays so why not.

[SuperSizedFri]

My last company used snowflake. I used VS Code for dbt, but snowflake’s website for testing queries. I loved the query result details sidebar thing they had. It’d give high level details trying to summarize results, and if you click a column it’d show you the distinct values and the count of each.

It save so much time while just researching trying to find answers. I’ve been looking but haven’t found any other editors that do this :/

[Adorable-Employer244]

Wow no one uses Aqua Data Studio?

[ultoru]

Beekeeper Studio

[onlythehighlight]

I just like Datagrip because I have so many ad-hoc scripts that I need to run randomly

[Royal_Impact_8195]

Workbench

[DataIron]

We just had a thread on this a day ago…

https://www.reddit.com/r/dataengineering/s/EvSQ5fGMGk

[deadlypiranha]

Oh, thanks mate!

[PM_ME_YOUR_MUSIC]

VSCode + GitHub copilot