Query Redshift Table with SQL in Python | AWS SDK for Pandas
This is a hands-on tutorial which walks through the step-by-step process on how to query data in a redshift database using a SQL statement. In this video, I'm going to first cover how we can connect to our redshift cluster in python, use sql to pull values from a single table, use a where statement to limit how much data we are querying,
use python variables in our sql statements, and how to query multiple redshift tables with a join and return the results.
Github Repo: https://github.com/AdrianoNicolucci/d...
Add Redshift Data Source In AWS Glue Catalog: • Add Redshift Data Source In AWS Glue ...
Buy me a coffee: https://www.buymeacoffee.com/dataengu
timeline:
00:00 Overview
00:37 Prerequisites
01:02 Connect to redshift cluster in python
02:55 Query single table
03:54 Query table with where statement
04:28 Query table with python variables
06:01 Query multiple tables with inner join
#aws #dataengineering #awswrangler