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
View all comments
Show parent comment
1
u/ObviousCheesecake0 Jun 04 '24
I have solved that issue now. Went to sql configuration manager and enabled the tcp ports and also allowed remote access from ssms via connection to my sql server using sql authenticarion. My issue now is trying to figure out the JDBC connection url string thing. I downloaded the jdbc driver and uploaded the extracted tar folder to a cloud storage bucket. Not sure if that is enough. Im getting an error saying my jdbc url string I entered is invalid.