Spark to Bigquery connectivity through scala code

[Hari0123y]

Df = spark.read.format(“bigquery”).option(“parentProject”, project id).option(“viewsEnabled”, “true”).option(“materializationDataset”, datasetid).option(“query”, sqlquery).load()

while running this one through scala code getting this following error

Error creating destination table using the following query: [sqlquery]

[davidrabinowitz]

Please share the full stack trace and error

[Hari0123y]

Issue is resolved now @davidrabinowitz , Service account doesn’t have bigquery job user access in project in the IAM . So it was failing with above error