I have a dbt project configured with project-level and model-level grants. I’m curious if there is a way to run dbt while only applying grants to the target models and not rerunning the models themselves?
I’m imagining a scenario where we have a number of large models that receives updated data on a weekly basis, but a need arises where the GRANTS need to be updated on the models before the ‘next weekly run’. I’d like to save time and money and avoid rerunning the models, but I also only want to make the GRANT changes in one location without having to manually create/maintain GRANT scripts.
Does anyone know if this is possible?
Thank you