Learn how you can move your data through different tiers using MERGE either with pySpark or SQL in Azure Synapse Analytics. Stijn Wynants walks you through the different steps.<\/p>\n

Stijn Wynants
\nhttps:\/\/twitter.com\/SQLStijn<\/a><\/p>\n

pyspark.sql.SparkSession.createDataFrame
\nhttps:\/\/spark.apache.org\/docs\/latest\/api\/python\/reference\/pyspark.sql\/api\/pyspark.sql.SparkSession.createDataFrame.html<\/a><\/p>\n

Table deletes, updates, and merges
\nhttps:\/\/docs.delta.io\/latest\/delta-update.html#language-python<\/a><\/p>\n

Delta Lake Documentation
\nhttps:\/\/docs.delta.io\/latest\/delta-intro.html<\/a><\/p>\n

\ud83d\udce2 Become a member: https:\/\/guyinacu.be\/membership<\/a> <\/p>\n

*******************<\/p>\n

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.<\/p>\n

\ud83c\udf93 Guy in a Cube courses: https:\/\/guyinacu.be\/courses<\/a><\/p>\n

*******************
\nLET’S CONNECT!
\n*******************<\/p>\n

— http:\/\/twitter.com\/guyinacube<\/a>
\n— http:\/\/twitter.com\/awsaxton<\/a>
\n— http:\/\/twitter.com\/patrickdba<\/a>
\n— <a href=”http:\/\/www.facebook.com\/guyinacube” target=”_blank” rel=”nofollow”>http:\/\/www.facebook.com\/guyinacube<\/a>
\n— https:\/\/www.instagram.com\/guyinacube\/<\/a>
\n— https:\/\/guyinacube.com<\/a><\/p>\n

***Gear***
\n\ud83d\udee0 Check out my Tools page – https:\/\/guyinacube.com\/tools\/<\/a><\/p>\n

#AzureSynapse #merge #GuyInACube<\/p>\n","protected":false},"excerpt":{"rendered":"

Learn how you can move your data through different tiers using MERGE either with pySpark or SQL in Azure Synapse Analytics. Stijn Wynants walks you through the different steps. Stijn Wynants https:\/\/twitter.com\/SQLStijn pyspark.sql.SparkSession.createDataFrame https:\/\/spark.apache.org\/docs\/latest\/api\/python\/reference\/pyspark.sql\/api\/pyspark.sql.SparkSession.createDataFrame.html Table deletes, updates, and merges https:\/\/docs.delta.io\/latest\/delta-update.html#language-python Delta Lake Documentation https:\/\/docs.delta.io\/latest\/delta-intro.html \ud83d\udce2 Become a member: https:\/\/guyinacu.be\/membership ******************* Want to take your Power […]<\/p>\n","protected":false},"author":3,"featured_media":4377,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[137,138],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2022\/08\/TGIP4w61Tyc.jpg?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-18A","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/4376"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=4376"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/4376\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/4377"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=4376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=4376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=4376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}