Revolving around the core of technology
|Subject:||Connecting to Google BigQuery with ODBC|
|Creation date:||2/8/21 2:03 PM|
|Last modified on:||6/25/21 12:35 PM|
You will need to fill out the following fields:
|Data Source Name/Description||This is a friendly name you want to apply to this Data Source.|
|Authentication||There are two types of authentication; User and Service Authentication. Each of them has a different method of authenticating. Please take a look here to see which authentication method most benefits you.|
|Catalog (Project)||When you successfully authenticate, you will see your projects. Click on the drop-down arrow to select the project you would like to connect to.|
|Dataset||Select the Dataset from your project you want to connect to.|
Once you specify your credentials, click the "Test" button at the bottom. If there are no issues, you should see the "SUCESS!" "Successfully connected to data source!" message.
Now that we are successfully connected, we can begin running queries and modifying the database.
For example, I am adding a new pet owner who has 2 dogs and 1 cat:
If I browse the data I can see that there is now a new pet owner:
Using your ODBC query tool you can interact with BigQuery directly easily. The benefit is that you also get the entire suite of your chosen tool as well as a much more informative interface.
Once you are connected to your BigQuery in WinSQL, you will be able to see all of your tables and data within WinSQL. To begin importing data directly from Microsoft Excel, simply drag and drop the .xlsx file directly into your Tables section as seen here:
Do you have a helpful tip related to this document that you'd like to share with other users?