Skip to main content

on-run-start & on-run-end

dbt_project.yml
on-run-start: sql-statement | [sql-statement]on-run-end: sql-statement | [sql-statement]

Definition#

A SQL statement (or list of SQL statements) to be run at the start, or end, of the following commands:

  • dbt run
  • dbt seed
  • dbt snapshot

on-run-start and on-run-end hooks can also call macros that return SQL statements

Usage notes#

  • The on-run-end hook has additional jinja variables available in the context — check out the docs.

Examples#

Grant privileges at the end of a run#

dbt_project.yml
on-run-end: "grant select on all tables in schema {{ target.schema }} group transformer"

Grant multiple privileges at the end of a run#

dbt_project.yml
on-run-end:  - "grant usage on schema {{ target.schema }} to group reporter"  - "grant select on all tables in schema {{ target.schema }} group reporter"

Grant privileges on all schemas that dbt uses at the end of a run#

This leverages the schemas variable that is only available in an on-run-end hook.

dbt_project.yml
on-run-end:  - "{% for schema in schemas %}grant usage on schema {{ schema }} to group reporter; {% endfor %}"

Call a macro to grant privileges#

dbt_project.yml
on-run-end: "{{ grant_select(schemas) }}"

Additional examples#

We've compiled some more in-depth examples here.