BigQuery Dataset Creation via API

Question & Answer
, , , ,
1

Hi,

I’m trying to create a BigQuery Dataset via the API, but am failing on an error:

'botocore.errorfactory.InvalidParameterValueException: An error occurred (InvalidParameterValueException) when calling the CreateDataSet operation: Found non-relational dataSourceArn arn:aws:quicksight:********** in relationalTable’

I’m wondering whether this is the same bug or missing feature as referenced in BigQueryのデータセットをimportするとエラーになる ?

2

Hello @NilsCarlson !

From our teams experience doing something similar this is most likely a bug. I would recommend creating a support ticket with AWS.

That being said, a potential workaround is pulling the data into Athena with Amazon AppFlow but this can be complicated.