Database driver BigQuery
Table of contents
This documentation details the steps for configuring and utilizing BigQuery with DBeaver. The integration in DBeaver supports distinctive BigQuery functionalities, accommodating its serverless infrastructure, robust scalability, and compatibility with multi-cloud data analytics.
Before you can start managing your database, it's essential to establish a connection in DBeaver. This involves
BigQuery option to connect to the BigQuery. If you have not yet created a
connection in DBeaver, please refer to our Creating a Connection article for guidance.
DBeaver's database management capabilities include support for various data types tailored for complex data operations, such as:
- BIGNUMERIC: Handles large-scale or high-precision decimal numbers.
- GEOGRAPHY: Manages spatial information.
- INTERVAL: Tracks durations with precision.
Additionally, DBeaver provides tools for database schema customization and task automation:
- Views: Enables the creation of virtual tables based on SQL queries.
- Procedures: Allows for the definition and execution of stored procedures for routine database tasks.
This section provides an overview of DBeaver's settings for establishing a direct connection and the configuration of secure connections using SSH, Proxies, and Kubernetes.
BigQuery connection settings
In this subsection, we will outline the settings for establishing a direct connection to a BigQuery database using DBeaver. Correctly configuring your connection ensures seamless interaction between DBeaver and your BigQuery database.
The page of the connection settings requires you to fill in specific fields to establish the initial connection.
|Enter the project ID for the Google Cloud Project where the BigQuery service is located.
|Specify any additional project IDs if applicable.
|Set the host URL to the BigQuery API endpoint.
|Enter the port number for your BigQuery database. The default BigQuery port is
|Choose the type of authentication you want to use for the connection. For detailed guides on authentication types, please refer to the following articles:
- Google Cloud IAM
- DBeaver Profile Authentication
You can also read about security in DBeaver PRO.
|Provide additional connection details if necessary.
|This field will be auto-filled based on your selected driver type.
|If there are any specific driver settings, configure them here.
The Connection Details section in DBeaver allows for further customization of your BigQuery connection. This includes options for adjusting the Navigator View, setting up Security measures, applying Filters, configuring Connection Initialization settings, and setting up Shell Commands. Each of these settings can significantly impact your database operations and workflow. For detailed guides on these settings, please refer to the following articles:
- Connection Details Configuration
- Database Navigator
- Security Settings Guide
- Filters Settings Guide
- Connection Initialization Settings Guide
- Shell Commands Guide
Secure connection configurations
DBeaver supports secure connections to your BigQuery database. Guidance on configuring such connections, specifically SSH, Proxy, and Kubernetes connections, can be found in various referenced articles. For a comprehensive understanding, please refer to these articles:
Powering BigQuery with DBeaver
DBeaver provides a host of features designed for BigQuery databases. This includes the ability to view schemas, along with numerous unique capabilities aimed at optimizing database operations.
BigQuery database objects
DBeaver lets you view and manipulate a range of BigQuery database objects, such as:
- Foreign keys
BigQuery additional features in DBeaver
DBeaver provides additional features compatible with BigQuery, but not exclusive to it:
|Mock Data Generation