1

I am building a Cloud Data Fusion pipeline where I will be connecting to Database to pull the data. The requirement is to keep the Database user id and password in GCP Secret manager. How do I read these details as part of macro? If it is not possible what is the work around? enter image description here

Thelight
  • 359
  • 1
  • 5
  • 15

2 Answers2

4

You may want to look into using the Secure Macro. Cloud Data Fusion unfortunately does not have integration with GCP Secret Manager; instead, it uses Cloud KMS to store secrets.

Creating, retrieving, and storing secure keys can be done via the REST API as described in the Secure Storage API docs.

Dennis Li
  • 121
  • 2
0

Check this out. once you created the key in the Admin Console, get the key name and use it inside the macro with this format. ${secure(key name)} https://jtaras.medium.com/google-data-fusion-securing-your-access-keys-and-passwords-267c85f9fb1

user3397375
  • 1
  • 2