[video]
Presenter: Sebastian Tobar
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.
