I’m trying to use Insert activity to upload datatable into BigQuery table. I’m using Connect to database to set connection. Then I tried:
- Building dt in workflow, then insert it → error.
- Creating excel file, reading it, inserting → error.
- Creating excel file, reading it, substituting column names with names from BigQuery table to make them identical → error.
- I even tried to download table from GCP directly, and then upload those same values with Insert → still same error…
Still getting this one:
Insert: ERROR  [Simba][BigQuery] (70) Invalid query: Syntax error: SELECT list must not be empty at [1:9]
What am I doing wrong? Normal insert row by row, like with query is working fine, but activity “Insert” keeps failing.
Looks like some data is expected and it is missing in the provided datatable…
can you open the exception details from locals panel when you run in debug mode and check
Exception details has the same message, nothing more useful.
I created another dummy table, only two string type nullable columns, simple names. Recreated it in Studio and try to Insert.
Same error, but with ending [1:17]
Can you show your Datatable…is any of the column havign empty values?
Only two values in excel, one per column, read properly in studio. But still having issue while trying to insert such small data.
1/ I would recommend to change name of this topic to indicate it is about insert to BigQuery
2/ From your desription I understand that you can read from BigQuery table but can not insert to it → it might be a problem of Insert activity implementation
BTW - Did you try search forum for BigQuery related topics?
Why aren’t you using Bulk Insert?
A quick question …are you suing odbc drivers? or oledb?
Hello Anil_G, It’s odbc driver
It’s not working - same as Insert
Then as a next step can you try changing the version of your database activities and check…looks like the statement generated by the activity is wrong and it is failing
I would look in the database logs to see if you can find what it doesn’t like about the database query. I would also try a simple insert to see if it works. If it does, then the issue may be in your data. Special characters in a column name or something.