Hello,
I have a question about SAS access to GCP BigQuery. We have some data on GCP BigQuery that we want to access using SAS. We have SAS on-prem version SAS 9.4. I saw that SAS has a product SAS/ACCESS Interface to Google BigQuery which can be used for achieving this task. Some questions:
Any other option how data can be retrieved from BQ not using SAS/ACCESS Interface to Google BigQuery but using SAS. I am not refering to any intermediate service (python for example) which can be used to extract data from BQ.
If I create a query and run it. How does SAS behaves? Does it enables BQ engine to process data or does it use SAS engine to process it.
I heard that it is quite expensive to move data from GCP to on-prem server (SAS server). Is it a myth or truth?
How does SAS deals with structs or arrays in BQ?
Thanks in advance
... View more