I have created a Data Fusion instance and a PostgreSQL database in Google Cloud. When I make the connection from Data Fusion to the database in order to make a pipeline I get the following error:
Failed to create connection to database via connection string: jdbc:postgresql://IP/postgres and arguments: {user=USER}. Error: SocketTimeoutException: connect timed out. Make sure you specify the correct connection properties.
I have tried to modify permissions in IAM but I am not able to solve the problem. In case it was a PostgreSQL problem, I also tried to do it with SQL and I get the same problem.
Could someone please help me?
Solved! Go to Solution.
Hi @andres_artm ,
Please repost this to the data analytics topic with the Label for Cloud Data Fusion to ensure you get to the right set of product experts for Cloud Data Fusion:
https://www.googlecloudcommunity.com/gc/forums/filteredbylabelpage/board-id/cloud-data-analytics/lab...
I know there is a Cloud SQL proxy which may be required for connectivity? But I'll let the Data Fusion experts guide you to the right answer.
Hi @andres_artm ,
Please repost this to the data analytics topic with the Label for Cloud Data Fusion to ensure you get to the right set of product experts for Cloud Data Fusion:
https://www.googlecloudcommunity.com/gc/forums/filteredbylabelpage/board-id/cloud-data-analytics/lab...
I know there is a Cloud SQL proxy which may be required for connectivity? But I'll let the Data Fusion experts guide you to the right answer.