In this video, we will look at how to
Create a Service Account in BQ: https://docs.aws.amazon.com/dms/latest/sbs/bigquery-redshift-migration-step-1.html
Code used in the tutorial: https://github.com/Aurelius2500/Connecting-to-databases-with-SQLAlchemy/tree/main
Chapters:
0:00 Introduction
1:00 A quick glimpse at the Big Query console
6:00 An introduction to SQL Alchemy
9:22 Running SQL Queries in Python
11:30 Always close your connections
