Hi all, I have tried the brand new BigQuery connector as a data source in my good data cloud trial account. I am able to create the datasource and the connection looks ok but each time I run a "table scan", I am facing the following error :

{"abeType":"UE","cause":{"message":"Request failed with status code 500","name":"Error","stack":"Error: Request failed with status code 500\n at e.exports (<https://mint-green-dodo.trial.cloud.gooddata.com/modeler/app.12cba07839926642741b.js:2:2714599>)\n at e.exports (<https://mint-green-dodo.trial.cloud.gooddata.com/modeler/app.12cba07839926642741b.js:2:2717022>)\n at XMLHttpRequest._ (<https://mint-green-dodo.trial.cloud.gooddata.com/modeler/app.12cba07839926642741b.js:2:2709919>)","config":{"url":"/api/v1/actions/dataSources/a8670db6-254d-408b-b290-95bb82293842/scan","method":"post","data":"{\"scanTables\":true,\"scanViews\":false,\"separator\":\"__\",\"tablePrefix\":\"\",\"viewPrefix\":\"\",\"schemata\":[]}","headers":{"Accept":"application/json, text/plain, */*","X-Requested-With":"XMLHttpRequest","X-GDC-JS-PACKAGE":"gdc-msf-modeler","X-GDC-JS-PACKAGE-VERSION":"3d37deea81f6db3f88cc1d63912ae1979f5f2a03","Content-Type":"application/json"},"transformRequest":[null],"transformResponse":[null],"timeout":0,"withCredentials":true,"xsrfCookieName":"XSRF-TOKEN","xsrfHeaderName":"X-XSRF-TOKEN","maxContentLength":-1,"maxBodyLength":-1,"transitional":{"silentJSONParsing":true,"forcedJSONParsing":true,"clarifyTimeoutError":false}}}}

Close

Hello Reda, I was checking the logs and I can see the following:

exc: errorType=com.gooddata.tiger.grpc.error.GrpcPropagatedServerException, message=com.google.cloud.bigquery.BigQueryException: Invalid dataset ID "Juno bigquery". Dataset IDs must be alphanumeric (plus underscores and dashes) and must be at most 1024 characters long.,<no detail>

Can you please amend your Dataset ID so it meets the above requirements and try again?

Hi Julius, thanks for the feedback I just changed the dataset id as the following

I can see now

*exc*: errorType=com.gooddata.tiger.grpc.error.GrpcPropagatedServerException, message=com.google.cloud.bigquery.BigQueryException: Not found: Dataset kameleons-staging:juno-bigquery,<no detail>

can you please also check if the current input corresponds with the actual table in your data-source?

ok got it, it should correspond to big query data set id in my gcp

🙌