Purpose

Specifies either the name or the absolute path and name of the configuration file where the map of the Google BigQuery data model is written. The driver looks for this file when connecting to a Google BigQuery instance. If the file does not exist, the driver creates one.

Valid Values

string

where:

string
is either the name or the absolute path and name (including the .config extension) of the configuration file. For example, if SchemaMap is set to a value of:
  • ABC, the driver either creates or looks for the configuration file ABC in the working directory of your application.
  • C:\\Users\\Default\\AppData\\Local\\Progress\\DataDirect\\ GoogleBigQuery_Schema\\abc@defcorp.com.config, the driver either creates or looks for the configuration file abc@defcorp.com.config in the directory C:\Users\Default\AppData\Local\Progress\DataDirect\GoogleBigQuery_Schema.

Notes

  • When connecting to a Google BigQuery instance, the driver looks for the schema map configuration file. If the configuration file does not exist, the driver creates the schema map configuration file using the name and location you have provided. If you do not provide a name and location for the configuration file, the driver creates it using default values.
  • The driver uses the path specified in this connection property to store additional internal files.

Example

As the following examples show, escapes are needed when specifying SchemaMap for a data source but are not used when specifying SchemaMap in a DriverManager connection URL.

Driver Manager Example

jdbc:datadirect:googlebigquery:Project=myproject;Dataset=mydataset;
AccessToken=abcdefghi12345678;RefreshToken=wxyz123456789;
ClientID=123abc.apps.googleusercontent.com;ClientSecret=ab123xy;
SchemaMap=C:\Users\Default\AppData\Local\Progress\DataDirect\
GoogleBigQuery_Schema\abc@defcorp.com.config

Data Source Example

GoogleBigQueryDataSource ds = new GoogleBigQueryDataSource();
ds.setDescription("My Google BigQuery Datasource");
ds.setProject("myproject");
ds.setDataset("mydataset");
ds.setAccessToken("abcdefghi12345678");
ds.setRefreshToken("wxyz123456789");
ds.setClientID("123abc.apps.googleusercontent.com");
ds.setClientSecret("ab123xy");
ds.setSchemaMap("C:\\Users\\Default\\AppData\\Local\\Progress
\\DataDirect\\GoogleBigQuery_Schema\\abc@defcorp.com.config")

Data Source Method

setSchemaMap

Default

The default is determined by the environment. The driver attempts to create the files in a subdirectory of the first available directory in the following order:

  • Windows
    • DD_HOME environment variable
    • dd.home system property
    • LOCALAPPDATA environment variable
    • APPDATA environment variable
    • user.home system property
    For Windows, the file path takes the following format:
    available_location\Progress\DataDirect\GoogleBigQuery_Schema\user_name.config
  • UNIX/Linux
    • DD_HOME environment variable
    • dd.home system property
    • user.home system property
    For UNIX/Linux, the file path takes the following format:
    available_location/progress/datadirect/GoogleBigQuery_schema/user_name.config

Data Type

String

See also

Configuring OAuth 2.0 authentication

Mapping properties