Dear Team i am getting the error while loading the data from CloudSQL(Postgres) to BigQuery using template. any help appreciated.
"Error message from worker: java.lang.RuntimeException: org.apache.beam.sdk.util.UserCodeException: java.sql.SQLException: Cannot create PoolableConnectionFactory (The connection attempt failed.)"
The below are the property values used and the same jar file uploaded in GS bucket.
Driver Class Name: org.postgresql.Driver
driverJars: gs://eu.artifacts.xxx.appspot.com/JDBCDrivers/postgres-socket-factory-1.6.3-jar-with-dependencies.jar,gs://eu.artifacts.xxx.appspot.com/JDBCDrivers/postgres-socket-factory-1.6.3-jar-with-driver-and-dependencies.jar
What are you trying to perform? And could you provide the template you are trying to use?
Can you let me know the Jars required to fetch data from cloud Postgres to Bigquery using standard dataflow JDBC template ?