To create a Google BigQuery source definition, use the Source Analyzer to import source metadata with the Google BigQuery ODBC data source.
In the Source Analyzer, click
Sources
Import from Database.
Select the Google BigQuery data source used to connect to the source database.
If you need to create or modify a Google BigQuery data source, click the
Browse
button to open the ODBC Administrator. Create the Google BigQuery data source and click
OK.
Select the new Google BigQuery data source.
Enter the user name and password to connect to Google BigQuery.
Specify a dummy username and password.
Click
Connect.
The following image shows the
Import Tables
dialog box where you can import a Google BigQuery source definition:
Select a dataset and scroll down through the list of tables to find the source you want to import. Select the Google BigQuery table or tables you want to import.
You can hold down the
Shift
key to select a block of sources within one folder or hold down the
Ctrl
key to make non-consecutive selections within a folder. You can also select all tables within a dataset by selecting the dataset and clicking
Select All
. Use the
Select None
button to clear all highlighted selections.
Click
OK.
The source definition appears in the Source Analyzer. In the Navigator, the source definition appears in the Sources node of the active repository folder under the source database name.