{"id":1592,"date":"2020-09-05T23:47:26","date_gmt":"2020-09-05T14:47:26","guid":{"rendered":"https:\/\/oboki.net\/?p=1592"},"modified":"2020-12-18T11:55:43","modified_gmt":"2020-12-18T02:55:43","slug":"airflow-execution_date-%ec%9d%b4%ed%95%b4%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/airflow\/airflow-execution_date-%ec%9d%b4%ed%95%b4%ed%95%98%ea%b8%b0\/","title":{"rendered":"[Airflow] execution_date \uc774\ud574\ud558\uae30"},"content":{"rendered":"<p>Airflow DAG\ub294 Jinja Macro \ub85c \uad6c\ud604\ub3fc \uc788\ub294, \uc0ac\uc804 \uc815\uc758\ub41c \uac12\ub4e4\uc744 \uac00\uc838\ub2e4\uac00 \uc0ac\uc6a9\ud568\uc73c\ub85c\uc368 \uc880 \ub354 \ub2e4\uc774\ub098\ubbf9\ud558\uac8c \uad6c\ud604\ud560 \uc218 \uc788\ub2e4.<\/p>\n<blockquote>\n<p><a href=\"https:\/\/airflow.apache.org\/docs\/apache-airflow\/stable\/macros-ref.html\">Airflow Macros reference<\/a><\/p>\n<\/blockquote>\n<p><img decoding=\"async\" src=\"https:\/\/oboki.net\/workspace\/wp-content\/uploads\/2020\/12\/image-1608216509189.png\" alt=\"file\" \/><\/p>\n<p>\uadf8 \uc911\uc5d0\uc11c\ub3c4 <code>execution_date<\/code> \ub97c \uac00\uc7a5 \uc790\uc8fc \uc0ac\uc6a9\ud558\uac8c \ub418\ub294\ub370 \uc774 \ub9e4\ud06c\ub85c\ub294 DagRun, TaskInstance \uac00 instantiated \ub420 \ub54c \uac12\uc774 \uc815\ud574\uc9c0\uba74\uc11c \ud2b9\uc815 \uc778\uc2a4\ud134\uc2a4\uc5d0 \uc815\ud574\uc9c4 \ub0a0\uc9dc \uac12\uc744 \uac16\uac8c \ud574\uc8fc\uae30 \ub54c\ubb38\uc5d0 \ucd94\ud6c4 \uc7ac\uc791\uc5c5 \ub4f1\uc744 \ud558\ub294\ub370 \uc6a9\uc774\ud558\uac8c \uc4f0\uc778\ub2e4.<\/p>\n<p>\uadf8\ub7f0\ub370 \uc774 <code>execution_date<\/code> \uc5d0 \ub4e4\uc5b4\uac00\ub294 \uac12\uc774 <code>schedule_interval<\/code> \uc5d0 \uc758\ud574 \ud65c\uc131\ud654\ub41c \uc791\uc5c5 \uc2dc\uc810\uacfc \uac12\uc774 \ub2ec\ub77c\uc11c \ucc98\uc74c Airflow\uc5d0 \uc785\ubb38\ud558\uac8c \ub418\uba74 \ubb50\uac00 \ubb54\uc9c0 \uc815\ub9d0 \ud5f7\uac08\ub9ac\ub294\ub370 <a href=\"https:\/\/stackoverflow.com\/questions\/39612488\/airflow-trigger-dag-execution-date-is-the-next-day-why#answer-39620901\">\uc2a4\ud0dd\uc624\ubc84\ud50c\ub85c\uc6b0 \ub9c1\ud06c<\/a> \uc5d0 \uc124\uba85\uc774 \uc798 \ub3fc \uc788\ub2e4. <\/p>\n<p>\ud55c\uc904\ub85c \uc815\ub9ac\ud558\uc790\uba74,<\/p>\n<blockquote>\n<p>\ucc98\ub9ac\ud560 \ub370\uc774\ud130 \ubc94\uc704\uac00 \ubaa8\ub450 \uc720\ud6a8\ud574\uc9c0\ub294 \ub54c\uac00 \uc791\uc5c5\uc774 \uc2dc\uc791\ub418\ub294 \uc2dc\uc810\uc774\uace0 \ud574\ub2f9 \ub370\uc774\ud130 \ubc94\uc704\uc758 \uac00\uc7a5 \ube60\ub978 \uc2dc\uc810\uc774 execution_date \uac12\uc774\ub2e4.<\/p>\n<\/blockquote>\n<p>\uc791\uc5c5 \uc2dc\uc810\uc740 cron \ud45c\ud604\uc2dd\uc73c\ub85c \ub9cc\ub4e4\uc5b4\uc9c0\ub294\ub370 \uadf8 \uc791\uc5c5\uc758 \uc774\ub984\uc740 \ub370\uc774\ud130\ub97c \uae30\uc900\uc73c\ub85c \ud574\ub2f9 \ub370\uc774\ud130\uc758 \uac00\uc7a5 \ube60\ub978 \uc2dc\uc810\uc744 \uac16\uace0 \uac00\uae30 \ub54c\ubb38\uc5d0 \ud5f7\uac08\ub9ac\uac8c \ub418\ub294\uac70\uac19\ub2e4.<\/p>\n<p><a href=\"https:\/\/cwiki.apache.org\/confluence\/pages\/viewpage.action?pageId=62694614\">Airflow Common Pitfalls<\/a> \ubb38\uc11c\uc5d0 \ubcf4\uba74 Airflow\ub294 \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \ucc98\ub9ac \ubcf4\ub2e4\ub294 ETL, \ubc30\uce58 \ucc98\ub9ac \uc791\uc5c5\uc5d0 \uc801\ud569\ud55c \uc2a4\ucf00\uc904\ub7ec\ub85c \uc124\uacc4\ub418\uc5c8\uae30 \ub54c\ubb38\uc774\ub77c\uace0 \ud558\ub294\ub370 \uc774\ub7f0 \uc2a4\ucf00\uc904\ub7ec\ub294 \ubcf4\ud1b5 \uc2a4\ub0c5\uc0f7\uc774\ub098 \ub85c\uadf8 \ub370\uc774\ud130\ub97c \ub9ce\uc774 \ub2e4\ub8e8\uae30 \ub54c\ubb38\uc778 \uac83 \uac19\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>\uadf8\ub798\uc11c \ub85c\uadf8 \ub370\uc774\ud130\ub97c \uc608\ub97c \ub4e4\uc5b4 \ubcf4\uc790\uba74,<\/p>\n<p>2020\/04\/16 \uc77c\uc790 \ub85c\uadf8\ub97c \ucc98\ub9ac\ud558\ub294 \uc791\uc5c5\uc774 \uc788\ub2e4\uace0 \ud588\uc744\ub54c, <code>2020\/04\/16 00:00:00<\/code> \uc2dc\uc810\ubd80\ud130 <code>2020\/04\/16 23:59:59<\/code> \uc2dc\uc810\uae4c\uc9c0\uc758 \ub370\uc774\ud130\ub97c \ub300\uc0c1\uc73c\ub85c \ud558\uace0 \uc774 \ub370\uc774\ud130\ub294 <code>2020\/04\/17 00:00:00<\/code> \uc2dc\uc810\uc5d0 \ube44\ub85c\uc18c \ubaa8\ub4e0 \ub370\uc774\ud130\uac00 \uc900\ube44\uac00 \ub41c\ub2e4. \uadf8\ub798\uc11c \uc791\uc5c5\uc774 \uc2e4\ud589\ub418\ub294, \ub370\uc774\ud130 \ucc98\ub9ac\uac00 \uac00\ub2a5\ud55c \uc2dc\uc810\uc778 <code>2020\/04\/17 00:00:00<\/code> \uc2dc\uc810\uc740 schedule_interval \uc5d0\uc11c \ub9cc\ub4e4\uc5b4\uc9c0\uace0 \uc2e4\uc81c \ucc98\ub9ac \uc791\uc5c5\uc758 \uc774\ub984\uacfc execution_date \uac12\uc740 \ub370\uc774\ud130\ub97c \uae30\uc900\uc73c\ub85c <code>2020\/04\/16 00:00:00<\/code> \uac12\uc744 \uac16\uac8c \ub41c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>\uc8fc \ub2e8\uc704, \uc6d4 \ub2e8\uc704 \uc791\uc5c5\uc744 \ubcf4\uba74 \ud655\uc2e4\ud788 \uc774\ud574\ub97c \ud560 \uc218 \uc788\ub294\ub370<\/p>\n<p>\uba3c\uc800 \uc8fc\ub2e8\uc704 \uc791\uc5c5\uc73c\ub85c \ub9e4\uc8fc \uc6d4\uc694\uc77c \uc624\uc804 9:00 \uc2dc\uc5d0 \uc2e4\ud589\ub418\ub294 \uc791\uc5c5\uc744 cron expression\uc73c\ub85c <code>0 9 * * 1<\/code> \uc640 \uac19\uc774 \uc815\uc758 \ud588\ub2e4\uba74 \ud574\ub2f9 \uc791\uc5c5\uc740 <code>2020\/09\/07 09:00:00<\/code>, <code>2020\/09\/14 09:00:00<\/code>, <code>2020\/09\/21 09:00:00<\/code> \uc2dc\uc810\uc5d0 \uac01\uac01 \uc2e4\ud589\ub420 \uac83\uc774\ub2e4.<\/p>\n<p>\ud574\ub2f9 \uc2dc\uc810\uc5d0 \uc2dc\uc791\ub41c \uc791\uc5c5\ub4e4\uc740 \uadf8 \uc804 \uc8fc\uc758 \ub370\uc774\ud130\ub4e4\uc744 \ucc98\ub9ac\ud558\uac8c \ub420 \uac83\uc778\ub370 \uc791\uc5c5 \uc2dc\uc791 \uc2dc\uc810\ubcc4 execution_date, ds \uac12\uc744 \uc815\ub9ac\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n<table>\n<thead>\n<tr>\n<th>\uc791\uc5c5 \uc2dc\uc791 \uc2dc\uc810<\/th>\n<th>\ub370\uc774\ud130 \ucc98\ub9ac \ubc94\uc704<\/th>\n<th>execution_date<\/th>\n<th>ds<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>2020\/09\/07 09:00:00<\/td>\n<td>2020\/08\/31 09:00:00 ~ 2020\/09\/07 08:59:59<\/td>\n<td>2020\/08\/31 09:00:00<\/td>\n<td>2020-08-31<\/td>\n<\/tr>\n<tr>\n<td>2020\/09\/14 09:00:00<\/td>\n<td>2020\/09\/07 09:00:00 ~ 2020\/09\/14 08:59:59<\/td>\n<td>2020\/09\/07 09:00:00<\/td>\n<td>2020-09-07<\/td>\n<\/tr>\n<tr>\n<td>2020\/09\/21 09:00:00<\/td>\n<td>2020\/09\/14 09:00:00 ~ 2020\/09\/21 08:59:59<\/td>\n<td>2020\/09\/14 09:00:00<\/td>\n<td>2020-09-14<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>\uc6d4\ub2e8\uc704 \uc791\uc5c5\uc73c\ub85c \ub9e4\uc6d4 2\uc77c \uc624\uc804 8\uc2dc 10\ubd84\uc5d0 \uc2e4\ud589\ub418\ub294 \uc791\uc5c5\uc744 <code>10 8 2 * *<\/code> \uc640 \uac19\uc774 \uc124\uc815\ud588\ub2e4\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \ub9e4\ud06c\ub85c \uac12\uc774 \uc124\uc815\ub41c\ub2e4.<\/p>\n<table>\n<thead>\n<tr>\n<th>\uc791\uc5c5 \uc2dc\uc791 \uc2dc\uc810<\/th>\n<th>\ub370\uc774\ud130 \ucc98\ub9ac \ubc94\uc704<\/th>\n<th>execution_date<\/th>\n<th>ds<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>2020\/08\/02 08:10:00<\/td>\n<td>2020\/07\/02 08:10:00 ~ 2020\/08\/02 08:09:59<\/td>\n<td>2020\/07\/02 08:10:00<\/td>\n<td>2020-08-02<\/td>\n<\/tr>\n<tr>\n<td>2020\/09\/02 08:10:00<\/td>\n<td>2020\/08\/02 08:10:00 ~ 2020\/09\/02 08:09:59<\/td>\n<td>2020\/08\/02 08:10:00<\/td>\n<td>2020-08-02<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Airflow DAG\ub294 Jinja Macro \ub85c \uad6c\ud604\ub3fc \uc788\ub294, \uc0ac\uc804 \uc815\uc758\ub41c \uac12\ub4e4\uc744 \uac00\uc838\ub2e4\uac00 \uc0ac\uc6a9\ud568\uc73c\ub85c\uc368 \uc880 \ub354 \ub2e4\uc774\ub098\ubbf9\ud558\uac8c \uad6c\ud604\ud560 \uc218 \uc788\ub2e4. Airflow Macros reference \uadf8 \uc911\uc5d0\uc11c\ub3c4 execution_date \ub97c \uac00\uc7a5 \uc790\uc8fc \uc0ac\uc6a9\ud558\uac8c \ub418\ub294\ub370 \uc774 \ub9e4\ud06c\ub85c\ub294 DagRun, TaskInstance \uac00 instantiated \ub420 \ub54c \uac12\uc774 \uc815\ud574\uc9c0\uba74\uc11c \ud2b9\uc815 \uc778\uc2a4\ud134\uc2a4\uc5d0 \uc815\ud574\uc9c4 \ub0a0\uc9dc \uac12\uc744 \uac16\uac8c \ud574\uc8fc\uae30 \ub54c\ubb38\uc5d0 \ucd94\ud6c4 \uc7ac\uc791\uc5c5 \ub4f1\uc744 \ud558\ub294\ub370 \uc6a9\uc774\ud558\uac8c \uc4f0\uc778\ub2e4. \uadf8\ub7f0\ub370 \uc774 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[199],"tags":[],"class_list":["post-1592","post","type-post","status-publish","format-standard","hentry","category-airflow"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1592","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/comments?post=1592"}],"version-history":[{"count":1,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1592\/revisions"}],"predecessor-version":[{"id":1594,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1592\/revisions\/1594"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=1592"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=1592"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=1592"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}