Skip to main content

Recently active topics

1 Topic
mate.csigi
mate.csigiCommunity Manager
published in Guides
Continuous availability of database objects during rebuild

In many use cases, maintaining high availability for database objects is crucial. This is particularly important when models created in one project are referenced as sources in other projects. Or if there are other applications trying to access database objects while they are getting rebuilt in a pipeline.However, when a pipeline runs, there is often a gap between table recreation and applying the grants. During this interim period, any applications attempting to access the tables might encounter an error such as:Object <DB.SCHEMA.TABLE> does not exist or not authorized. To overcome this issue, you can set the copy_grants config on your MATE project. This setting applies the "copy grants" DDL qualifier whenever tables and views are rebuilt.An example project dbt_project.yml file:name: my_projectmodels:  +copy_grants: true  my_project:    ...This feature ensures that permissions are seamlessly transferred from the old to the new table, eliminating temporary downtime and preserving

100
mate.csigi
6 days ago

Badge winners

Show all badges
Terms & ConditionsCookie settings