{"id":5724,"date":"2024-10-25T18:58:15","date_gmt":"2024-10-25T09:58:15","guid":{"rendered":"https:\/\/blog.since2020.jp\/?p=5724"},"modified":"2024-10-25T19:04:21","modified_gmt":"2024-10-25T10:04:21","slug":"dbt-date-power","status":"publish","type":"post","link":"https:\/\/since2020.jp\/media\/dbt-date-power\/","title":{"rendered":"dbt\u3092\u4f7f\u3063\u305f\u6570\u5024\u578b\u30ab\u30e9\u30e0\u306eDATE\u578b\u5909\u63db\u3068\u30c6\u30fc\u30d6\u30eb\u81ea\u52d5\u751f\u6210\u306e\u624b\u9806"},"content":{"rendered":"\n<p>\u30c7\u30fc\u30bf\u30d1\u30a4\u30d7\u30e9\u30a4\u30f3\u3067\u3001\u6570\u5024\u578b\u30ab\u30e9\u30e0\u304b\u3089DATE\u578b\u3078\u5909\u63db\u3057\u3001\u5e38\u306b\u6700\u65b0\u306e\u5909\u63db\u6e08\u307f\u30c7\u30fc\u30bf\u3092\u6301\u3064\u30c6\u30fc\u30d6\u30eb\u3092\u7dad\u6301\u3059\u308b\u30b7\u30b9\u30c6\u30e0\u69cb\u7bc9\u306b\u3064\u3044\u3066\u3001dbt\u3067\u306e\u5b9f\u88c5\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u672c\u8a18\u4e8b\u3067\u306f\u3001dbt\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u3001\u30c7\u30fc\u30bf\u578b\u5909\u63db\u3001\u305d\u3057\u3066\u5909\u63db\u6e08\u307f\u30c7\u30fc\u30bf\u3092\u4fdd\u6301\u3059\u308b\u305f\u3081\u306e\u30c6\u30fc\u30d6\u30eb\u751f\u6210\u307e\u3067\u306e\u6d41\u308c\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n<h2>\u306f\u3058\u3081\u306b<\/h2>\n<p><span style=\"font-family: arial, helvetica, sans-serif\">\u30c7\u30fc\u30bf\u30d1\u30a4\u30d7\u30e9\u30a4\u30f3\u3067\u3001\u6570\u5024\u578b\u30ab\u30e9\u30e0\u304b\u3089<span data-token-index=\"1\" class=\"notion-enable-hover\">DATE<\/span>\u578b\u3078\u5909\u63db\u3057\u3001\u5e38\u306b\u6700\u65b0\u306e\u5909\u63db\u6e08\u307f\u30c7\u30fc\u30bf\u3092\u6301\u3064\u30c6\u30fc\u30d6\u30eb\u3092\u7dad\u6301\u3059\u308b\u30b7\u30b9\u30c6\u30e0\u69cb\u7bc9\u306b\u3064\u3044\u3066\u3001<span data-token-index=\"3\" class=\"notion-enable-hover\">dbt<\/span>\u3067\u306e\u5b9f\u88c5\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u672c\u8a18\u4e8b\u3067\u306f\u3001<span data-token-index=\"5\" class=\"notion-enable-hover\">dbt<\/span>\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u3001\u30c7\u30fc\u30bf\u578b\u5909\u63db\u3001\u305d\u3057\u3066\u5909\u63db\u6e08\u307f\u30c7\u30fc\u30bf\u3092\u4fdd\u6301\u3059\u308b\u305f\u3081\u306e\u30c6\u30fc\u30d6\u30eb\u751f\u6210\u307e\u3067\u306e\u6d41\u308c\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/span><!-- notionvc: 7f482b0f-8025-4951-ad79-be9107e8bbde --><\/p>\n\n<h2>\u524d\u63d0\u8a2d\u5b9a<\/h2>\n<p><span style=\"font-family: arial, helvetica, sans-serif\">\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u69cb\u6210\u3067\u9032\u3081\u307e\u3059\u3002<\/span><\/p>\r\n<ul>\r\n\t<li><span style=\"font-family: arial, helvetica, sans-serif\"><strong>\u5143\u30c7\u30fc\u30bf\u306e\u30b9\u30ad\u30fc\u30de\u3068\u30c6\u30fc\u30d6\u30eb\u540d<\/strong>\uff1a<code>source_data_schema<\/code>\u30b9\u30ad\u30fc\u30de\u306b<code>transaction_info<\/code>\u30c6\u30fc\u30d6\u30eb<\/span><\/li>\r\n\t<li><span style=\"font-family: arial, helvetica, sans-serif\"><strong>\u5909\u63db\u5f8c\u306e\u30d3\u30e5\u30fc\u3068\u30c6\u30fc\u30d6\u30eb<\/strong>\uff1a\u30d3\u30e5\u30fc\u3092\u4f5c\u6210\u3057\u3001\u305d\u308c\u3092\u57fa\u306b\u6c38\u7d9a\u7684\u306a\u30c6\u30fc\u30d6\u30eb\u3092\u751f\u6210<\/span><\/li>\r\n<\/ul>\r\n<p><!-- notionvc: ebf328e1-db71-4aee-a4e1-67e05d7e0030 --><\/p>\n\n<h2>\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u69cb\u9020<\/h2>\n<p><span style=\"font-family: arial, helvetica, sans-serif\"><span data-token-index=\"0\" class=\"notion-enable-hover\">dbt<\/span>\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u5168\u4f53\u306e\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u69cb\u9020\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059<\/span><!-- notionvc: ab126a77-9ad4-45c8-9764-fc035ee1187e --><\/p>\r\n<div class=\"hcb_wrap\">\r\n<pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>my_new_project\/\r\n\u251c\u2500\u2500 dbt_project.yml # \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\r\n\u251c\u2500\u2500 models\/\r\n\u2502 \u251c\u2500\u2500 schema.yml # \u30bd\u30fc\u30b9\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\r\n\u2502 \u251c\u2500\u2500 transaction_info_transformed_view.sql # \u5909\u63db\u7528\u306e\u30d3\u30e5\u30fc\r\n\u2502 \u2514\u2500\u2500 transaction_info_final_table.sql # \u6700\u7d42\u30c6\u30fc\u30d6\u30eb\u751f\u6210\u30e2\u30c7\u30eb\r\n\u2514\u2500\u2500 other folders (seeds, tests, macros) # \u4ed6\u306e\u88dc\u52a9\u30c7\u30a3\u30ec\u30af\u30c8\u30ea<\/code><\/pre>\r\n<\/div>\n\n<h2>1. dbt \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7<\/h2>\n<b><span style=\"font-size: 18pt\"><strong><span style=\"font-family: arial, helvetica, sans-serif\"><code>schema.yml<\/code>\u306e\u8a2d\u5b9a<\/span><\/strong><\/span><\/b>\r\n<p><span style=\"font-family: arial, helvetica, sans-serif\">\u307e\u305a\u3001<code>schema.yml<\/code>\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u3066\u3001Snowflake\u5185\u306e\u30c6\u30fc\u30d6\u30eb\u3092<code>source<\/code>\u3068\u3057\u3066\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/span><\/p>\r\n<b><span style=\"font-family: arial, helvetica, sans-serif\"><code>models\/schema.yml<\/code>\u306e\u5185\u5bb9<\/span><\/b>\r\n<div class=\"hcb_wrap\">\r\n<pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>version: 2\r\n\r\nsources:\r\n- name: data_warehouse # \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\r\nschema: source_data_schema # \u30b9\u30ad\u30fc\u30de\u540d\r\ntables:\r\n- name: transaction_info # \u5143\u30c6\u30fc\u30d6\u30eb\u540d<\/code><\/pre>\r\n<\/div>\r\n<p>&nbsp;<\/p>\r\n<b><span style=\"font-family: arial, helvetica, sans-serif;font-size: 18pt\"><code>dbt_project.yml<\/code> \u306e\u8a2d\u5b9a<\/span><\/b>\r\n<p><span style=\"font-family: arial, helvetica, sans-serif\">\u6b21\u306b\u3001\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e<code>dbt_project.yml<\/code>\u306b\u5fc5\u8981\u306a\u69cb\u6210\u3092\u8a18\u8ff0\u3057\u307e\u3059\u3002<\/span><\/p>\r\n<b><span style=\"font-family: arial, helvetica, sans-serif\"><code>dbt_project.yml<\/code> \u306e\u5185\u5bb9<\/span><\/b>\r\n<p><span style=\"font-family: arial, helvetica, sans-serif\"><!-- notionvc: b0dbb9a0-14da-480f-9690-bf1a8f817493 --><\/span><\/p>\r\n<p>&nbsp;<\/p>\r\n<div class=\"hcb_wrap\">\r\n<pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>name: 'my_new_project'\r\n\r\nconfig-version: 2\r\n\r\nprofile: 'my_new_project'\r\n\r\nmodel-paths: [\"models\"]\r\nseed-paths: [\"seeds\"]\r\ntest-paths: [\"tests\"]\r\nanalysis-paths: [\"analysis\"]\r\nmacro-paths: [\"macros\"]\r\n\r\ntarget-path: \"target\"\r\nclean-targets:\r\n- \"target\"\r\n- \"dbt_modules\"\r\n- \"logs\"\r\n\r\nmodels:\r\nmy_new_project:\r\n+materialized: table # \u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u7d20\u6750\u5316\u3092\u30c6\u30fc\u30d6\u30eb\u306b\u8a2d\u5b9a\r\ntransaction_info_transformed_view:\r\n+materialized: view\r\ntransaction_info_final_table:\r\n+materialized: table<\/code><\/pre>\r\n<\/div>\r\n<p><!-- notionvc: 9fc335de-bebd-4002-a419-f383488ff40e --><\/p>\n\n<h2>2. \u6570\u5024\u578b\u304b\u3089DATE\u578b\u3078\u306e\u5909\u63db<\/h2>\n<p><span style=\"font-family: arial, helvetica, sans-serif\">\u6570\u5024\u578b\u30ab\u30e9\u30e0\u3092<code>DATE<\/code>\u578b\u306b\u5909\u63db\u3059\u308b\u30d3\u30e5\u30fc\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<code>transaction_info_transformed_view<\/code>\u30d3\u30e5\u30fc\u304c\u5909\u63db\u3092\u62c5\u5f53\u3057\u3001<code>DATE<\/code>\u578b\u306e\u30ab\u30e9\u30e0\u3092\u6301\u3064\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u751f\u6210\u3057\u307e\u3059\u3002<\/span><\/p>\r\n<b><span style=\"font-family: arial, helvetica, sans-serif\"><code>models\/transaction_info_transformed_view.sql<\/code><\/span><\/b>\r\n<div class=\"hcb_wrap\">\r\n<pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>WITH source AS (\r\nSELECT *\r\nFROM {{ source('data_warehouse', 'transaction_info') }}\r\n)\r\n\r\nSELECT\r\nTO_DATE(TO_CHAR(TRANSACTION_MONTH), 'YYYYMM') AS TRANSACTION_MONTH_DATE,\r\nTO_DATE(TO_CHAR(RECORD_DATE), 'YYYYMM') AS RECORD_DATE_DATE,\r\n*\r\nFROM source\r\n<\/code><\/pre>\r\n<\/div>\r\n<p><!-- notionvc: d091da32-1189-4fef-bc6c-130006f479f6 --><\/p>\n\n<h2>3. \u5909\u63db\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092\u6c38\u7d9a\u5316\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u306e\u751f\u6210<\/h2>\n<p><span style=\"font-family: arial, helvetica, sans-serif\">\u5909\u63db\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092\u6301\u3064<code>transaction_info_transformed_view<\/code>\u30d3\u30e5\u30fc\u3092\u57fa\u306b\u3001<code>transaction_info_final_table<\/code>\u3068\u3044\u3046\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/span><\/p>\r\n<b><span style=\"font-family: arial, helvetica, sans-serif\"><code>models\/transaction_info_final_table.sql<\/code><\/span><\/b>\r\n<div class=\"hcb_wrap\">\r\n<pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>SELECT *\r\nFROM {{ ref('transaction_info_transformed_view') }}\r\n<\/code><\/pre>\r\n<\/div>\r\n<p>&nbsp;<\/p>\r\n<p><span style=\"font-family: arial, helvetica, sans-serif\">\u3053\u306e\u8a2d\u5b9a\u306b\u3088\u308a\u3001<span data-token-index=\"1\" class=\"notion-enable-hover\">dbt run<\/span>\u3092\u5b9f\u884c\u3059\u308b\u305f\u3073\u306b\u3001\u5909\u63db\u6e08\u307f\u30c7\u30fc\u30bf\u304c<span data-token-index=\"3\" class=\"notion-enable-hover\">transaction_info_final_table<\/span>\u30c6\u30fc\u30d6\u30eb\u306b\u4fdd\u5b58\u3055\u308c\u3001\u6700\u65b0\u306e\u30c7\u30fc\u30bf\u304c\u5e38\u306b\u4fdd\u6301\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<!-- notionvc: 2df8708b-bb1d-4f31-bdab-917894b5dd24 --><\/span><\/p>\r\n<p>&nbsp;<\/p>\r\n<b><span style=\"font-family: arial, helvetica, sans-serif\">\u5b9f\u884c\u624b\u9806<\/span><\/b>\r\n<p><span style=\"font-family: arial, helvetica, sans-serif\">\u8a2d\u5b9a\u304c\u6574\u3063\u305f\u3089\u3001\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3067\u30e2\u30c7\u30eb\u306e\u5b9f\u884c\u304c\u53ef\u80fd\u3067\u3059\u3002<\/span><\/p>\r\n<div class=\"hcb_wrap\">\r\n<pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>dbt test --\u30c6\u30b9\u30c8\r\n\r\ndbt run --\u5b9f\u884c<\/code><\/pre>\r\n<\/div>\r\n<p><span style=\"font-family: arial, helvetica, sans-serif\"><!-- notionvc: b42108b8-5710-4e84-b63b-63dac88c3690 --><\/span><\/p>\r\n<p><span style=\"font-family: arial, helvetica, sans-serif\">\u3053\u306e\u30b3\u30de\u30f3\u30c9\u306b\u3088\u308a\u3001<span data-token-index=\"1\" class=\"notion-enable-hover\">DATE<\/span>\u578b\u306b\u5909\u63db\u3055\u308c\u305f\u30ab\u30e9\u30e0\u3092\u6301\u3064\u30d3\u30e5\u30fc\u3068\u3001\u305d\u306e\u30c7\u30fc\u30bf\u3092\u6c38\u7d9a\u5316\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u304c\u81ea\u52d5\u7684\u306b\u751f\u6210\u3055\u308c\u307e\u3059\u3002<\/span><!-- notionvc: f169460b-617d-40a0-b25d-172ffd4451bb --><\/p>\r\n<p><!-- notionvc: e6e6a32f-0892-4f89-bffc-ad68f6f364ae --><\/p>\n\n<h2>\u304a\u307e\u3051: dbt Power User \u62e1\u5f35\u6a5f\u80fd<\/h2>\n<p><span style=\"font-family: arial, helvetica, sans-serif\">\u52b9\u7387\u7684\u306a<code>dbt<\/code>\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u7ba1\u7406\u306b\u306f\u3001VS Code\u306e<code>dbt Power User<\/code>\u62e1\u5f35\u6a5f\u80fd\u3092\u6d3b\u7528\u3059\u308b\u306e\u304c\u4fbf\u5229\u3067\u3059\u3002\u3053\u306e\u62e1\u5f35\u6a5f\u80fd\u306b\u3088\u308a\u3001<code>dbt test<\/code>\u30b3\u30de\u30f3\u30c9\u5b9f\u884c\u6642\u306b\u76f4\u63a5\u30c6\u30fc\u30d6\u30eb\u5185\u5bb9\u306e\u30af\u30a8\u30ea\u7d50\u679c\u3084\u30ea\u30cd\u30fc\u30b8\u306e\u53ef\u8996\u5316\u304c\u53ef\u80fd\u3067\u3059\u3002\u578b\u5909\u63db\u3084\u30c7\u30fc\u30bf\u69cb\u9020\u3092\u7d20\u65e9\u304f\u78ba\u8a8d\u3067\u304d\u3001\u7279\u306b\u30c6\u30b9\u30c8\u3084\u30c7\u30d0\u30c3\u30b0\u4f5c\u696d\u304c\u5bb9\u6613\u306b\u306a\u308a\u307e\u3059\u3002<\/span><\/p>\r\n<p><img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2024\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-10-25-17.26.39.png\" alt=\"\" width=\"1926\" height=\"358\" class=\"alignnone size-full wp-image-5725\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2024\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-10-25-17.26.39.png 1926w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2024\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-10-25-17.26.39-300x56.png 300w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2024\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-10-25-17.26.39-1024x190.png 1024w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2024\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-10-25-17.26.39-768x143.png 768w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2024\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-10-25-17.26.39-1536x286.png 1536w\" sizes=\"(max-width: 1926px) 100vw, 1926px\" \/><\/p>\r\n<p><span style=\"font-family: arial, helvetica, sans-serif\">\u30af\u30a8\u30ea\u7d50\u679c\u306e\u898b\u65b9\u306b\u3064\u3044\u3066\u3001select\u53e5\u3092\u9078\u629e\u3057\u3066\u300cCommand\u300d+ ENTER\u3067\u30bf\u30fc\u30df\u30ca\u30eb\u306e\u300cQUERY RESULTS\u300d\u304b\u3089\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<!-- notionvc: ad085d2b-cb3a-4219-9343-5e04992feefa --><\/span><\/p>\r\n<p><img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2024\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-10-25-17.14.27.png\" alt=\"\" width=\"796\" height=\"513\" class=\"alignnone size-full wp-image-5726\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2024\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-10-25-17.14.27.png 796w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2024\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-10-25-17.14.27-300x193.png 300w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2024\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-10-25-17.14.27-768x495.png 768w\" sizes=\"(max-width: 796px) 100vw, 796px\" \/><\/p>\r\n<p><span style=\"font-family: arial, helvetica, sans-serif\">\u30ea\u30cd\u30fc\u30b8\u306e\u53ef\u8996\u5316\u306f\u300cLINEAGR\u300d\u304b\u3089\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/span><!-- notionvc: 748b2f12-9196-4642-b478-df287e95580b --><\/p>\r\n<p><img decoding=\"async\" src=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2024\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-10-25-17.20.01.png\" alt=\"\" width=\"1254\" height=\"488\" class=\"alignnone size-full wp-image-5727\" srcset=\"https:\/\/since2020.jp\/media\/wp-content\/uploads\/2024\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-10-25-17.20.01.png 1254w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2024\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-10-25-17.20.01-300x117.png 300w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2024\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-10-25-17.20.01-1024x398.png 1024w, https:\/\/since2020.jp\/media\/wp-content\/uploads\/2024\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-10-25-17.20.01-768x299.png 768w\" sizes=\"(max-width: 1254px) 100vw, 1254px\" \/><\/p>\r\n<p><!-- notionvc: e55ed689-1e80-4ad3-89c6-e17a974c3609 --><\/p>\n\n<h2>\u307e\u3068\u3081<\/h2>\n<p><span style=\"font-family: arial, helvetica, sans-serif\">\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001<span data-token-index=\"1\" class=\"notion-enable-hover\">dbt<\/span>\u3092\u7528\u3044\u3066\u6570\u5024\u578b\u306e\u30c7\u30fc\u30bf\u3092<span data-token-index=\"3\" class=\"notion-enable-hover\">DATE<\/span>\u578b\u306b\u5909\u63db\u3057\u3001\u6700\u65b0\u306e\u5909\u63db\u6e08\u307f\u30c7\u30fc\u30bf\u3092\u6301\u3064\u30c6\u30fc\u30d6\u30eb\u3092\u751f\u6210\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002\u3053\u308c\u306b\u3088\u308a\u3001\u5909\u63db\u4f5c\u696d\u306e\u52b9\u7387\u5316\u3068\u30c7\u30fc\u30bf\u306e\u6700\u65b0\u6027\u304c\u7dad\u6301\u3067\u304d\u307e\u3059\u3002<\/span><!-- notionvc: 9e6612a8-8165-424f-8b9b-cd0e1518edad --><\/p>","protected":false},"excerpt":{"rendered":"<p>\u30c7\u30fc\u30bf\u30d1\u30a4\u30d7\u30e9\u30a4\u30f3\u3067\u3001\u6570\u5024\u578b\u30ab\u30e9\u30e0\u304b\u3089DATE\u578b\u3078\u5909\u63db\u3057\u3001\u5e38\u306b\u6700\u65b0\u306e\u5909\u63db\u6e08\u307f\u30c7\u30fc\u30bf\u3092\u6301\u3064\u30c6\u30fc\u30d6\u30eb\u3092\u7dad\u6301\u3059\u308b\u30b7\u30b9\u30c6\u30e0\u69cb\u7bc9\u306b\u3064\u3044\u3066\u3001dbt\u3067\u306e\u5b9f\u88c5\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u672c\u8a18\u4e8b\u3067\u306f\u3001dbt\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u3001\u30c7\u30fc\u30bf\u578b\u5909\u63db\u3001 [&hellip;]<\/p>\n","protected":false},"author":87,"featured_media":5728,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","swell_btn_cv_data":"","footnotes":"","_wp_rev_ctl_limit":""},"categories":[1246],"tags":[491,758,216,674,548],"class_list":["post-5724","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-infrastructure","tag-dbt","tag-dbt-core","tag-snowflake","tag-674","tag-548"],"_links":{"self":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/posts\/5724","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/users\/87"}],"replies":[{"embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/comments?post=5724"}],"version-history":[{"count":0,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/posts\/5724\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/media\/5728"}],"wp:attachment":[{"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/media?parent=5724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/categories?post=5724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/since2020.jp\/media\/wp-json\/wp\/v2\/tags?post=5724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}