How to connect to Google cloud Storage via ADF using Service Account key

Priya Jha 896 Reputation points
2021-12-16T15:15:23.383+00:00

Hi All,

I am creating a Linked Service to connect to Google Cloud Storage and i am using following JSON file for Service account that has access on the Google Cloud Storage

158238-json.png

I am using private_key_id as Access Key ID and private_key value as Secret Access Key and Service URL as https://storage.googleapis.com:

158274-linkedservice.png

Linked Service is failing with following error:

158301-errormessage.png

How to create a Linked Service using this JSON file to connect to Google Cloud Storage?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,640 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA 90,651 Reputation points Moderator
    2021-12-17T08:56:03.103+00:00

    Hello @Priya Jha ,

    Thanks for the question and using MS Q&A platform.

    As per the error message - it's clearly says credentials is incorrect or do not have the permission to access.

    Make sure you have met the prerequisites and required permissions on the Google Cloud Storage account as mentioned in this document: Copy data from Google Cloud Storage using Azure Data Factory or Synapse Analytics.

    And also, you can checkout this video on Copy data from GCP into Azure.

    Hope this will helps. Please let us know if any further queries.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.