Error Message: 'Cannot find the requested object' when using Service Account Authentication in Google BigQuery Connection.

Error Message: 'Cannot find the requested object' when using Service Account Authentication in Google BigQuery Connection.


Action:

When using Service Account authentication in Google BigQuery connection Manager the following error is received.

Error Message:
Validating connectivity via endpoint '' failed. Details:
Cannot find the requested object. (CozyRoc.SSISPlus.2019)

Additional information:
Cannot find the requested object. (mscorlib)
Solution:
If you want to use "Service Account" authentication, you have to provide the key file in pfx (p12) format. You can refer to the following KB article to export the key file to .pfx.

How to export key pair and certificate to .pfx file.



    Book a Presales Call


    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now and get 5% off SSIS+.