JDBC Driver for Google BigQuery

Build 22.0.8462

ProjectId

The ProjectId used to resolve unqualified tables.

Data Type

string

Default Value

""

Remarks

When a query refers to a table it can leave the project implicit, or qualify the project directly as the catalog portion of the table:

/* Implicit, resolved against connection string */
SELECT FirstName, LastName FROM `Northwind`.`customers`

/* Explicit, project specified as catalog */
SELECT FirstName, LastName FROM `psychic-valve-137816`.`Northwind`.`customers`

If the query contains unqualified table references then they are resolved this way:

  1. If this property is set then the specified project is used.
  2. Otherwise, if the BillingProjectId is set then that project is used.
  3. Finally, if neither are set then the catalog from the first table in the query is used. In the above example the psychic-valve-137816 project would be used to resolve any other unqualified tables that would appear in the query (for example, if a JOIN were added).

Note that the query is not consulted when QueryPassthrough is enabled. So you either must set the connection ProjectId and DatasetId or qualify each individual table; otherwise the SELECT query fails.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462