Connecting to Google BigQuery from DBeaver via the ODBC driver.

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

Related Software Products
ODBC Universal Bundle
ODBC Universal Bundle

Published By:
Devart

Description:
Devart ODBC Universal Bundle: Every Devart ODBC Driver on One License Devart ODBC Universal Bundle is one license for all of Devart's ODBC drivers: 78 drivers covering what Devart counts as 92 databases, warehouses and cloud apps, from SQL Server, Oracle and Snowflake to Salesforce, Shopify, QuickBooks and Jira. It's for analysts, BI developers and IT teams who need several sources in Excel, Power BI, Tableau or SQL Server, and it costs $499.95 a...


Related Videos
Devart ODBC Drivers: 3 steps to connect your data
Devart ODBC Drivers: 3 steps to connect your data

Video Length: 00:30
Uploaded By: Devart (1/15/2024)
View Count: 306,028

Access Salesforce data directly with ODBC for Salesforce
Access Salesforce data directly with ODBC for Salesforce

Video Length: 00:39
Uploaded By: Devart (1/15/2024)
View Count: 23,192

Copyright © 2026, Ivertech. All rights reserved.