Skip to Content
1
Jun 05, 2020 at 01:47 PM

SAP Data Intelligence Pipeline modeler connection with GCP partitioned tables

356 Views

Hi,

We are working with SAP Data Intelligence pipeline modeler. We are trying to create a connection to the Google Cloud Platform by using the 'Google Bigquery SQL Consumer' operator. The documentation says that the operator only supports 'legacySQL' which is a problem since we are trying to connect to a partitioned table inside GCP which only supports 'standardSQL'. This means that we can't fetch data with the given operator. Is there any other way to connect to a GCP partitioned table using standardSQL inside the pipeline modeler or any work around for this? This is very crucial for us.

Thanks