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!

Latihan ini adalah bagian dari kursus

ETL and ELT in Python

Lihat Kursus

Petunjuk latihan

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.

Latihan interaktif praktis

Cobalah latihan ini dengan menyelesaikan kode contoh berikut.

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)

Edit dan Jalankan Kode