The number of Database Management Systems is already quite large, and increasing day by day. You have Oracle, PostgreSQL, MySQL, Redshift, BigQuery, Snowflake, and many others. If you are an SQL Developer, you may want a single-stop solution for managing all your SQL queries and a way to link all these systems to this single-stop solution. The solution, thankfully, exists in the form of Jetbrains DataGrip, and in this article, you’ll learn how to link one of the most popular Database Management Systems, Snowflake, to DataGrip. Before getting into DataGrip Snowflake Connection, let’s discuss what Snowflake and DataGrip are.
Introduction to Snowflake
Image Source
Snowflake is a Cloud Data Warehousing solution provided as a SaaS offering. It is built on Amazon Web Service, Microsoft Azure, or Google Cloud infrastructure that provides an unbounded platform for storing and retrieving data. Snowflake Data Warehouse uses a different proprietary SQL Database Engine with a unique architecture designed for the cloud. It is used for OLAP (Online Analytical Processing).
Unlike its peers like Redshift or BigQuery, it is not backed by any of the FAANG companies. It is flexible in the choice of the backend service provider (you can choose AWS, Azure, or Google Cloud, and also select the region). A SaaS (Software as a Service) offering, Snowflake is disruptive because it separates Compute and Storage, thereby allowing customers to pay for the two separately, and bundle them as per their requirements.
With Snowflake, there is no hardware or software to select, install, configure, or manage, therefore, making it ideal for organizations that do not want to have dedicated resources for setup, maintenance, and support for in-house servers. Like its peers, Snowflake uses Columnar Storage to speed up query execution using Parallel Processing. Snowflake is best known for its scalability and relative ease of use when compared to other Data Warehouses in the market.
Hevo Data is a No-code Data Pipeline that offers a fully managed solution to set up data integration from 150+ Data Sources (including 50+ Free Data Sources) and will let you directly load data to a Data Warehouse like Snowflake. It will automate your data flow in minutes without writing any line of code. Its fault-tolerant architecture makes sure that your data is secure and consistent. Hevo provides you with a truly efficient and fully automated solution to manage data in real-time and always have analysis-ready data.
Get started with hevo for free
Let’s look at some of the salient features of Hevo:
- Fully Managed: It requires no management and maintenance as Hevo is a fully automated platform.
- Data Transformation: It provides a simple interface to perfect, modify, and enrich the data you want to transfer.
- Real-Time: Hevo offers real-time data migration. So, your data is always ready for analysis.
- Schema Management: Hevo can automatically detect the schema of the incoming data and map it to the destination schema.
- Scalable Infrastructure: Hevo has in-built integrations for 100’s of sources that can help you scale your data infrastructure as required.
- Live Monitoring: Advanced monitoring gives you a one-stop view to watch all the activities that occur within Data Pipelines.
- Live Support: Hevo team is available round the clock to extend exceptional support to its customers through chat, email, and support calls.
Sign up here for a 14-day free trial!
What is Jetbrains DataGrip?
Image Source
DataGrip is an Integrated Development Environment (IDE) offered by Jetbrains, specifically for SQL queries. Its target audience consists of Database Administrators, SQL Developers, Data Engineers, Analysts, and anyone else who queries Databases/Data Warehouses frequently. It can integrate with a host of Database Management Systems, including Oracle, Redshift, and Snowflake. It provides a host of features that ease working with SQL queries, including an intelligent query console, smart code completion, efficient schema navigation, and query plan explanation.
With the introduction to all the relevant platforms done, let’s get started with the prerequisites for a DataGrip Snowflake Connection.
Prerequisites to Connect DataGrip to Snowflake
To set up a Jetbrains DataGrip Snowflake Connection, you will need the following:
- A Snowflake Account (if you don’t have a Snowflake Account, you can sign up for a 30-day free trial).
- DataGrip software (you can download the software for your OS from here). You will get a 30-day free trial, which will be sufficient for this tutorial.
Apart from this, it is assumed that you are familiar with SQL.
Setting up DataGrip Snowflake Connection
Follow the below-mentioned steps to establish DataGrip Snowflake Connection.
- Open DataGrip on your machine, and create a new project. Give it a suitable name.
Image Source: Self
- A new window will open up, click on the ‘Data Source Properties’ icon in the Database Explorer.
- If you don’t see the Database Explorer, you can access it by going to View > Tool Windows > Database Explorer.
Image Source: Self
- Under the Data Sources tab, click on the “+” button, and select Snowflake from the dropdown.
Image Source: Self
- You will now be prompted to fill in the details regarding your DataGrip Snowflake Connection. Specifically, you will be asked to fill in the Host Details, the Authentication Method, and the Database and Warehouse that you’d like to access. Before you fill in the details, note the nudge at the bottom asking you to download the missing driver files.
Image Source: Self
- Click on it. You should see the Snowflake JDBC Driver getting downloaded. If you wish to use a JDBC driver from an existing connection, you can follow the instructions here.
Image Source: Self
- Now that the driver files have been downloaded, let’s fill in the rest of the details. Log in to your Snowflake Account. Your account URL should look similar to the one below.
https://<account_id>.<region>.aws.snowflakecomputing.com
- It can differ slightly if you have chosen Google Cloud or Azure instead of AWS at the time of sign-up. But this URL is essentially your host. Copy and paste it in the ‘Host’ field.
- Next, you need to select an Authentication Method. The simpler choice is to use a Username and Password, wherein you will have to enter the exact Username and Password that you use to log in to Snowflake. Alternatively, you can choose an Authenticator. You can read more about the different options (Web Browser, OAuth, etc.) available for the authenticator here. For the purpose of this demonstration, the Username and Password method is chosen.
- Next, you need to add the name of the Database and the Warehouse you would like to set as default. Please note that specifying a name here doesn’t stop you from querying other Databases. The Database specified here will be set as default, i.e., it will be queried if the Database name is not explicitly specified in the query. You can try that for yourself: specify a Database name here, and then query another Database. It will work.
- If you wish to specify Schema and user, you can click on the ‘More Options’ dropdown.
Image Source: Self
- Once all the details are entered, you can click on the ‘Test Connection’ button in the bottom ribbon. If all is well, you should see a successful connection.
Image Source: Self
Note: A common error is the presence of a slash (/) at the end of the host URL. If you are copy-pasting the host URL, you may get a / at the end of .com. Remove it and try again.
- Once your connection is successful, click on ‘Apply’ and then click on ‘OK’. You should now be able to query your Snowflake Database in DataGrip. Try it for yourself.
Image Source: Self
- Note that you can edit the connection configurations any time by clicking the same ‘Data Source Properties’ button from the ‘Database explorer’ window. Apart from the ‘General’ tab, there are other tabs that you can explore for configuring your connection.
- For example, you can make the Database Read-only in the ‘Options’ tab, or determine the Introspection settings. Similarly, you can determine which Databases and Schemas to display in the ‘Schema’ tab. You are encouraged to explore these other configuration options by yourself.
Image Source: Self
As you can see, it’s as simple as that to establish a DataGrip Snowflake Connection.
Conclusion
This article helped you in establishing a DataGrip Snowflake Connection and also had a look at the frequently used configuration options. If you are an SQL Developer, you perhaps appreciate how powerful this tool is, and how straightforward this connection process was. Thanks for reading.
visit our website to explore hevo
However, extracting data from multiple sources requires a lot of time and resources. Integrating all this data into Snowflake is a tedious and time taking process but a Data Integration tool like Hevo can perform this process with no effort and no time.
Hevo Data with its strong integration with 150+ Sources, Data Warehouses & BI tools such as Snowflake, allows you to not only export data from sources & load data in the destinations, but also transform & enrich your data, & make it analysis-ready so that you can focus only on your key business needs and perform insightful analysis using BI tools.
Give Hevo Data a try and sign up for a 14-day free trial today. Hevo offers plans & pricing for different use cases and business needs, check them out!
Share your experience of working with Jetbrains DataGrip Snowflake Connection in the comments section below.