Practice pulling data from database

With the powers of csvkit, we don't need to download and set up fancy database management software like MS SQL Server, DB2, PgAdmin, or TablePlus to be able to access the data inside a SQL database. We can pull data directly from our command line using csvkit's sql2csv command.

In this practice, let's walk through pulling data step by step, by applying SQL manipulations to the table Spotify_Popularity which dwells inside a SQLite database called SpotifyDatabase and then saving the output of the SQL query to a local .csv file Spotify_Popularity_5Rows.csv.

Deze oefening maakt deel uit van de cursus

Data Processing in Shell

Cursus bekijken

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

# Verify database name 
ls

# Pull the entire Spotify_Popularity table and print in log
sql2csv --___ "___" \
        --query "SELECT * FROM Spotify_Popularity"

Code bewerken en uitvoeren