DBeaver Documentation

DOWNLOAD pdf

Database driver BigQuery

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

Overview

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.

Feature highlights

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.

Setting up

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.

Field Description
Project Enter the project ID for the Google Cloud Project where the BigQuery service is located.
Additional project(s) Specify any additional project IDs if applicable.
Host Set the host URL to the BigQuery API endpoint.
Port Enter the port number for your BigQuery database. The default BigQuery port is 443.
Authentication 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.
Connection Details Provide additional connection details if necessary.
Driver Name This field will be auto-filled based on your selected driver type.
Driver Settings If there are any specific driver settings, configure them here.

Connection details

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:

Secure connection configurations

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:

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:

  • Schemas

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

BigQuery additional features in DBeaver

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

Category Feature
Data Transfer Data Import
Data Export
Schema Management Schema Compare
ERD Guide
Data Generation Mock Data Generation
Query insights Result details