Home » Snowflake
      Bookmark ·  Report ·  More actions.. Lock comments ·  Pin thread



Post Comment

aginitydan14-May-19

At Aginity, we are in beta with a new query tool for Snowflake. Aginity Pro has the traditional SQL IDE capabilities that you expect. It works on Mac and Windows. It has Snowflake specific capabilities like the ability to change your warehouse (compute) quickly from the editor . It also introduces the concept of object oriented SQL allowing you to create and share reusable building blocks . We would love people to come check it out and help us shape the next generation SQL IDE. https://www.aginity.com/main/aginity-pro/

0ReplyMore..ReportDelete
nVector16-May-19

@aginitydan - how is aginity different from the traditional querying tools ? Whats the story / why behind your product ?

0ReplyMore..ReportDelete
ccoad21-Oct-19

Aginity is different from traditional querying tools by allowing you to save your SQL in an active analytics catalog, then referring to the saved SQL by name while coding, and the product then knows to execute the SQL behind the name at run time.  This helps analysts be more efficient when coding by not rewriting SQL and more consistent by using the same code every time they produce a result.  Aginity also does this on the team level.  Check out more here: https://www.aginity.com/active-analytics-catalog/ 

0ReplyMore..ReportDelete
priyab03-Oct-19

Thank you for sharing, I use DBeaver as its a bit more powerful than Snowflake worksheets. I will surely try out SQL Workbench.

0ReplyMore..ReportDelete
reubster01-Apr-20

Hi there, 

Wondered whether anyone's looked at DataGrip & Snowflake yet?

The basic things I need from an IDE are; 
- manage code as an integrated project 
- schema compare 
- git integration 
- intellisense 
- ideally, some sort of change differential rendering. 

Can't quite put it altogether in DataGrip as yet. 
 

0ReplyMore..ReportDelete
nVector01-Apr-20

Haven't tried DataGrip. Would be helpful for the comunity if you can share your experience (in a post) once you are successful setting it up

0ReplyMore..ReportDelete
UJSP321-May-20

Hi @reubster, did you find a product that did all that you have listed or achieve it with datagrips?

0ReplyMore..ReportDelete
dprutean26-Jul-20

I would consider DbSchema designer as well https://dbschema.com

If is about large databases, with 1000+ tables, you will see a difference with the design tools.

Also some features like schema compare and synchronization, HTML5 schema documentation makes the tool outstanding.

0ReplyMore..ReportDelete
dave-shaw01-Feb-21

Try DBHawk from Datasparc. It’s a web-based Snowflake IDE. Free trial is available.

With DBHawk, users only receive access to the data they need. DBHawk provides secure access to on-premise and cloud databases. DBHawk supports a wide array of SQL and NoSQL databases, including Athena, DynamoDB, Redshift, AWS RDS. DBHawk integrates with SAML & LDAP for secure user access management.

0ReplyMore..ReportDelete