Querying a SQL database with Python using SQLAlchemy and pandas.
In this SQLAlchemy tutorial, I walk through a basic Python script that queries BigQuery, stores the results as a pandas DataFrame, does some basic aggregation and plots the data.
You'll need:
Credentials to a remote SQL database or data warehouse
Basic SQL knowledge
Command line/terminal basic knowledge (pip install sqlalchemy, pip install pandas, setting environment variables...)
Basic Python knowledge
Detailed notes and sample code available here: www.fabi.ai/blog/how-to-connect-to-a-remote-sql-server-to-analyze-data-in-python-using-sqlalchemy-and-python-step-by-step-guide
