1. Learn
    2. /
  2. Courses
    3. /
  3. Building Data Engineering Pipelines in Python

Exercise

Working with JSON

Because JSON is ubiquitous, you should be able to read and write this format. As you will see in the next lesson, many configuration files in Singer hold JSON.

In this exercise, you will write some configuration details of a database to a JSON file. Doing this is good practice by the way, as it keeps hardcoded parts out of your code, which allows other people to reference the same configuration files using other languages even.

Do not hesitate to refer to the slides, available in the tab on the right of IPython Shell, if you’re stuck.

Instructions

100 XP
  • Import the Python module we need to deal with JSON.
  • Open a file with the name database_config.json for writing (and only for writing).
  • Serialize the database_address dictionary as JSON and write it to the open file handle. If you’re unsure which arguments the function takes, type ?json.dump to get more information on what obj and fp expect.