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 …
Get Observepoint API Data with Python
Here we make a call to the Observepoint API and inspect the results before loading into the PostgreSQL database. It is also translated into JSON. The python code to grab …
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 …
Create Database in PostgreSQL
Starting with the simple data model we will create the necessary database and users in the postgreSQL database. The PGAdmin client (https://www.pgadmin.org/) is a nice GUI for the database that …
Simple Data Model
Today we are working with Version2 of Observepoint’s API. The database tables will be created from this model. Here’s the data model created for this project. Observepoint is an Automated …
Install PostgreSQL Database – Windows
Installing PostgreSQL DB on Windows 10 Download: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads Install: Skipped installing additional components with stackbuilder: All posts in this ETL series: Install PostgreSQL Database Simple Data Model Create Tables in …