![]() ![]() ![]() Now, back to the IDE, we need to add a new Data Source. Note: Make sure you place that file in a safe place as it will allow anything with rights to read it to connect to your BigQuery dataset you are allowed to access. A credentials file will be downloaded and you can click on the Close button on the dialog. Make sure that the Key Type is set to JSON, then click on the Create button. Type the name of the account, for example “ datagrip”, in the Role section, select the BigQuery | BigQuery Data View, BigQuery | BigQuery Job User, and BigQuery | BigQuery User roles, then check the Furnish a new private key box. Make sure you have the right project selected, then click on the Create service account button. ![]() Update: if you prefer to watch a video instead of reading this post, please see a recent version of this tutorial created in April 2019.įirst, let’s get all the details needed to connect to BigQuery from the Cloud Console. BigQuery is a low-cost enterprise data warehouse designed to handle data analytics at a massive scale.Ĭurrently, DataGrip does not come with a built-in connector for BigQuery, so let’s connect the IDE to it. If you are still using such a version, we encourage you to upgrade to the latest IDE version and check out the native support.Ĭontinuing the series of posts on how to connect DataGrip (or any other IntelliJ-based IDE) to various data sources, in this post we’ll show you how to connect to Google’s BigQuery. This article covers support pre-2021.1 for BigQuery. To learn how to use this, head over to our Documentation. Florin Pățan The 2021.1 update brings full native support for BigQuery. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |