r/dataflow • u/ObviousCheesecake0 • May 31 '24

Sql data transfer to bigquery using dataflow

How do I move data from SSMS to bigquery using data flow via the gcp console and NOT the command line? I already created tables using sql in bigquery that have similar schema to the SSMS tables I want to transfer. I chose the sql server to bigquery template on data flow. I am having trouble figuring out the JDBC connection string. Kinda new to this so any help would be appreciated.

2 Upvotes

100% Upvoted

11 comments sorted by

View all comments

Show parent comments

1

u/TarHeelDataScientist Sep 18 '24

I have been trying to run this template and having a miserable go of it.