On premises SQL Server to Big Query

[DataDaddy]

HI,

I am new to Stitch. I have a requirement to extract data from a on premises SQL server db and load into BigQuery. Could you please let me know if this can be achieved using Stitch? It looks like it should be possible. If it is, would you mind sharing any links to documentation that you may have?

Thanks

Dann

[Anonymous]

Hi @Dann Westcott​ ,

Yes, you can do this. Here are some links that might help.....

https://www.stitchdata.com/docs/integrations/databases/microsoft-sql-server

https://www.stitchdata.com/docs/destinations/google-bigquery/v2

Have you seen these?

Regards

Richard

[CDestiney1627965782]

Hello guys, what want work on a project to solidify my data migration skill.

How can I best move on-Prem sql server data to bigquery?

Here are the additional things to consider,

1. I am not moving the whole table columns i.e I want to filter out specific columns
2. If there is a change in the on-prem, the pipeline should be notified or adjust to the changes (can I use airflow here?)
3. I don't want to use third party platforms (I am just learning, I can't afford additional charges)

Please I will like any contributions

lowes employee portal