SQL Pass-Through Facility Specifics for Google BigQuery

Key Information

For general information about this feature, see SQL Pass-Through Facility.

Here are the SQL pass-through facility specifics for the Google BigQuery interface.

• The dbms-name is bigquery.
• The CONNECT statement is required.
• PROC SQL supports multiple connections to Google BigQuery. If you use multiple simultaneous connections, you must use the alias argument to identify the different connections. If you do not specify an alias, the default bigquery alias is used.
• The CONNECT statement’s database-connection-arguments are identical to its LIBNAME connection options.

CONNECT Statement Example

This example uses the DBCON alias to connect to mysrv1 the Google BigQuery database and execute a query. The connection alias is optional.

proc sql;
   connect to bigquery as dbcon
   (cred_path='/u/BigQuery/xxx-yyy-9e99c10a8888.json' 
    project='project1' schema='Region1');
select * from connection to dbcon
   (select * from customers WHERE customer like '1%');
quit;