Skip to content

Instantly share code, notes, and snippets.

@pavgup
Created July 18, 2017 19:59
Show Gist options
  • Select an option

  • Save pavgup/374ab21dbde70b05997ebcac570e0dd5 to your computer and use it in GitHub Desktop.

Select an option

Save pavgup/374ab21dbde70b05997ebcac570e0dd5 to your computer and use it in GitHub Desktop.
getting rid of airflow dags, eek
Deleting DAGs in Airflow? Well, womp.
set @dag_id = 'etl_dag';
delete from airflow.xcom where dag_id = @dag_id;
delete from airflow.task_instance where dag_id = @dag_id;
delete from airflow.sla_miss where dag_id = @dag_id;
delete from airflow.log where dag_id = @dag_id;
delete from airflow.job where dag_id = @dag_id;
delete from airflow.dag_run where dag_id = @dag_id;
delete from airflow.dag where dag_id = @dag_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment