Hello, I’m running into an error importing data f...
# gooddata-platformm
Michael Ashmead
06/27/2022, 7:30 PMHello, I’m running into an error importing data from BigQuery:
It’s a simple model with just 1 table and 1 column in the model
When I first create the table in the model, the preview of the data displays fine, but then when the scheduled load runs, it fails with the error attached:
j
Jan Kos
06/27/2022, 8:35 PMHello Michael, the log suggests there is a problem on line 279 - could you please check in your source data if there is some unexpected character? Please make sure your source data are in supported data types and you are following our naming convention for output stage
m
Michael Ashmead
06/27/2022, 8:38 PMIsn’t this error message from the query from Gooddata being sent to BigQuery?
Michael Ashmead
06/27/2022, 8:39 PMThe data I have in BigQuery is just 1 column of numbers:
Michael Ashmead
06/27/2022, 8:42 PMOkay, I tried one other thing. I created a new table in BigQuery with just 1 row of data, but got this error instead:
Michael Ashmead
06/27/2022, 8:43 PMI can see the preview of the data in the model fine. But the scheduled import fails
Michael Ashmead
06/27/2022, 8:43 PMScreen Shot 2022-06-27 at 4.43.50 PM.png
j
Jan Soubusta
06/28/2022, 6:35 AMCould you try to find out the SQL statement executed by GoodData platform in the session history?
https://cloud.google.com/bigquery/docs/sessions-view-history#console
It seems that we generate invalid SQL statement containing either OF or AND in the wrong position...
m
Michael Ashmead
06/28/2022, 6:34 PMOkay, I was able to fix it by looking at the query being sent
Michael Ashmead
06/28/2022, 6:35 PMIt looks like GoodData breaks down when there is a space in the view name and can’t generate the query correctly (in BigQuery spaces in views names are valid, however)
Michael Ashmead
06/28/2022, 6:38 PMThank you for the assistance
j
Jan Soubusta
06/28/2022, 8:06 PM@Andrey Skripnikov seems like a bug...should we create an internal ticket?
👌 1