{"id":8249,"date":"2023-04-03T23:41:57","date_gmt":"2023-04-04T06:41:57","guid":{"rendered":"https:\/\/datatoolspro.com\/?p=8249"},"modified":"2023-11-03T10:31:50","modified_gmt":"2023-11-03T17:31:50","slug":"snowflake-udf-2","status":"publish","type":"post","link":"https:\/\/datatoolspro.com\/snowflake-udf-2\/","title":{"rendered":"How my Snowflake Powered Lead Distro Test Turned Out to be Reverse ETL"},"content":{"rendered":"\n<p id=\"2914\">A year ago, I worked on a small project to help us improve our data driven funnel. I learned what I called \u201cSnowflake to Salesforce analytics sync\u201d had a more buzzworthy term called \u201cReverse ETL.\u201d This article shares some of the lessons learned along the way and some thoughts about where reverse ETL is headed.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"65f3\"><strong>Low Level of Effort Solution<\/strong><\/h2>\n\n\n\n<p id=\"d5aa\">All of the data and metrics were already available and calculated in Snowflake for reporting, so the process to push those measurements back into a Salesforce object using Azure Data Factory was quite simple.<\/p>\n\n\n\n<p id=\"ac8d\">The transformation work was prepared using&nbsp;<a href=\"https:\/\/www.datameer.com\/\" rel=\"noreferrer noopener\" target=\"_blank\">Datameer<\/a>&nbsp;on top of Snowflake which I had previously written about:&nbsp;<a href=\"https:\/\/medium.com\/datameer-inc\/cut-through-your-snowflake-data-like-a-buzzsaw-with-datameer-3aab1b8e9ba\">Slice Through your Snowflake Data like a Buzzsaw with Datameer<\/a><\/p>\n\n\n\n<div class=\"wp-block-genesis-blocks-gb-button gb-block-button\"><a href=\"https:\/\/medium.com\/@rmgoodm\/how-my-snowflake-powered-lead-distro-test-turned-out-to-be-reverse-etl-c076f319051c\" class=\"gb-button gb-button-shape-rounded gb-button-size-medium\" style=\"color:#ffffff;background-color:#3373dc\">Read more on Medium Blog<\/a><\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Easily create, validate, and deploy UDFs with ChatGPT. Get your custom functions up and running in Snowflake in no time, using the natural language processing capabilities of ChatGPT.<\/p>\n","protected":false},"author":63999309096822,"featured_media":8250,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ub_ctt_via":"","_youtube_id":"","_next_video":0,"_sequence":0,"_length":"","footnotes":""},"categories":[192],"tags":[191,184,182,190,133,183],"class_list":["post-8249","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-snowflake","tag-data-migration","tag-datameer","tag-migration","tag-salesforce","tag-salesforce-com","tag-snowflake"],"aioseo_notices":[],"featured_image_src":"https:\/\/datatoolspro.com\/wp-content\/uploads\/2023\/04\/datatoolspro_1_simple_straight_light_blue_pipeline_that_is_floa_cc84dbd7-fa31-4f71-9fc9-da6020091570-588x400.png","author_info":{"display_name":"Ryan Goodman","author_link":"https:\/\/datatoolspro.com\/author\/ryangoodman\/"},"featured_image_src_square":"https:\/\/datatoolspro.com\/wp-content\/uploads\/2023\/04\/datatoolspro_1_simple_straight_light_blue_pipeline_that_is_floa_cc84dbd7-fa31-4f71-9fc9-da6020091570.png","_links":{"self":[{"href":"https:\/\/datatoolspro.com\/wp-json\/wp\/v2\/posts\/8249","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datatoolspro.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datatoolspro.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datatoolspro.com\/wp-json\/wp\/v2\/users\/63999309096822"}],"replies":[{"embeddable":true,"href":"https:\/\/datatoolspro.com\/wp-json\/wp\/v2\/comments?post=8249"}],"version-history":[{"count":0,"href":"https:\/\/datatoolspro.com\/wp-json\/wp\/v2\/posts\/8249\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datatoolspro.com\/wp-json\/wp\/v2\/media\/8250"}],"wp:attachment":[{"href":"https:\/\/datatoolspro.com\/wp-json\/wp\/v2\/media?parent=8249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datatoolspro.com\/wp-json\/wp\/v2\/categories?post=8249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datatoolspro.com\/wp-json\/wp\/v2\/tags?post=8249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}