Welcome to the BigQuery Connector Setup guide!

In this article, we will cover the following:

Savant accesses your Oracle DB from two IP addresses:

If your network is configured to only allow access from certain IPs, include these in your whitelist.

First, open separate tabs in your browser for Savant and BigQuery and login to both.

In Savant, click on "Data" in the top menu, and toggle to the "Systems" option in the upper left of the page. Click the "New System" button.

This will take you to a page with a list of all available connected systems in Savant. Scroll or search among the selections for BigQuery and select the icon, then click "Next".

On the next page, you will be asked to authenticate the connection by completing the required "Project ID" field.

In your BigQuery tab, click into your organization name to find the name of your desired Project and its corresponding Project ID:

Copy the Project ID, navigate back to your Savant tab and paste it into the Project ID field.

With all required fields completed, click "Authenticate with: Google" and enter the necessary login credentials.

Next, you will have an option to configure the dataset so it only includes the fields necessary for your analysis, and to preview the data. Select items from the Dataset and Table drop-down menus and click "Apply." A preview of the dataset will load. Check the boxes next to the desired columns and click "Next."

This will load a page where you can choose to rename your system and include an optional Description. Once finished, click "Confirm".

Your new BigQuery system is now authenticated in Savant!

If you are working within an analysis, on the top left side of your canvas, click the Add Dataset button shown below, and select your BigQuery connection.

If you are not currently within an analysis, you can add your connection by navigating to Data and selecting New Dataset. Select your authenticated BigQuery system from the list of available options and click Next.

In the Configure Dataset section, you will see drop-down menus for Dataset and Table.

Select the Dataset, Table, and columns that you want to use for your dataset and click Next.

Lastly, give a name and description to your new dataset and click Confirm.

Your BigQuery system is now added as a dataset within your analysis!