Data Factory - Big Query Linked Service does not read from file storage

Question

I am trying to create linked service between Data Factory & BigQuery using service authenticate type.
It requires Key file path and and Trusted cert path which are keep failing - I get unable to open or can't find error.

I tested the access rights by creating another linked service to read the file via storage linked service, which worked. So I know DF has access to the file.

Any ideas how to get this to work?

Thank you

Answer 1

Thank you for your support Himanshu.

So this turned out to be very complicated process for DF.

• Even the related document states that it should the .p12 file - it has to be the json file.
• Regarless of your user access on VM (admin or not)
  -- Required files must be publicly available on the same VM where the integration runtime module is
  and more complications on security and network.

Anyways, I ended using client_id and refresh token which includes manual work but at least I do not have to drop security standards to complete my task

Answer 2

I faced a similar issue while using the Autoresolved integration runtime. However, I managed to resolve it by using a self-hosted integration runtime instead. To do this, I placed the file in the c:\temp folder of the server where the integration runtime was installed and used service authentication, email created from BigQuery and giving the Key File Path: "C:\Temp" Although I would prefer to use the Autoresolved integration runtime and Azure Key Vault, I haven't had any luck with it yet.