Error while inserting to the BigQuery Table

Sandesh_Reddy · August 28, 2024, 6:38pm

Hi Guys,

Unable to insert excel data to Big Query table using “Insert” Database activity.

I am using Simba ODBC driver to access the database and tables.

Error: Insert: ERROR [42000] [Simba][BigQuery] (70) Invalid query: Syntax error: unExpected keyword DEFAULT at [1:73]

Note: I can able to insert using Execute Non Query activity. But not with Insert activity.

2024-08-28

Robot
Studio
Studio Web
StudioX

Anil_G · August 28, 2024, 6:44pm

I believe it is the same query

cheers

loginerror · August 29, 2024, 6:25am

Duplicate

Topic		Replies	Views
Unable to insert data to BigQuery Table Activities excel , database , activities , studio , question , gcp , google , bigquery	2	30	August 28, 2024
Invalid query - insert into BigQuery table Activities database , activities , question	14	946	August 28, 2024
Incorrect syntax error in insert activity Help database , activities , error	16	6535	November 25, 2019
Error when inserting data into db Activities database , activities , studio , question	4	426	September 8, 2023
Syntax error when inserting data on a DB Studio studio , question , project_panel	5	1044	October 24, 2022