tbigqueryinput support for DML statements

[Anonymous]

Hi All,

I am trying to run an insert DDL statement against a table in Big Query. I know now Talend tbigqueryinput component supports DML statements. However i am getting the following error for all types of DML INSERT, UPDATE, DELETE

My query is perfectly valid as i ran it against BigQuery directly. Also it happened for all types of DML queries. DDL queries are working fine.

Sample DML :

#standardSQL\r\n INSERT `SurveyMonkey.Survey_Monkey_Customer_Names` (person_customer_id, person_customer_name) SELECT * FROM SurveyMonkey.Survey_Monkey_Customer_Names"

Talend Job looks like this:

What am i doing wrong?

[Anonymous]

Hello,

Our Google BigQuery components rely on Google "SQL". This is a subset of SQL, that limits actions to simple selections.

Google now offers "Standard SQL" in their Data Manipulation Language (DML), which features extended actions (such as insert, update, delete operations).

For some examples of their DML cf. https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax

Here exists a jira issue:https://jira.talendforge.org/browse/TBD-5959.

Best regards

Sabrina

[Anonymous]

Yeah i know tbiqueryinput does not implicitly support StandardSQL. But i am using #StandardSQL on top of the query to interpret it as Standard SQL. But i am still getting this error.