I tried Data Studio, I really did.

The attempt to like a GUI falls flat again.

So on my recent forray into writing a stored procedure, I tried to use Data Studio. It wasn’t quite as horrible as I remember GUIS. The main thing I hated was that when it lost its connection, it didn’t tell me, and I had to go in and figure out why my create procedure statement was suddenly failing. If we’re going to go the gui route, it seems like it should go whole hog, and when it realizes the connection is lost, pop up a box saying “hey, you lost your connection, click here to reconnect”. I also gave up and pulled out my SQL to explain and analyze it myself at the command line because I wasn’t having much luck doing it through Data Studio, and I thought that would be one of the things it would excel at.

So I’m going to try it some more. I did like that it gave me the general procedure structure (would have taken me 5 or 10 minutes to find that via google/info center). I’m working on training a colleague who wants to be a dba, and he is very GUI-oriented, so I’m going to take the hint and try to learn for myself. But so far, I’m not impressed – give me my command line.

Ember Crooks
Ember Crooks

Ember is always curious and thrives on change. She has built internationally recognized expertise in IBM Db2, spent a year working with high-volume MySQL, and is now learning Snowflake. Ember shares both posts about her core skill sets and her journey learning Snowflake.

Ember lives in Denver and work from home

Articles: 557

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.