Twitter Instagram YouTube RSS
Close

Tag: bigquery

sql server to bigquery
sql server to bigquery

Data Engineering / Google Cloud

How To Transfer Data From SQL Server to BigQuery on GCP

skwritesLeave a comment

Here, I am going to explain how to transfer data from SQL server to BigQuery in the arguably most robust way using JDBC connection. You don’t need to care about any delimiter or newline character stuff. You will need just below mapping of data type from SQL server to Bigquery to create the schema in your BQ dataset, accordingly

bigquery

Data Engineering / Google Cloud / Programming

How To Cancel a BigQuery Data Transfer Run

skwritesLeave a comment

So, you want to cancel a BigQuery Data Transfer scheduled run (because you might have accidently created it 😉 and you cannot see any option to delete a particular entry. If you click DELETE at the top right, it will delete the whole configuration for that Data Transfer. Unfortunately, it seems there is no easy…