Hiding Sensitive Parameters Connecting to BigQuery Using OAuth Authentication

While SAS has a Google BigQuery interface, authentication can be an issue if you want to use it. You have the option of using a service account or using OAuth authentication. If you use OAuth authentication, you have to provide the client ID, secret and refresh token to the libname statement. In order to hide the client secret from our users, and avoid having them handling refresh tokens, we developed a set of encrypted macros that can get the refresh token for the user and use it to create a regular library or a CAS library. This allows our users to access the same data they can access directly on BigQuery, without having to handle authorization directly on the SAS environment. Additional resources ◉ SAS Global Certification Program – https://www.sas.com/certify ◉ SAS Learning Subscription – https://www.sas.com/en_us/training/programs/learning-subscription.html SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS https://www.youtube.com/SASUsers?sub_confirmation=1 ABOUT SAS SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change. CONNECT WITH SAS SAS ► https://www.sas.com SAS Customer Support ► https://support.sas.com SAS Communities ► https://communities.sas.com SAS Analytics Explorers ► https://explorers.sas.com Facebook ► https://www.facebook.com/SASsoftware Twitter ► https://www.twitter.com/SASsoftware LinkedIn ► https://www.linkedin.com/company/sas Blogs ► https://blogs.sas.com RSS ► https://www.sas.com/rss