Google PubSub for DLT - Error

itamarwe
New Contributor II

I'm trying to create a delta live table from a Google PubSub stream.

Unfortunately I'm getting the following error:

org.apache.spark.sql.streaming.StreamingQueryException: [PS_FETCH_RETRY_EXCEPTION] Task in pubsub fetch stage cannot be retried. Partition 0.3 in stage 3.0, TID 14. SQLSTATE: 22000

My code is below. What could explain this error and how can it be solved?

authOptions = {

"clientId" : "XXX",

"clientEmail" : "XXX",

"privateKey" : "-----BEGIN PRIVATE KEY-----\nXXX-----END PRIVATE KEY-----\n",

"privateKeyId" : "XXX"

}

stream=spark.readStream \

.format("pubsub") \

.option("subscriptionId","XXX") \

.option("topicId","XXX") \

.option("projectId","XXX") \

.options(**authOptions) \

.load()

itamarwe
New Contributor II

Hi @Retired_mod, it was indeed a permissions issue. Nevertheless, I must admit that the error message is slightly misleading.
Thanks.

KriZ
New Contributor II

Hi @itamarwe, what was the missing permissions ? 

Thanks.

sahilsagar302
New Contributor II

@itamarwe can you please share which permission resulted into the issue and how it got resolved