Homework - ingest Police API crime categories

Goal

Create your own scripts to read crime categories from the Police API and write the result to the raw zone.

Use this API endpoint:

https://data.police.uk/api/crime-categories?date=2024-01

Write the raw JSON response to:

s3://dataplatform-stg-raw-zone/data-and-insight/testing/demo/police_api_crime_categories/crime-categories-2024-01.json

Then create a partitioned parquet Glue table in:

"data-and-insight-raw-zone"."test_your_name_demo_police_crime_categories"

Partition the table by:

["import_year", "import_month", "import_day", "import_date"]

Use your own name in the table name. Do not use tian unless your name is Tian.

API documentation:

• Police API documentation
• Crime categories method