Download DbVisualizer from the site link (https://dbvis.com/download/)

Download settings.jar

install DbVisualizer

Run dbvis

Accept agreement

Click: File -> Import Settings

select the settings.jar downloaded previously and import the settings

restart dbvis when prompted

click on one of the database connectors

change username from ryan.morillo to your SSO

Enter your work password (the one you change every 90 days)

Connect



For Hadoop you must have kerberos setup and have a current kerberos ticket



For GBQ you need to change the Database URL to have a project id that you have access to

Connection will give you a url you copy and paste into your browser

go to the page and accept

copy the auth token

return to dbvis and hit backspace to clear the url then paste the auth token

hit ok



To make DBVis actually usable after you connect :

Tools -> Tools Properties

In the popup Databases tab on the left column

Generic

    > Delimited Identifiers

        Change both Begining and Ending Identifier to ` (backtick)

    > Qualifiers

        Qualify Objects with Schema/Database

              check Autocompleation/Query Builder

              check Export

        Fully Qualify Objects

              check Auto Compleation/Query Builder

        Qualify Columns

              Nothing checked

    > Encoding

       UTF-8

    > SQL Statements

SELECT ALL

SELECT * FROM $$catalog$$$$schemaseparator$$$$schema$$$$schemaseparator$$$$table$$


SELECT ALL COLUMNS

SELECT $$columns$$ FROM $$catalog$$$$schemaseparator$$$$schema$$$$schemaseparator$$$$table$$


SELECT ALL WHERE

SELECT $$columns$$ FROM $$catalog$$$$schemaseparator$$$$schema$$$$schemaseparator$$$$table$$ WHERE $$where-columns$$


SELECT COUNT

SELECT count(*) FROM $$catalog$$$$schemaseparator$$$$schema$$$$schemaseparator$$$$table$$





The newest version of the jdbc driver for Google can be found from https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers 

To use it, after doing the rest of the steps unzip it in a %HOME%/.dbvis/jdbc/gdo_gcp_version_num directory and then make a new driver connector similar to the current one, in the software select window select all to get the files, it isn't just one of the files in the list.