Hello everybody! I start to learn about dbt in Mel...
# plugins-dbt
p
Hello everybody! I start to learn about dbt in Meltano, so I have a little question, is possible to use dbt to make an update? My idea is if I can use some tap to extract the data, use the dbt plugin to create a model that change the data (like SQL Update sentence) and lastly use a target to load the data. The most examples are with select sentences, and in the docs I read about incremental strategies that is a possibility to make an update, but doesn't found a clearly example of how use it
r
What you basically described here is an Extract-Transform-Load (ETL), whereas dbt is used in an Extract-Load-Transform (ELT) setup - it applies transformations on data after it has been extracted from a source and loaded into a data warehouse. https://meltano.com/blog/elt-101-the-why-and-what-of-elt-or-the-why-not-of-etl https://docs.getdbt.com/terms/elt If you want to transform data before it is loaded, check out Meltano SDK stream maps and mapper plugins.
👌 2
🙌 1
💪 1
p
thanks a lot, I appreciate that
np 1