How to connect to Snowflake, BigQuery and Redshift via QueryPie
#Data Warehouse connection now available!
From the beginning of QueryPie’s closed beta, there was a lot of feedback about data warehouse sources like Redshift and Snowflake. So after high demand, QueryPie now supports new data sources including Snowflake, BigQuery and Redshift! Make sure you have the newest update (v.4.0.0)!
📢 QueryPie 4.0.0 Version Update!
The latest release includes not only data warehouses connection but improved auto-complete features and a single window mode. Now you can easily manage connection to any database through a drop-down menu on the top-left side of the pane. The database list will be available on your dashboard as well as the workspace!
Below, you can find the step-by-step guide on how to connect data warehouse sources.
Snowflake
1. Check your hostname on Snowflake and type in the Host field. ex: (account_name.snowflakecomputing.com)
*Note that full account name may include additional segments that identify the region and cloud platform where your account is hosted like ‘xy12345.east-us-2.azure’
2. Type the User name and Password needed to access the account.
3. Specify the Database Name.
4. If you want to specify Warehouse and role, add that as well.
- If you run into any problems connecting to your Snowflake account via QueryPie, please refer to the Official Snowflake’s documentation page or contact us over at the QueryPie Support Page!
BigQuery
1. Type the Service Account information from your BigQuery account key.
- To use the service account key information, you should create credentials on the google cloud platform. If you have not created one yet, please refer to the below steps:
Credentials on Google Cloud Platform
1. Go to Google Cloud Platform > APIs & Services > Credentials https://console.cloud.google.com/apis/credentials
2. Click the blue button ‘Create credentials’ > in the drop-down menu options select ‘Service account key’
3. If you created a new service account, please set the service account name and role (you can choose the role option on BigQuery) and create the key type for JSON.
- Download the JSON file, copy the entire code and paste to the Service Account field on QueryPie! You’re all set!
Redshift
1. Please check the host and port name on Redshift. You can type the JDBC URL and remove the ‘jdbc:redshift://’ ie. ‘example.123456789.us-west-2.redshift.amazonaws.com:5439/dev’.
2. Type the username and password.
3. Specify the Database name.
- If you run into any problems connecting to your Redshift account via QueryPie, please refer to the Official AWS Doc page or contact us over at the QueryPie Support Page!
# Easy and Intuitive SQL Tool for Data Warehouses!
QueryPie is one of the best and fastest growing cross-platform SQL IDE for data analytics. We currently support MySQL, MariaDB, PostgreSQL, AWS Aurora and several data warehouses including Snowflake, BigQuery, and Redshift. Try out the latest version on the website and feel free to send us your feedback!
📌 Download QueryPie: https://www.querypie.com/download
📌 QueryPie Team’s Development Journey: Review Previous Blogs
#1. Searching for my own Database IDE
#2. QueryPie: a fresh design for SQL IDE
#3. A team growing with Agile Scrum
#4. Electron Web App made with React; Layout, AntD Customization
#5. Drag & Drop, Resize in React App
#6. Cross-Platform Application Design with Electron, React, and gRPC
#7. Fullstack Development with TypeScript
#8. Why did we choose React and TypeScript for QueryPie?
#9. MySQL SSL Connection Using JDBC
#10. Introducing QueryPie’s first MVP
#11. Introducing QueryPie Open Beta
#12. Mistakes during development of our React/TS/Electron Application
#13. QueryPie Branding & SaaS Design Trends
To keep up with QueryPie updates, you can also subscribe to our social channels below:
📰 Subscribe to the QueryPie Social Channels for updates:
