Tag: postgresql
-
How to create DBT Models
In this post we will explain how to create DBT models, we will continue the hospital example and we will transform the data from bronze schema and load to silver schema, first we will analyze the data, make some queries filter and transform the raw data from Bronze schema. After filter the silver schema, we…
-
How to use dbt seed
In this post we describe how to used dbt seed, is a command that load csv files to the database, this function was created for load small files, for example : Example of DBT seed In our case, for only a example we use dbt seed to load the data from csv files. The files…
-
How to setup dbt core ?
Here we will explain how to setup DBT core in Dev container, in the other post https://juliovaldiviamarin.com/dev-container-dbt-postgresql-metabase-part-1/ we see how to install DBT in vs code deb container, now inside in the dev container we will setup dbt core like: dbt project name, profile database(hostname, port, username, password,dbname, schema, threads) dbt init dbt init is…
-
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.…