Dev blog

Category: Dev

  • Gold layer

    Gold layer

    Now we finally are in the final stage of our ELT process, in this layer we will see the fables that our dashboards will consume, this layer have tables group fields, dimension tables fact tables. We consume the data from the silver layer that is clean, we have one dashboard and one tab for each…

  • Silver model part II

    Silver model part II

    We was analyzing our tables in bronze layer to clean in silver layer, we saw that we have some problem with the tables staff and staff_schedule because we have different id_staff from staff schedule and staff table, also we have people that exits in staff_schedule and didn’t exist in staff  table, in other hand the…

  • Dev Container + DBT + Postgresql + Metabase Part 1

    Dev Container + DBT + Postgresql + Metabase Part 1

    I gonna to explain in many post how to create a project using DBT-Core to transformm data, postgresql to save the data and Metabase to show the data in dashboards. For this example I gonna to use VS code y Dev container to develop, first i gonna to explain how to setup the Dev Container.…

  • GIT

    GIT

    We gonna to see how to create a branch , add a file, change a file, make a commit, merge the branch and delete the branch all this with Git on github. First we check if we are on Main branch with : then we create a branch called feature_1 with then we change to…

  • Spring + Rest Api + SupaBase + Postman

    I created a project that insert on PostgreSQL table Pato through Api rest of Spring. First i download the project from Spring Initializr i created the java class Pato : Then i created PatoControler after i created a interface to extends CrudRepository I had to add dependencies to pom.xml i had to add the connection…