I wanted to ask if there's a connector, function, or other that makes it posible to connect to Microsoft SQL Server tables in Apache beam, so as to write to Bigquery.
Thanks!
Yes! Apache Beam supports JdbcIO, so as long as a Dataflow Worker can reach the database and you use the right drivers for it, it should be simpler to achieve.
It is available to Python as apache_beam.io.jdbc and uses the expansion service, so you can get it working as long as you use Dataflow Runner v2.
If you want something even simpler, you may be able to use the JDBC to BigQuery Google-provided template, which is currently in beta/pre-GA.