topic Re: How do I obtain client_id & client_secret for authentication to Google Big Query? in Administration and Deployment

How do I obtain client_id & client_secret for authentication to Google Big Query?

zenenceladus — Sun, 17 Apr 2022 16:55:22 GMT

How do I obtain the client_id and client_secret to use with the getrefreshtoken utility for authenticating to Google Big Query with SAS VIYA 2021.2.5.

Re: How do I obtain client_id & client_secret for authentication to Google Big Query?

gwootton — Mon, 18 Apr 2022 13:42:13 GMT

When you create a client you specify the client ID and client secret. The process for creating a client can be found here:

https://developer.sas.com/apis/rest/#authentication-to-sas-viya

Re: How do I obtain client_id & client_secret for authentication to Google Big Query?

zenenceladus — Mon, 18 Apr 2022 23:27:23 GMT

I am trying to get a refresh token using the SAS/ACCESS to Big Query tools found here: https://support.sas.com/downloads/package.htm?pid=2459. So the client_id & client_secret are on the GOOGLE side.

Re: How do I obtain client_id & client_secret for authentication to Google Big Query?

gwootton — Tue, 19 Apr 2022 11:53:28 GMT

Sorry for my misunderstanding. It sounds like something you would need to create on the Google side then.

This page appears to have links for creating them.

https://cloud.google.com/bigquery/docs/authentication/end-user-installed