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
Let’s open up the file in the 03-Stu_Dow_Dates
folder to get started.
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
Let’s open up the file(s) in the 05-Stu_Hello_Web
folder to get started.
JSON APIs with jsonify
Let’s open up the file(s) in the 06-Ins_Jsonify
folder to get started.
Students Do: Justice League
Let’s open up the file(s) in the 07-Stu_Justice_League_jsonify
folder to get started.
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
Let’s open up the file(s) in the 09-Stu_Variable_Rule
folder to get started.
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
Let’s open up the file(s) in the 11-Stu_Chinook_Database_Analysis
folder to get started.