I can't seem to connect the PostgreSQL source to BigQuery using Data Transfer Service and/or Data Stream
I already have the connection details as I have linked it directly to Looker Studio. However, it would be great if we also have it in BigQuery as possibilities are limitless. As mentioned, I already have the credentials (Username, Password, Host, Database name, Port) and the certificates and key (in .pem files). I only have the said credentials and files as the PosgreSQL source is managed by our affiliate.
Attempt 1. via Data Transfer Service
- I have tried filling out the information and the credentials but there is no way to upload the certificates. Which is why (I think) there's an error when trying to proceed or connect.
Attempt 2. via Data Stream
- I also tried creating a stream via Data Stream. Again, filled out the necessary information. We also created a connection profile where the credentials are needed but there's no option to upload the certificates?
I'm quite new to GCP and I also can't find a helpful step-by-step or how to on this topic. Please help.
LinkedIn
Twitter
