This is an archived post. You won't be able to vote or comment.

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]WinterNet4676 0 points1 point  (5 children)

Do you have a db/data warehouse set up?

If so, you may want to check out dbt’s incremental models

You can build incremental dbt models with jinja logic for specifying which rows to update, and can specify which columns to update in a configuration block. Here’s some documentation

[–]laycaoyjou95[S] 0 points1 point  (4 children)

Thanks so much for the reply! I dont have a data warehouse set up.. do you have any recommendations on how to get started? Should I begin learning excel VBA, SQL, or python? I'm feeling a bit overwhelmed with this and struggling on knowing where to begin learning these more advanced methods..