Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Google cloud dataflow - CloudSQL(Postgres) to BigQuery using template - PoolableConnectionFactory (T

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

 

0 2 1,078
2 REPLIES 2

Andre_Fiesco
Former Googler

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 ?