Menu
Simba Technologies
Simba Technologies

Simba JDBC Driver with SQL Connector for Google BigQuery 1.1.9
Installation and Configuration Guide

Building the Connection URL

Use the connection URL to supply connection information to the data store that you are accessing. The following is the format of the connection URL for the Simba JDBC Driver for Google BigQuery:

jdbc:bigquery://[Host]:[Port];ProjectId=[Project];OAuthType=[AuthValue];[Property1]=[Value1];[Property2]=[Value2];...

The variables are defined as follows:

  • [Host] is the DNS or IP address of the server.
  • [Port] is the number of the TCP port to connect to. Specifying the port number is optional if you are connecting to port 443.
  • [Project] is the name of your BigQuery project.
  • [AuthValue] is a number that specifies the type of authentication used by the driver. For more information, see OAuthType and Configuring Authentication.
  • [Property1..N] and [Value1..N] are additional connection properties supported by the driver. For a list of the properties available in the driver, see Driver Configuration Options.

Important:

  • Properties are case-sensitive.
  • Do not duplicate properties in the connection URL.