Connecting to Google BigQuery from DBeaver via the ODBC driver.
ℹ️ See how to connect to Google BigQuery from DBeaver through the Devart ODBC driver. Get familiar with the main benefits of Devart ODBC driver for Google BigQuery :
⚙️ Support for all of the BigQuery standard SQL expressions, including functions and operations, and all of the BigQuery data types;
⚙️ DML support, which allows you to modify data in a BigQuery data warehouse in the same way as in any other SQL database;
⚙️ Standalone installation file that doesn't require the user to deploy and configure any additional software such as a database client or a vendor library.
ℹ️ Find more useful information about Google BigQuery ODBC Driver here:
https://www.devart.com/odbc/bigquery/
🔥 Download Google BigQuery ODBC Driver:
https://www.devart.com/odbc/bigquery/download.html
✅ Subscribe to our channel
https://www.youtube.com/user/DevartSoftware/
#ODBCDriver #ODBCDriverGoogleBigQuery #GoogleBigQuery
#BigQueryConnection
#Devart
Closed Caption:
In this video, I’m going to show
you how to connect to Google
BigQuery from DBeaver through the ODBC driver.
You can follow the steps I’ll outline
to connect DBeaver to practically any
data source for which an ODBC driver exists.
Only the connection parameters will be different.
I already have Devart ODBC Driver for
Google BigQuery installed on my system,
so I’ll go ahead with a DSN setup.
In the ODBC Data Source Administrator, click Add
and select the driver for BigQuery in the list.
Give a name to your data source and
specify the Project and Dataset Id.
Click Request Refresh Token to
authorize the driver to BigQuery.
Sign in to your Google account
in the form that appears,
and allow the driver to view and
manage your data in Google BigQuery.
Test the connectivity by clicking Test Connection.
Open DBeaver.
To connect to the created DSN,
click New Database Connection.
Find the ODBC bridge driver
in the list, and click Next.
Specify your DSN in the
Database field and click Finish.
In Database Navigator, expand the
newly created ODBC data source.
You’ll see the list of existing
objects in your BigQuery project.
Right-click the data source
and select SQL {siquel} Editor.
In this editor, I’ll insert the SQL
script for creating a sample table.
To run the script, press Alt+X.
Next, I’ll insert some sample rows into the table.
As you can see, twenty rows
have been successfully inserted.
To see the created table and its
contents in the Database Navigator,
you may need to disconnect and
then reconnect to BigQuery.
If you still can’t see the created
table in the navigator, restart DBeaver.
Now, let’s select the newly inserted
records. As you can see in the results pane,
DBeaver displays all values as NULL.
We can change this.
We go to the Advanced settings of the driver
and select Ansi strings in the String Types.
Let’s disconnect and reconnect once again
just to be on the safe side. Now it works.
Next, I’ll delete a record with id 10.
Retrieve the data from the table again. You can
see, there’s no such record in the table anymore.
Finally, I’ll update a record with id 1 to
change the value of its first name attribute.
Now the attribute contains a different value.
Hopefully, this tutorial has provided
answers to your questions about
accessing BigQuery data from DBeaver.
We’ll try to create more videos soon.
Subscribe to Devart channel
and hit the notification bell.
Video Length: 02:42
Uploaded By: Devart
Published: 10/27/2020
View Count: 5,947