{"id":11529,"date":"2025-02-04T23:45:10","date_gmt":"2025-02-04T20:45:10","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/"},"modified":"2025-02-04T23:45:10","modified_gmt":"2025-02-04T20:45:10","slug":"kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/","title":{"rendered":"Kestra ile PostgreSQL&#8217;de dbt Modellerinin Orkestrasyonu"},"content":{"rendered":"<p><body><\/p>\n<p>Kestra ile PostgreSQL&#8217;de dbt Modellerinin Orkestrasyonu<\/p>\n<p>Veri i\u015fleme s\u00fcre\u00e7lerinizin karma\u015f\u0131kl\u0131\u011f\u0131n\u0131 azaltmak ve verimlili\u011fini art\u0131rmak i\u00e7in do\u011fru ara\u00e7lar\u0131 se\u00e7mek son derece \u00f6nemlidir.  Bu yaz\u0131da,  pop\u00fcler veri d\u00f6n\u00fc\u015ft\u00fcrme arac\u0131 dbt&#8217;yi g\u00fc\u00e7l\u00fc bir orkestrasyon platformu olan Kestra ile PostgreSQL veritaban\u0131n\u0131zda nas\u0131l entegre edece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayaca\u011f\u0131m.  \u00d6zellikle,  dbt modellerinizi Kestra&#8217;n\u0131n sa\u011flad\u0131\u011f\u0131 yetenekler ile nas\u0131l y\u00f6netebilece\u011finizi ve  i\u015f ak\u0131\u015flar\u0131n\u0131z\u0131 optimize edebilece\u011finizi g\u00f6sterece\u011fim.<\/p>\n<p>\u00d6ncelikle,  dbt&#8217;nin ne oldu\u011funu ve neden kullanman\u0131z gerekti\u011fini \u00f6zetleyelim. dbt (data build tool), SQL tabanl\u0131 veri d\u00f6n\u00fc\u015ft\u00fcrme i\u015flemlerini kolayla\u015ft\u0131ran, modern bir veri d\u00f6n\u00fc\u015ft\u00fcrme arac\u0131d\u0131r.  Karma\u015f\u0131k SQL sorgular\u0131n\u0131z\u0131 y\u00f6netilebilir ve tekrar kullan\u0131labilir par\u00e7alara b\u00f6lmenize olanak tan\u0131r.  Bu sayede,  veri d\u00f6n\u00fc\u015ft\u00fcrme s\u00fcrecinizi daha d\u00fczenli, daha okunabilir ve daha s\u00fcrd\u00fcr\u00fclebilir hale getirirsiniz.  Ancak,  dbt kendi ba\u015f\u0131na bir orkestrasyon platformu de\u011fildir.  Burada Kestra devreye girer.<\/p>\n<p>Kestra, a\u00e7\u0131k kaynak kodlu ve g\u00fc\u00e7l\u00fc bir i\u015f ak\u0131\u015f\u0131 orkestrasyon platformudur.  Farkl\u0131 ara\u00e7lar\u0131 ve teknolojileri birle\u015ftirerek kompleks veri i\u015fleme s\u00fcre\u00e7lerini y\u00f6netmenizi sa\u011flar.  Kestra&#8217;n\u0131n esnek yap\u0131s\u0131 sayesinde, dbt&#8217;yi di\u011fer ara\u00e7larla sorunsuz bir \u015fekilde entegre edebilir ve t\u00fcm veri i\u015fleme s\u00fcrecini tek bir platformda y\u00f6netebilirsiniz.  Bu,  i\u015f ak\u0131\u015flar\u0131n\u0131z\u0131n izlenebilirli\u011fini ve y\u00f6netimini \u00f6nemli \u00f6l\u00e7\u00fcde kolayla\u015ft\u0131r\u0131r.<\/p>\n<h2>Ad\u0131m Ad\u0131m Uygulama<\/h2>\n<p>\u015eimdi, Kestra&#8217;da bir dbt modeli \u00e7al\u0131\u015ft\u0131rmak i\u00e7in gerekli ad\u0131mlar\u0131 inceleyelim.  Bu \u00f6rnekte,  PostgreSQL veritaban\u0131n\u0131z\u0131 kullanaca\u011f\u0131z.<\/p>\n<ol>\n<li><strong>Kestra ve dbt Kurulumu:<\/strong> \u0130lk olarak,  sisteminize Kestra ve dbt&#8217;yi kurman\u0131z gerekmektedir.  Kestra&#8217;n\u0131n resmi dok\u00fcmanlar\u0131ndan kurulum ad\u0131mlar\u0131n\u0131 takip edebilirsiniz.  dbt kurulumu i\u00e7in de dbt&#8217;nin resmi dok\u00fcmanlar\u0131na ba\u015fvurabilirsiniz.  Kurulumdan sonra,  Kestra&#8217;y\u0131 \u00e7al\u0131\u015ft\u0131r\u0131n ve dbt&#8217;nin do\u011fru \u015fekilde yap\u0131land\u0131r\u0131ld\u0131\u011f\u0131ndan emin olun.<\/li>\n<li><strong>Kestra&#8217;da Yeni Bir \u0130\u015f Ak\u0131\u015f\u0131 Olu\u015fturma:<\/strong> Kestra aray\u00fcz\u00fcnde yeni bir i\u015f ak\u0131\u015f\u0131 olu\u015fturun.  Bu i\u015f ak\u0131\u015f\u0131n\u0131n ad\u0131 &#8220;dbt_i\u015f_ak\u0131\u015f\u0131&#8221; olabilir.  \u0130\u015f ak\u0131\u015f\u0131n\u0131z\u0131n i\u00e7ine,  dbt komutlar\u0131n\u0131 \u00e7al\u0131\u015ft\u0131racak bir &#8220;dbt run&#8221; g\u00f6revi ekleyin.<\/li>\n<li><strong>dbt Komutunun Tan\u0131mlanmas\u0131:<\/strong>  &#8220;dbt run&#8221; g\u00f6revinde,  \u00e7al\u0131\u015ft\u0131rmak istedi\u011finiz dbt komutlar\u0131n\u0131 belirleyin.  \u00d6rne\u011fin,  t\u00fcm dbt modellerinizi \u00e7al\u0131\u015ft\u0131rmak i\u00e7in  <code>dbt run<\/code> komutunu kullanabilirsiniz.  Daha spesifik modeller \u00e7al\u0131\u015ft\u0131rmak isterseniz,  <code>dbt run --select model_name<\/code> gibi komutlar\u0131 kullanabilirsiniz. <\/li>\n<li><strong>PostgreSQL Ba\u011flant\u0131s\u0131n\u0131n Kurulmas\u0131:<\/strong>  dbt&#8217;nin PostgreSQL veritaban\u0131n\u0131za ba\u011flanabilmesi i\u00e7in gerekli ba\u011flant\u0131 bilgilerini (IP adresi, port, kullan\u0131c\u0131 ad\u0131, \u015fifre) Kestra&#8217;da tan\u0131mlay\u0131n. Bu bilgileri dbt&#8217;nin profiles.yml dosyas\u0131nda da do\u011fru \u015fekilde yap\u0131land\u0131rman\u0131z gerekmektedir.  <\/li>\n<li><strong>\u0130\u015f Ak\u0131\u015f\u0131n\u0131n \u00c7al\u0131\u015ft\u0131r\u0131lmas\u0131 ve \u0130zlenmesi:<\/strong>  T\u00fcm ad\u0131mlar\u0131 tamamlad\u0131ktan sonra,  Kestra&#8217;da i\u015f ak\u0131\u015f\u0131n\u0131z\u0131 \u00e7al\u0131\u015ft\u0131rabilirsiniz.  Kestra,  i\u015f ak\u0131\u015f\u0131n\u0131z\u0131n ilerlemesini ve sonucunu size g\u00f6sterir.  Herhangi bir hata durumunda,  Kestra size ayr\u0131nt\u0131l\u0131 hata mesajlar\u0131 sa\u011flayarak sorun gidermenize yard\u0131mc\u0131 olacakt\u0131r.<\/li>\n<\/ol>\n<p>Kod \u00f6rne\u011fi (dbt profiles.yml):<\/p>\n<pre><code class=\"language-yaml\">\ndev:\n  target: dev\n  outputs:\n    dev:\n      type: postgres\n      host: localhost\n      port: 5432\n      user: your_username\n      password: your_password\n      dbname: your_database\n<\/code><\/pre>\n<p>Bu ad\u0131mlar\u0131 takip ederek,  Kestra&#8217;y\u0131 kullanarak dbt modellerinizi PostgreSQL veritaban\u0131n\u0131zda kolayca y\u00f6netebilirsiniz.  Kestra&#8217;n\u0131n sa\u011flad\u0131\u011f\u0131 izleme ve y\u00f6netim \u00f6zellikleri,  veri i\u015fleme s\u00fcre\u00e7lerinizin g\u00fcvenilirli\u011fini ve verimlili\u011fini art\u0131racakt\u0131r.  Daha fazla bilgi i\u00e7in <a href=\"https:\/\/kestra.io\/\">Kestra resmi web sitesini<\/a> ve <a href=\"https:\/\/www.getdbt.com\/\">dbt resmi web sitesini<\/a> ziyaret edebilirsiniz.  Daha fazla veri y\u00f6netimi ipucu ve stratejisi i\u00e7in kendi web sitemi <a href=\"https:\/\/fatihsoysal.com\">fatihsoysal.com<\/a> adresini ziyaret etmeyi unutmay\u0131n!<\/p>\n<p>#Etiketler: dbt, Kestra, PostgreSQL, veri y\u00f6netimi, orkestrasyon, veri i\u015fleme, ETL, ELT, data pipeline, SQL, veri d\u00f6n\u00fc\u015ft\u00fcrme, i\u015f ak\u0131\u015f\u0131,  veritaban\u0131,  profile.yml<\/p>\n<p><\/body><br \/>\n<\/html><\/p>\n","protected":false},"excerpt":{"rendered":"Kestra ile PostgreSQL&#8217;de dbt Modellerinin Orkestrasyonu Veri i\u015fleme s\u00fcre\u00e7lerinizin karma\u015f\u0131kl\u0131\u011f\u0131n\u0131 azaltmak ve verimlili\u011fini art\u0131rmak i\u00e7in do\u011fru ara\u00e7lar\u0131 se\u00e7mek&hellip;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[1],"tags":[],"class_list":{"0":"post-11529","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-genel","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Kestra ile PostgreSQL&#039;de dbt Modellerinin Orkestrasyonu<\/title>\n<meta name=\"description\" content=\"Veri i\u015fleme s\u00fcre\u00e7lerinizin karma\u015f\u0131kl\u0131\u011f\u0131n\u0131 azaltmak ve verimlili\u011fini art\u0131rmak i\u00e7in do\u011fru ara\u00e7lar\u0131 se\u00e7mek son derece \u00f6nemlidir. Bu yaz\u0131da, pop\u00fcler veri d\u00f6n\u00fc\u015ft\u00fcrme arac\u0131 dbt&#039;yi g\u00fc\u00e7l\u00fc bir orkestrasyon platformu olan Kestra ile PostgreSQL veritaban\u0131n\u0131zda nas\u0131l entegre edece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayaca\u011f\u0131m. \u00d6zellikle, dbt modellerinizi Kestra&#039;n\u0131n sa\u011flad\u0131\u011f\u0131 yetenekler ile nas\u0131l y\u00f6netebilece\u011finizi ve i\u015f ak\u0131\u015flar\u0131n\u0131z\u0131 optimize edebilece\u011finizi g\u00f6sterece\u011fim.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kestra ile PostgreSQL&#039;de dbt Modellerinin Orkestrasyonu\" \/>\n<meta property=\"og:description\" content=\"Veri i\u015fleme s\u00fcre\u00e7lerinizin karma\u015f\u0131kl\u0131\u011f\u0131n\u0131 azaltmak ve verimlili\u011fini art\u0131rmak i\u00e7in do\u011fru ara\u00e7lar\u0131 se\u00e7mek son derece \u00f6nemlidir. Bu yaz\u0131da, pop\u00fcler veri d\u00f6n\u00fc\u015ft\u00fcrme arac\u0131 dbt&#039;yi g\u00fc\u00e7l\u00fc bir orkestrasyon platformu olan Kestra ile PostgreSQL veritaban\u0131n\u0131zda nas\u0131l entegre edece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayaca\u011f\u0131m. \u00d6zellikle, dbt modellerinizi Kestra&#039;n\u0131n sa\u011flad\u0131\u011f\u0131 yetenekler ile nas\u0131l y\u00f6netebilece\u011finizi ve i\u015f ak\u0131\u015flar\u0131n\u0131z\u0131 optimize edebilece\u011finizi g\u00f6sterece\u011fim.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-04T20:45:10+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"Kestra ile PostgreSQL&#8217;de dbt Modellerinin Orkestrasyonu\",\"datePublished\":\"2025-02-04T20:45:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/\"},\"wordCount\":669,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/\",\"name\":\"Kestra ile PostgreSQL'de dbt Modellerinin Orkestrasyonu\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-02-04T20:45:10+00:00\",\"description\":\"Veri i\u015fleme s\u00fcre\u00e7lerinizin karma\u015f\u0131kl\u0131\u011f\u0131n\u0131 azaltmak ve verimlili\u011fini art\u0131rmak i\u00e7in do\u011fru ara\u00e7lar\u0131 se\u00e7mek son derece \u00f6nemlidir. Bu yaz\u0131da, pop\u00fcler veri d\u00f6n\u00fc\u015ft\u00fcrme arac\u0131 dbt'yi g\u00fc\u00e7l\u00fc bir orkestrasyon platformu olan Kestra ile PostgreSQL veritaban\u0131n\u0131zda nas\u0131l entegre edece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayaca\u011f\u0131m. \u00d6zellikle, dbt modellerinizi Kestra'n\u0131n sa\u011flad\u0131\u011f\u0131 yetenekler ile nas\u0131l y\u00f6netebilece\u011finizi ve i\u015f ak\u0131\u015flar\u0131n\u0131z\u0131 optimize edebilece\u011finizi g\u00f6sterece\u011fim.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kestra ile PostgreSQL&#8217;de dbt Modellerinin Orkestrasyonu\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Kestra ile PostgreSQL'de dbt Modellerinin Orkestrasyonu","description":"Veri i\u015fleme s\u00fcre\u00e7lerinizin karma\u015f\u0131kl\u0131\u011f\u0131n\u0131 azaltmak ve verimlili\u011fini art\u0131rmak i\u00e7in do\u011fru ara\u00e7lar\u0131 se\u00e7mek son derece \u00f6nemlidir. Bu yaz\u0131da, pop\u00fcler veri d\u00f6n\u00fc\u015ft\u00fcrme arac\u0131 dbt'yi g\u00fc\u00e7l\u00fc bir orkestrasyon platformu olan Kestra ile PostgreSQL veritaban\u0131n\u0131zda nas\u0131l entegre edece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayaca\u011f\u0131m. \u00d6zellikle, dbt modellerinizi Kestra'n\u0131n sa\u011flad\u0131\u011f\u0131 yetenekler ile nas\u0131l y\u00f6netebilece\u011finizi ve i\u015f ak\u0131\u015flar\u0131n\u0131z\u0131 optimize edebilece\u011finizi g\u00f6sterece\u011fim.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/","og_locale":"tr_TR","og_type":"article","og_title":"Kestra ile PostgreSQL'de dbt Modellerinin Orkestrasyonu","og_description":"Veri i\u015fleme s\u00fcre\u00e7lerinizin karma\u015f\u0131kl\u0131\u011f\u0131n\u0131 azaltmak ve verimlili\u011fini art\u0131rmak i\u00e7in do\u011fru ara\u00e7lar\u0131 se\u00e7mek son derece \u00f6nemlidir. Bu yaz\u0131da, pop\u00fcler veri d\u00f6n\u00fc\u015ft\u00fcrme arac\u0131 dbt'yi g\u00fc\u00e7l\u00fc bir orkestrasyon platformu olan Kestra ile PostgreSQL veritaban\u0131n\u0131zda nas\u0131l entegre edece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayaca\u011f\u0131m. \u00d6zellikle, dbt modellerinizi Kestra'n\u0131n sa\u011flad\u0131\u011f\u0131 yetenekler ile nas\u0131l y\u00f6netebilece\u011finizi ve i\u015f ak\u0131\u015flar\u0131n\u0131z\u0131 optimize edebilece\u011finizi g\u00f6sterece\u011fim.","og_url":"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-02-04T20:45:10+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"Kestra ile PostgreSQL&#8217;de dbt Modellerinin Orkestrasyonu","datePublished":"2025-02-04T20:45:10+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/"},"wordCount":669,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/","url":"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/","name":"Kestra ile PostgreSQL'de dbt Modellerinin Orkestrasyonu","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-02-04T20:45:10+00:00","description":"Veri i\u015fleme s\u00fcre\u00e7lerinizin karma\u015f\u0131kl\u0131\u011f\u0131n\u0131 azaltmak ve verimlili\u011fini art\u0131rmak i\u00e7in do\u011fru ara\u00e7lar\u0131 se\u00e7mek son derece \u00f6nemlidir. Bu yaz\u0131da, pop\u00fcler veri d\u00f6n\u00fc\u015ft\u00fcrme arac\u0131 dbt'yi g\u00fc\u00e7l\u00fc bir orkestrasyon platformu olan Kestra ile PostgreSQL veritaban\u0131n\u0131zda nas\u0131l entegre edece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayaca\u011f\u0131m. \u00d6zellikle, dbt modellerinizi Kestra'n\u0131n sa\u011flad\u0131\u011f\u0131 yetenekler ile nas\u0131l y\u00f6netebilece\u011finizi ve i\u015f ak\u0131\u015flar\u0131n\u0131z\u0131 optimize edebilece\u011finizi g\u00f6sterece\u011fim.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/kestra-ile-postgresqlde-dbt-modellerinin-orkestrasyonu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Kestra ile PostgreSQL&#8217;de dbt Modellerinin Orkestrasyonu"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/11529","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=11529"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/11529\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=11529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=11529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=11529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}