Insert JSON data into PostgreSQL DB using Python
Now that the table has been created and we have inspected the JSON data returned by the Observepoint API we are finally ready to load the data. First up are …
Create tables in PostgreSQL
According to our data model we will need five tables for our ETL project. Let’s line up the table field names with their data types. Some of the JSON returned …