SAP BODS SQL Transform not accepting BigQuery SQL in Google Cloud Platform

[former_member308471]

Hi All,

Can someone guide on correct syntax of providing table name to GCP BigQuery API.

I am using a simple SQL like beow but it is giving error.

I have a project name in format : a-b-c

then a schema : Test

then a table : Customer_Test1

SQL :

select 1 from a-b-c.Test.Customer_Test1 limit 10

The same script runs smoothly on GCP query interface.

I have a doubt that " - " in project name is probably giving issue but don't know how to avoid id.

Kindly advice.

Regards,

Kiran

[andres_macavilca]

Hello Kiran,

Could you solve the issue? Maybe you can share the solution.

Thank you.