Democratizing data through APIs may not exactly be part of a data analyst or scientist job. However, knowing how APIs work generally helps you to understand the data collection process.

For aspiring data engineers, knowing how to serve data through APIs is a must.

Perhaps you created new metrics for a data and you want to share them in your company.

This is where we create a REST API to serve data to meet our stakeholders’ needs.

Depending on the company you work for, you might be required to serve data to others, and that’s why we are building an API to serve data to clients.

Flask is popular since it is Python-based, but it is not a de facto standard to serve APIs. Companies could use:

  • Django
  • Typescript/Nodejs using Expressjs
  • PHP frameworks
  • AWS Lambda/Gateway

What you’re learning is the concepts and how you can be flexible with the different environments that you might be in.

Joins

Let’s open up the file(s) in the 01-Ins_Joins folder to get started.

Dates

Let’s open up the file(s) in the 02-Ins_Dates folder to get started.

Students Do: Dow Dates

Introduction to Flask

Let’s open up the file in the 04-Ins_First_Steps_with_Flask folder to get started.

You will be running a local server on your machine.

Students Do: Hello, Web

JSON APIs with jsonify

Let’s open up the file(s) in the 06-Ins_Jsonify folder to get started.

Students Do: Justice League

Routes with Variable Paths

Let’s open up the file(s) in the 08-Ins_Variable_Rule folder to get started.

Students Do: Routes with Variable Rules

Flask with ORM

Let’s open up the file(s) in the 10-Ins_Flask_with_ORM folder to get started.

Student Do: Chinook Database Analysis