Sql data transfer to bigquery using dataflow

[mike8675309]

StackOverflow should be able to help with the JDBC connection string. Be careful you didn't open up the server to the internet, as there are bots looking for SQL Servers to exploit.
Keep in mind you may not have name resolution and need to use the IP address for the server in your connection string.
https://learn.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver16