Connecting to Google BigQuery Using OAuth Authentication

animesh123 — Mon, 02 Dec 2024 12:52:33 GMT

We are following the process below to create a service account token for connecting to GCP Big query.

Created an Azure client id and client secret.
Generated an Azure Access Token using ClientID, client secret, and GCP project number.
Created a Workload Identity Token using GCP project number and Azure Token.
Generated a Service Account Token using service account name and workload identity token.

We have updated the SAS code to connect to GCP Big query using GCP project ID and Service Account Token as a refresh token, and the project Id as the Client ID.

We are unsure about the correct value to use for the client secret. Could you please guide us on how to establish a connection using the Service Account Token generated from the WIF process.

%let WIF_TOKEN = %sysget(WIF_TOKEN);

options sastrace='d,d,d,dsa' sastraceloc=saslog nostsuffix;
proc sql;
connect to bigquery as dbcon
(project='xxxxxxxxx'
schema='xxxxx'
Readbuff=xxxxx
Scanstringcolumns=YES
auth_token=''
);
create table sde_model (compress=yes) as
select * from connection to dbcon
(SELECT
vehicle_master_pii.vin,
vehicle_master_pii.model ,
vehicle_master_pii.model_year ,
upper(vehicle_master_pii,nameplate)
FROM
`prj-dfdm-10-cdm-p-0010.bq_cdm_core_fdp_dmc_vw.vfc_vehicle_master_vw` as vehicle_master_pii LIMIT 10;
);
quit;

options sastrace=none;

Re: Connecting to Google BigQuery Using OAuth Authentication

SAS_Cares — Wed, 04 Dec 2024 17:52:23 GMT

Here's a resource you may find handy: https://communities.sas.com/t5/SAS-Communities-Library/A-new-Cloudy-SAS-ACCESS-engine-Google-BigQuery/ta-p/594432 Let us know if this helps!

topic Connecting to Google BigQuery Using OAuth Authentication in New SAS User

Connecting to Google BigQuery Using OAuth Authentication

Re: Connecting to Google BigQuery Using OAuth Authentication