Unable to insert data to BigQuery Table

Help Activities
, , , , , , ,
1

Hi Guys,

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

I am using Simba ODBC driver to connect database and tables using studio.

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

Note: I can able insert the data using Execute Non Query activity, but unable to insert the datatable data using “Insert” activity.

I tried constructing the insert query to insert the data using Execute Non query but our purpose is to insert the bulk data available in excel sheets.

I am using below versions

Database Package version : 1.7.1
Studio\Robot: 2022.10.5
Simba ODBC Driver: 3.0.5.1011 (32 Bit) Drivers ODBC e JDBC para BigQuery  |  Google Cloud

Your help in this issue is highly required for me to fix this issue.

2024-08-27T18:30:00Z

2

@Sandesh_Reddy

The problem here is big query simba odbc drivers natively would not support standard schema calls …and insert needs it…your way would be to go with execute non query only

The image contains an important notice about the Insert activity using a DataAdapter to automatically generate insert/update queries based on the database schema, specifying the necessity of databases implementing standard schema calls for proper functionality. (Captioned by AI)
The image contains an important notice about the Insert activity using a DataAdapter to automatically generate insert/update queries based on the database schema, specifying the necessity of databases implementing standard schema calls for proper functionality. (Captioned by AI)828×449 92.9 KB

Cheers

2 Likes
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.