GOOGLE BIG QUERY CLIENT

The Google Big Query client championed by users

Materialized views.
Procedures.
Views.
+10
* EXTENDED SUPPORT
CUSTOM OBJECT SUPPORT FOR MATERIALIZED VIEWS, PROCEDURES, VIEWS & 10 MORE GOOGLE BIGQUERY SPECIFIC OBJECTS.
BigQuery editor
g2 logo

*****

4.7 (100+ REVIEWS)
#1 HIGHEST RATED
IN DATABASE MANAGEMENT SYSTEMS

g2 logo

*****

4.7 (100+ REVIEWS)
#1 HIGHEST RATED
IN DATABASE MANAGEMENT SYSTEMS

a top-performing google Bigquery CLIENT

A Google BigQuery client you can trust

Download for free ↓
Recommended Installer
windows
Windows 64bit With Java
windows
Windows Arm64 With Java
linux
Linux Without Java
mac
macOS Apple Silicon With Java
mac
macOS Intel With Java

DbVisualizer holds a great track record as a high-performing database client.

Within DbVisualizer, you'll find all the necessary tools to facilitate the development, connection, and management of your BigQuery database. It offers extended support for BigQuery-specific object types and covers all the features that contribute to the excellence of BigQuery.

OBJECT TYPES AND ACTIONS

Supports object types specific to BigQuery

DbVisualizer gives you full control of your BigQuery database. It even offers support for object types and actions specific to BigQuery. Here are some examples.

PROPERTIES

Configurable for how you want to work

You can set up custom properties for your BigQuery databases directly in DbVisualizer, to make it the best BigQuery client matching your preferences. Make sure the user is prompted to enter User ID and password. Enable preprocessing of scripts. You can even set up auto-commit and much more.

The properties below and many more can be configured to match how you want to work.

authentication
AUTHENTICATION
Delimited identifiers
DELIMITED IDENTIFIERS
Qualifiers
QUALIFIERS
Physical connection
PHYSICAL CONNECTION
Transaction
TRANSACTION
Encoding
ENCODING
sql statements
SQL STATEMENTS
Connection hooks
CONNECTION HOOKS
Color and border
COLOR AND BORDER
sql editor
SQL COMMANDER
query builder
QUERY BUILDER

SQL client

The universal
database tool

DbVisualizer manages the distinct objects and properties of Google BigQuery. Furthermore, it includes robust features that are compatible with a broad range of data sources.

VISUALIZATION

Automatic visualizations

To understand the relationships between objects in Google BigQuery are vital. With Entity Relationship Diagrams automatically generated you ll be able to see all dependencies and potential directly in the BigQuery client.

Automatic visualizations

EDITOR

A powerful editor for Google BigQuery

While writing SQL for BigQuery shares similarities with other databases, it also involves unique nuances. DbVisualizer recognizes these distinctions and helps you compose SQL queries with improved efficiency.

Sql queries

SCHEDULING

Scheduling with Google BigQuery

Jobs can be automatically scheduled outside of the BigQuery client, using the command-line interface (CLI) and the pre-built scheduling tools of your OS.

FREE TRIAL

Try DbVisualizer Pro
for free

Start your free 21 day evaluation of DbVisualizer Pro

Download for free ↓
Recommended Installer
windows
Windows 64bit With Java
windows
Windows Arm64 With Java
linux
Linux Without Java
mac
macOS Apple Silicon With Java
mac
macOS Intel With Java

MAVEN

JDBC driver management via Maven

DbVisualizer comes equipped with the most current JDBC driver as well as previous versions for BigQuery, all integrated seamlessly. You can easily establish connections to your databases by utilizing the JDBC driver manager, which offers access to multiple driver versions hosted on Maven.

Big query driver manager
maven logo
Maven

reviews

Our users love our product

Users love using DbVisualizer with BigQuery.

Name:

Eric F.

Role:

Business Intelligence Developer

*****

DbVisualizer Streamlines Data Gathering Needs into 1 Application DbVisualizer streamlines my query needs by making it a one-stop shop. I have MongoDB, T-SQL, Oracle, etc. connections set up so I can access everything from one simple query tool. I like how I can connect to multiple database types from on...read more

DbVisualizer Streamlines Data Gathering Needs into 1 Application DbVisualizer streamlines my query needs by making it a one-stop shop. I have MongoDB, T-SQL, Oracle, etc. connections set up so I can access everything from one simple query tool. I like how I can connect to multiple database types from one application. I also like being able to quickly view the data without having to write or wait for a default query to run. The export to CSV is so much faster and easier than your standard SSMS. show less

Capterra logo

Verified user.

Review from Capterra

Name:

Karl Nicoletti

*****

My DB Client of choice! DbVisualizer is the easiest, most straightforward database development and troubleshooting tool I have used in my 30+ years as a developer. I have been using the Pro edition for almost five years now. Some of the features I find MOST useful are: 1) View complete DDL including ...read more

My DB Client of choice! DbVisualizer is the easiest, most straightforward database development and troubleshooting tool I have used in my 30+ years as a developer. I have been using the Pro edition for almost five years now. Some of the features I find MOST useful are: 1) View complete DDL including all constraints, 2) Debug Window!, 3) Drill down into and view blob field contents, 4) Format SQL, 5) Stored proc editor, 6) Editing in the SQL Commander show less

G2 logo

Verified user.

Review from g2.com

*****

Best DB software! Dark theme, supports many database types, i find it easy to create queries and run sql reports. It supports ssl tunnels so i dont have to allow outside sql connections. I use it daily.

Best DB software! Dark theme, supports many database types, i find it easy to create queries and run sql reports. It supports ssl tunnels so i dont have to allow outside sql connections. I use it daily. show less

G2 logo

Verified user.

Review from g2.com

*****

DBViz is the go-to for multi-database development. Multi-database development. Query results that can be searched. Connection highlighting to denote prod and dev environments. Link to your scripts folder and directly open them in the tool.

DBViz is the go-to for multi-database development. Multi-database development. Query results that can be searched. Connection highlighting to denote prod and dev environments. Link to your scripts folder and directly open them in the tool. show less

G2 logo

Verified user.

Review from g2.com

*****

Reliable, versatile, helpful. DbVisualizer providing user-friendly access to helpful tools that work consistently and predicatbly for all RDBMS platforms and across macOS, Windows, and Linux.

Reliable, versatile, helpful. DbVisualizer providing user-friendly access to helpful tools that work consistently and predicatbly for all RDBMS platforms and across macOS, Windows, and Linux. show less

G2 logo

Verified user.

Review from g2.com

Name:

Nithinan T.

Role:

Senior Software Engineer

*****

DbVisualizer is the Best DB Management I have been using DbVisualizer since I started working, which is more than 10 years now. DbVisualizer is an easy-to-use tool designed to work with almost every database. The databases I use regularly are DB2 and MariaDB. I use the pro package, which has a variety o...read more

DbVisualizer is the Best DB Management I have been using DbVisualizer since I started working, which is more than 10 years now. DbVisualizer is an easy-to-use tool designed to work with almost every database. The databases I use regularly are DB2 and MariaDB. I use the pro package, which has a variety of capabilities. I usually use check cost of SQL for the most performance running in program. show less

Capterra logo

Verified user.

Review from Capterra

Name:

Elizabeth Jarvis

Role:

Business Analyst

*****

Great tool, been using for 6+ years. I use DBVisualizer frequently - practically daily - over several SQL Server databases. As a business analyst, I use it for doing production support, testing software modifications, etc. DB Visualizer is easy to use, does everything I ask of it. Connections are ea...read more

Great tool, been using for 6+ years. I use DBVisualizer frequently - practically daily - over several SQL Server databases. As a business analyst, I use it for doing production support, testing software modifications, etc. DB Visualizer is easy to use, does everything I ask of it. Connections are easy to set up and I really like being able to set the color for different connections - to provide a visual cue as to which environment I am working in (production vs test). DB Visualizer has lots of features that I haven't used but would like to explore. I like that DBVis is continually making improvements to the software. show less

G2 logo

Verified user.

Review from g2.com

Name:

Edward M.

Role:

Director of Software Development & Integration

*****

Great Product I have been using this product for over 5 years. I searched for a long time, tried many other products but once I found DbVisualizer my search was over. I even prefer and use this over MySQL’s Workbench. This is my go-to product for dealing with our MySQL instances which host our data ware...read more

Great Product I have been using this product for over 5 years. I searched for a long time, tried many other products but once I found DbVisualizer my search was over. I even prefer and use this over MySQL’s Workbench. This is my go-to product for dealing with our MySQL instances which host our data warehouse. It has everything I need and it is simple to use. show less

Capterra logo

Verified user.

Review from Capterra

Name:

James Taylor

*****

Extremely powerful multi-platform db client. Spanning many years as a consultant at many different client sites, I have been able to connect to all different database types (DB2, Oracle, MySQL, SqlServer, etc) using DbVisualizer.

Extremely powerful multi-platform db client. Spanning many years as a consultant at many different client sites, I have been able to connect to all different database types (DB2, Oracle, MySQL, SqlServer, etc) using DbVisualizer. show less

G2 logo

Verified user.

Review from g2.com

Name:

Tim Solovyev

*****

Amaizing application to work with DBs in work. Almost all features are super usable. DbVisualizer is everyday software for working with Postgresql and Mysql servers. It's easy to connect, create, delete DBs, tables, construct and debug SQL queries.

Amaizing application to work with DBs in work. Almost all features are super usable. DbVisualizer is everyday software for working with Postgresql and Mysql servers. It's easy to connect, create, delete DBs, tables, construct and debug SQL queries. show less

G2 logo

Verified user.

Review from g2.com

AWARDS

Used and rated
by the best

Recognized by industry leaders and honored
across top review platforms!

FAQs

QUESTION
Action
WHAT IS BIGQUERY?

BigQuery is a data warehouse service by Google.

View + Hide -
WHAT IS A BIGQUERY CLIENT?

You use a BigQuery client to connect to and manage the BigQuery database

View + Hide -
WHAT IS A BIGQUERY DATABASE CLIENT USED FOR?

You use the BigQuery client for navigating and managing your database. For example, insert, delete and update tables.

View + Hide -
HOW DO I CONNECT TO BIGQUERY WITH DBVISUALIZER?

You easily connect to BigQuery using DbVisualizer's built-in driver manager.

View + Hide -
HOW CAN I USE DBVISUALIZER AS A QUERY TOOL?

With DbVisualizer, you write SQL queries, highlighting operations, and autocomplete suggestions are made automatically in a clever way. The visual query builder feature in DbVisualizer automatically generates SQL code as you drag and drop tables and select values.

View + Hide -
HOW DO I GET STARTED USING BIGQUERY WITH DBVISUALIZER?

Download DbVisualizer, and connect to your BigQuery database. Evaluate the DbVisualizer Pro version for 21 days or buy the Pro version to get the complete function set. There is a free version with limited functionality available.

View + Hide -
WHAT ARE THE BENEFITS OF USING BIGQUERY?

BigQuery is a flexible yet powerful data warehouse solution that is easy to scale and secure; it comes with built-in machine learning.

View + Hide -
CAN I CONNECT TO BIGQUERY AND OTHER DATABASES USING DBVISUALIZER AS A BIGQUERY CLIENT?

Yes, with DbVisualizer, you can connect to many different data sources for navigating and managing your data. A lot of organizations have many different db's, and with DbVisualizer, you get one tool to manage these (on this list) data sources.

View + Hide -
HOW CAN I CONNECT TO MY DATABASE USING THE BIGQUERY JDBC DRIVER?

You easily connect by selecting BigQuery from the list of available data sources and then entering the user credentials, and DbVisualizer will automatically set up the connection. This is easy since DbVisualizer has a built-in driver manager.

View + Hide -
WHAT OBJECT TYPES ARE SUPPORTED IN THE DBVISUALIZER BIGQUERY CLIENT?

DbVisualizer has extended support for BigQuery object types and functions; look at the list of supported object types.

View + Hide -
WHAT ARE SOME OF THE FEATURES OF THE BIGQUERY GUI IN DBVISUALIZER?

You can make quick comparisons, re-arrange tabs, work with variables, save scripts, create ERDs, and use the auto-complete feature as some examples. With DbVisualizer, you can easily customize the layout and functions to work the way you like it.

View + Hide -
WHAT IS THE DIFFERENCE BETWEEN A BIGQUERY CLIENT, A BIGQUERY GUI, A BIGQUERY IDE, A BIGQUERY EDITOR AND A BIGQUERY WORKBENCH?

All of those different environment labels mean pretty much the same thing and have become synonyms in how users refer to the tool where SQL coding is done. A client indicates that you have a server somewhere else. A GUI refers to the application's graphical user interface, while the IDE refers to the larger "integrated development environment.". An editor relates to an actual part of the tool where you write your code. A workbench focuses on the process of development.

View + Hide -
IS THERE A DATABASE BROWSER IN DBVISUALIZER?

Yes, you can browse each database and see the tables, relations, custom objects, etc., that have been created. The automatic visualization tool allows you to generate Entity Relationship Diagrams (ERDs) and/or see the servers explain plan.

View + Hide -
Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗