Technology
Database Host: Snowflake
Integrator Tool: Pentaho Data Intration
Dashboard Tool: Microsoft Power BI
Guide of files:
main_job.kjb - Pentaho main JOB, that orquestrate all flow.
snowflake_corona.ktr - Pentaho Transformation that download the JSON hosted in https://pomber.github.io/covid19/timeseries.json and generate a file in my local directory.
snowflake.sh - Shell script that connects in Snowflake via snowsql and do the PUT command to load the .JSON file into a internal stage called @DW_SPOT_STAGE.