Pulling data from SQL databases

SQL databases are one of the most used data storage tools in the world. Many companies have teams of several individuals responsible for creating and maintaining these databases, which typically store data crucial for day-to-day operations. These SQL databases are commonly used as source systems for a wide range of data pipelines.

For this exercise, pandas has been imported as pd. Best of luck!

Deze oefening maakt deel uit van de cursus

ETL and ELT in Python

Cursus bekijken

Oefeninstructies

Update the connection URI to create a connection engine for the sales database, using sqlalchemy.
Query all rows and columns of the sales table and output the results.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

import sqlalchemy

# Create a connection to the sales database
db_engine = sqlalchemy.____("postgresql+psycopg2://repl:password@localhost:5432/____")

# Query the sales table
raw_sales_data = pd.____("____", db_engine)
print(raw_sales_data)

Code bewerken en uitvoeren