I want to transform some tables in my Postgres database. My requirement is to select all columns and unpack the nested jsonb columns into separate columns.
I’m able to do the same by creating multiple models (incremental) for different tables by manually writing SQL queries.
I want to automate the above process so that I don’t need to write the sql queries and dbt is able to do that itself for all the different tables.