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!
Questo esercizio fa parte del corso
ETL and ELT in Python
Istruzioni dell'esercizio
- Update the connection URI to create a connection engine for the
salesdatabase, usingsqlalchemy. - Query all rows and columns of the
salestable and output the results.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
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)