Database driver BigQuery

Note: This driver is available in Lite, Enterprise, Ultimate and Team editions only.

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 selecting the 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.

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.

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

DBeaver supports secure connections to your BigQuery database. Guidance on configuring such connections, specifically SSH, Proxy, Kubernetes and AWS SSM connections, can be found in various referenced articles. For a comprehensive understanding, please refer to these articles:

• SSH Configuration

• Proxy Configuration

• Kubernetes Configuration

• AWS SSM

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.

DBeaver lets you view and manipulate a range of BigQuery database objects, such as:

• Schemas

  • Tables
    • Columns
    • Keys
    • Foreign keys
    • Indexes
    • References
  • Views
  • Procedures

DBeaver provides additional features compatible with BigQuery, but not exclusive to it: