Subscribe to our blog newsletter

Get the best, coolest and latest delivered to your inbox each week

BUILD: The Dev Conference for AI & Apps (Nov. 12-14)

Hear the latest product announcements and push the limits of what can be done in the AI Data Cloud.

AI & ML

Custom SQL Now Supported in the Snowflake Connector for Power BI!

Custom SQL Now Supported in the Snowflake Connector for Power BI!

As the adoption of the Snowflake Data Cloud and Power BI continues to gain momentum across all business and vertical markets, it’s important that the capabilities, user experience, and integration of Snowflake and Power BI continue to evolve to provide best-in-class experiences to our users. To this end, Snowflake and Microsoft have developed a strong partnership focused on listening to our mutual community of users and delivering the capabilities they demand to achieve productivity, flexibility, and agility when using our platforms.

The most recent success of the partnership between the Snowflake and Power BI teams is the release of the highly requested feature, Custom SQL Support for the Snowflake Connector. This exciting new capability is available now in the latest version of Power BI! Custom SQL Support unlocks time savings, flexibility, and various new capabilities for Power BI and Snowflake users, enhancing their productivity and effectiveness. Additionally, Custom SQL is supported in both DirectQuery and Import modes, further enhancing your team’s ability to customize your data models to accommodate business needs.

Some of the Benefits of Custom SQL Support in Snowflake Connector for Power BI

Custom SQL Support for the Snowflake Connector unlocks new capabilities, including:

Enhanced Ability to Leverage the Power of Snowflake! With Snowflake’s near-infinitely scalable compute, you’ll want to perform the heavy lifting of your query operations in Snowflake when possible (rather than the Power BI service). Custom SQL allows you to write queries that will be executed directly in Snowflake.

Streamlined Migrations. If you are currently using a data source that supports Custom SQL, you can simply migrate that SQL to the Snowflake Connector, significantly reducing the time and effort required to migrate to Snowflake.

Query Folding. Query folding is the ability for a Power Query to generate a single query statement to retrieve and transform source data. I could write an entire post on the benefits of query folding, but for now the important item to note is that Custom SQL enables query folding for Snowflake, which could result in more-efficient operations in Power BI. Query folding results in SQL execution being pushed back to the database (Snowflake) for execution.

Simplify Complex Transformations. Power Query is a very powerful tool for transforming data sets in Power BI; however, some complex SQL operations are difficult or impossible to perform in Power Query. Custom SQL enables the power of Snowflake SQL directly in Power BI.

Greater Flexibility for Analysts and Business Users. Users with limited access to database objects can now use Custom SQL to perform joins, unions, and so on, while (as mentioned above) leveraging the power of Snowflake to perform the operation rather than the Power BI service.

Greater Flexibility Adding Custom Columns. Adding custom columns using Custom SQL is particularly important to overcome limitations of DAX in DirectQuery mode and also removes potential overhead of calculations performed in the Power BI service. 

Getting Started with Custom SQL in the Snowflake Connector for Power BI

Solution Overview

To implement this solution, you’ll complete the following high-level steps:

  1. Confirm you’re using the latest version of Power BI (or download the latest June 2021 release).
  2. Connect to Snowflake using Snowflake Connector for Power BI.

Architecture

Prerequisites

Before starting this walkthrough, you must have the following:

  • A Snowflake account. If you do not have one, please register for a free 30-day trial account at trial.snowflake.com.

Confirm You’re Using the Latest Version of Power BI

To confirm you’re using the latest version of Power BI Desktop, click the Help menu item and then the About option. You’ll see the version name, which should indicate June 2021 (or later).

Connect to Snowflake Using Snowflake Connector for Power BI

In this release, the connector currently requires a fully qualified table name (DATABASENAME.SCHEMANAME.TABLENAME) in the query, and the database name field is required (even though the UI describes the field as optional). The Microsoft Power BI Team is working on continuing to improve and streamline the user experience.

To configure Power BI, complete the following steps:

1. Select Get Data from the menu, and then find the Snowflake Connector.

Tip: Type “Snowflake” in the search box to quickly find the Snowflake Connector.

2. Enter your server (Snowflake account URL), the Snowflake Warehouse, the Snowflake Role, and the Snowflake Database. Please note, the text currently says “(optional),” but the database name is currently required. Finally, add your SQL statement in the text box and hit OK.

Snowflake 
mysnowflakeaccount.snowfakecomputing.com 
Warehouse 
PowerBl_WH 
Advanced options 
Specify a text value to use as Role name (optional) 
ANALYST 
Command timeout in seconds (optional) 
Connection timeout in seconds (optional)
SQL statement (optional, requires database) 
SELECT * 
FROBy submitting this form, I understand Snowflake will process my personal information in accordance with their Privacy Notice.

\r\n","richText":true,":type":"snowflake-site/components/text"}},":type":"snowflake-site/components/flexible-column-container/flexible-column-content-container",":itemsOrder":["marketo_v2","text"]},":type":"snowflake-site/components/flexible-column-container"}},":type":"snowflake-site/components/container",":itemsOrder":["flexible_column_cont"]},"experiencefragment-banner":{"id":"experiencefragment-32af666c1c","configured":true,"localizedFragmentVariationPath":"/content/experience-fragments/snowflake-site/language-masters/en/site/pushdown-banner/master/jcr:content",":items":{"root":{"layout":"RESPONSIVE_GRID","columnCount":12,"gridClassNames":"aem-Grid aem-Grid--12 aem-Grid--default--12","columnClassNames":{"pushdown_banner":"aem-GridColumn aem-GridColumn--default--12"},"id":"container-d7233f8125",":items":{"pushdown_banner":{"id":"pushdown-banner-aeb5c34ef1","contentHeadline":"BUILD: The Dev Conference for AI & Apps (Nov. 12-14) ","contentDescription":"Hear the latest product announcements and push the limits of what can be done in the AI Data Cloud.","contentJustifyContent":"center","backgroundImageOption":"/content/dam/snowflake-site/general/design-ops/pushdown-banner/snowflake-brand.png","linkStyle":"text-white","linkCTA":{"id":"link-cta","heapButtonClasses":["pushdown_banner"],"showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/build/?utm_cta=website-push-down-banner-Build-global","attributes":{"target":"_blank"}},"linkTargetContentType":"GENERIC","text":"Register Today",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/pushdown-banner","appliedCssClassNames":"snowflake-pushdown-banner-text-white snowflake-pushdown-banner-background-black"}},":type":"snowflake-site/components/container",":itemsOrder":["pushdown_banner"]},"image":{":type":"nt:unstructured"},"cq:metadata":{":type":"nt:unstructured"}},":type":"snowflake-site/components/experiencefragment",":itemsOrder":["root","image","cq:metadata"],"classNames":"aem-xf"},"experiencefragment-header":{"id":"experiencefragment-9dd9b4ed91","configured":true,"localizedFragmentVariationPath":"/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/jcr:content",":items":{"root":{"layout":"RESPONSIVE_GRID","columnCount":12,"gridClassNames":"aem-Grid aem-Grid--12 aem-Grid--default--12","columnClassNames":{"mega_header":"aem-GridColumn aem-GridColumn--default--12","markup_editor":"aem-GridColumn aem-GridColumn--default--12"},"id":"container-18f800fa4d",":items":{"markup_editor":{"id":"markup-editor-0252077d87","title":" ","cssContent":"div[id*=\"blueIcon\"] .snowflake-mega-nav-nav-item-icon__inner {\r\n background: var(--ui-01);\r\n padding: 8px;\r\n}\r\nbody:not(.blog-page) .snowflake-image-caption { display: none !important; }\r\n\r\n#arcticNavItem { flex-direction: column; }\r\n#arcticNavItem::before {\r\ncontent: 'Featured Open Source Technologies';\r\ndisplay: block;\r\nmargin-top: 48px;\r\nmargin-bottom: 24px;\r\ncolor: var(--text-05);\r\n font-family: Texta, sans-serif !important;\r\n font-size: 16px !important;\r\n line-height: 16px !important;\r\nfont-weight: 800 !important;\r\n text-transform: uppercase;\r\n}\r\n@media screen and (min-width: 1024px) {\r\n#polarisNavItem { margin-top: 40px; }\r\n\r\n}\r\n@media screen and (min-width: 768px) {\r\n#arcticNavItem::before {\r\nfont-size: 12px !important;\r\nmargin-bottom: 8px;\r\nmargin-top: 16px;\r\n}\r\n}\r\n\r\n\r\ndiv[id*=\"blueIcon\"] .snowflake-mega-nav-nav-item-icon__inner {\r\n background: var(--ui-01);\r\n padding: 8px;\r\n}\r\ndiv[id*=\"blueIcon\"]:hover .snowflake-mega-nav-nav-item-icon__inner {\r\n background: var(--ui-01) !important;\r\n}\r\n\r\n.snowflake-mega-nav-nav-item-icon__inner {\r\n border-radius: 4px;\r\n background: var(--ui-background-05);\r\n padding: 6px;\r\n}\r\n.snowflake-mega-nav-nav-item:hover .snowflake-mega-nav-nav-item-icon__inner {\r\nbackground: #fff !important;\r\n}\r\n.snowflake-mega-nav-nav-item-icon.snowflake-image-container {\r\n height: 40px;\r\n width: 40px;\r\n}\r\n\r\n.snowflake-mega-nav-dropdown-footer-links\r\n > .snowflake-button-link\r\n > .snowflake-button-container {\r\n font-size: 16px !important;\r\n font-family: Texta !important;\r\n font-weight: 800 !important;\r\n}\r\n@media screen and (min-width: 1367px) {\r\n .snowflake-mega-nav-dropdown-footer-wrapper\r\n .snowflake-title-v2\r\n .snowflake-title-v2-line:first-child {\r\n font-size: 16px !important;\r\n line-height: 24px !important;\r\n }\r\n}\r\n\r\n.snowflake-mega-nav-dropdown-footer-wrapper {\r\n align-items: center;\r\n}\r\n\r\n.snowflake-mega-nav-dropdown-footer-icon.snowflake-image-container {\r\n margin-right: 8px;\r\n width: 40px !important;\r\n height: 40px !important;\r\n}\r\n\r\n#viewAllCapabilities a:hover {\r\n background: transparent !important;\r\n}\r\n\r\n#platformFooter .snowflake-title-v2 .snowflake-title-v2-line:last-child {\r\n font-family: \"Lato\";\r\n font-size: 14px;\r\n font-weight: 500;\r\n}\r\n#platformFooter .snowflake-mega-nav-dropdown-footer-links {\r\n flex-grow: 1;\r\n justify-content: flex-end;\r\n align-items: center;\r\n}\r\n\r\n#platformFooter .snowflake-mega-nav-dropdown-footer-content {\r\n flex-direction: row;\r\n}\r\n\r\n.snowflake-mega-nav-dropdown-footer-content {\r\n width: 100%;\r\n}\r\n#open-source,\r\n#offset {\r\n flex-direction: column;\r\n border-top: 1px solid #ccc;\r\n}\r\n#offset {\r\n margin-top: 16px;\r\n}\r\n#offset::before,\r\n#open-source::before {\r\n content: \" \";\r\n display: block;\r\n width: 100%;\r\n font-weight: 800 !important;\r\n color: var(--text-05);\r\n font-family: Texta, sans-serif !important;\r\n font-size: 12px !important;\r\n line-height: 14px;\r\n text-transform: uppercase;\r\n white-space: nowrap;\r\n margin-top: 16px;\r\n margin-bottom: 8px;\r\n}\r\n\r\n#open-source::before {\r\n content: \"Open Source Technologies\";\r\n}\r\n.snowflake-mega-nav-dropdown-menu-close-button {\r\n margin: var(--spacing-04) 0 var(--spacing-03);\r\n}\r\n.snowflake-mega-nav-dropdown-header-content-right a {\r\n white-space: nowrap;\r\n}\r\n.snowflake-mega-nav-column {\r\n gap: var(--spacing-02) !important;\r\n}\r\n.snowflake-mega-nav-nav-item > a {\r\n width: 100%;\r\n margin-left: -8px;\r\n padding: 8px;\r\n border-radius: 4px;\r\n}\r\n.snowflake-mega-nav-nav-item > a:hover {\r\n background-color: var(--ui-background-05);\r\n}\r\n.snowflake-mega-nav-nav-item\r\n > a:hover\r\n .snowflake-mega-nav-nav-item-title-wrapper\r\n > .snowflake-mega-nav-nav-item-title {\r\n color: var(--ui-01) !important;\r\n}\r\n.snowflake-mega-nav-column-items {\r\n gap: var(--spacing-02);\r\n grid-gap: var(--spacing-02);\r\n}\r\n.snowflake-mega-nav-nav-item-description {\r\nmargin-top: 2px;\r\ndisplay: block;\r\n}\r\n@media screen and (min-width: 768px) {\r\n .snowflake-mega-nav-nav-item-title-wrapper\r\n > .snowflake-mega-nav-nav-item-title {\r\n line-height: 20px !important;\r\n }\r\n}\r\n@media screen and (min-width: 1024px) {\r\n .snowflake-mega-nav-nav-item-description {\r\n line-height: 18px !important;\r\n }\r\n\r\n .snowflake-mega-nav-column-items {\r\n gap: var(--spacing-01);\r\n grid-gap: var(--spacing-01);\r\n }\r\n}\r\n\r\ndiv[id*=\"blueIcon\"]:hover .snowflake-mega-nav-nav-item-icon__inner {\r\n background: var(--ui-01) !important;\r\n}\r\n\r\n.snowflake-mega-nav-nav-item-icon__inner {\r\n border-radius: 4px;\r\n background: var(--ui-background-05);\r\n padding: 6px;\r\n}\r\n.snowflake-mega-nav-nav-item:hover .snowflake-mega-nav-nav-item-icon__inner {\r\nbackground: #fff !important;\r\n}\r\n.snowflake-mega-nav-nav-item-icon.snowflake-image-container {\r\n height: 40px;\r\n width: 40px;\r\n}\r\n\r\n.snowflake-mega-nav-dropdown-footer-links\r\n > .snowflake-button-link\r\n > .snowflake-button-container {\r\n font-size: 16px !important;\r\n font-family: Texta !important;\r\n font-weight: 800 !important;\r\n}\r\n@media screen and (min-width: 1367px) {\r\n .snowflake-mega-nav-dropdown-footer-wrapper\r\n .snowflake-title-v2\r\n .snowflake-title-v2-line:first-child {\r\n font-size: 16px !important;\r\n line-height: 24px !important;\r\n }\r\n}\r\n\r\n.snowflake-mega-nav-dropdown-footer-wrapper {\r\n align-items: center;\r\n}\r\n\r\n.snowflake-mega-nav-dropdown-footer-icon.snowflake-image-container {\r\n margin-right: 8px;\r\n width: 40px !important;\r\n height: 40px !important;\r\n}\r\n\r\n#viewAllCapabilities a:hover {\r\n background: transparent !important;\r\n}\r\n\r\n#platformFooter .snowflake-title-v2 .snowflake-title-v2-line:last-child {\r\n font-family: \"Lato\";\r\n font-size: 14px;\r\n font-weight: 500;\r\n}\r\n#platformFooter .snowflake-mega-nav-dropdown-footer-links {\r\n flex-grow: 1;\r\n justify-content: flex-end;\r\n align-items: center;\r\n}\r\n\r\n#platformFooter .snowflake-mega-nav-dropdown-footer-content {\r\n flex-direction: row;\r\n}\r\n\r\n.snowflake-mega-nav-dropdown-footer-content {\r\n width: 100%;\r\n}\r\n#open-source,\r\n#offset {\r\n flex-direction: column;\r\n border-top: 1px solid #ccc;\r\n}\r\n#offset {\r\n margin-top: 16px;\r\n}\r\n#offset::before,\r\n#open-source::before {\r\n content: \" \";\r\n display: block;\r\n width: 100%;\r\n font-weight: 800 !important;\r\n color: var(--text-05);\r\n font-family: Texta, sans-serif !important;\r\n font-size: 12px !important;\r\n line-height: 14px;\r\n text-transform: uppercase;\r\n white-space: nowrap;\r\n margin-top: 16px;\r\n margin-bottom: 8px;\r\n}\r\n\r\n#open-source::before {\r\n content: \"Open Source Technologies\";\r\n}\r\n.snowflake-mega-nav-dropdown-menu-close-button {\r\n margin: var(--spacing-04) 0 var(--spacing-03);\r\n}\r\n.snowflake-mega-nav-dropdown-header-content-right a {\r\n white-space: nowrap;\r\n}\r\n.snowflake-mega-nav-column {\r\n gap: var(--spacing-02) !important;\r\n}\r\n.snowflake-mega-nav-nav-item > a {\r\n width: 100%;\r\n margin-left: -8px;\r\n padding: 8px;\r\n border-radius: 4px;\r\n}\r\n.snowflake-mega-nav-nav-item > a:hover {\r\n background-color: var(--ui-background-05);\r\n}\r\n.snowflake-mega-nav-nav-item\r\n > a:hover\r\n .snowflake-mega-nav-nav-item-title-wrapper\r\n > .snowflake-mega-nav-nav-item-title {\r\n color: var(--ui-01) !important;\r\n}\r\n.snowflake-mega-nav-column-items {\r\n gap: var(--spacing-02);\r\n grid-gap: var(--spacing-02);\r\n}\r\n.snowflake-mega-nav-nav-item-description {\r\nmargin-top: 2px;\r\ndisplay: block;\r\n}\r\n@media screen and (min-width: 768px) {\r\n .snowflake-mega-nav-nav-item-title-wrapper\r\n > .snowflake-mega-nav-nav-item-title {\r\n line-height: 20px !important;\r\n }\r\n}\r\n@media screen and (min-width: 1024px) {\r\n .snowflake-mega-nav-nav-item-description {\r\n line-height: 18px !important;\r\n }\r\n\r\n .snowflake-mega-nav-column-items {\r\n gap: var(--spacing-01);\r\n grid-gap: var(--spacing-01);\r\n }\r\n}\r\n\r\n\r\n@media screen and (min-width: 768px) {\r\n.snowflake-card .heading-2.snowflake-title-line {\r\nfont-size: 24px !important;\r\nline-height: 28px !important;\r\n}\r\n}",":type":"snowflake-site/components/markup-editor"},"mega_header":{"layout":"SIMPLE","id":"container-9ee7f87069",":items":{"nav_mega":{"activeItem":"item_1719963657751","id":"tabs-5eba36d3e5",":type":"snowflake-site/components/nav/nav-mega",":items":{"item_1719963657751":{"id":"nav-dropdown-menu-e78e3c5175","enableDropdown":true,"nav_column_container":{"layout":"SIMPLE","id":"container-96cd1cf823",":items":{"nav_column":{"navColumnTitle":"The AI Data Cloud","numberOfSubColumns":"one-column","minWidth":"230","layout":"SIMPLE","id":"container-9ad4fb02c4",":items":{"nav_item_copy_copy_2":{"id":"nav-item-0813401367","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/data-cloud/platform/"},"linkTargetContentType":"GENERIC","text":"Platform",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_copy_2_1314771042":{"id":"nav-item-88ee81ae0d","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/why-snowflake"},"linkTargetContentType":"GENERIC","text":"Why Snowflake",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_copy_2_836345186":{"id":"nav-item-1197ba77cb","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/resources/learn/snowflake-security-hub/"},"linkTargetContentType":"GENERIC","text":"Security Hub",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_144634":{"id":"nav-item-8da13480d0","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/data-cloud/pricing/cost-and-performance-optimization/"},"linkTargetContentType":"GENERIC","text":"Cost & Performance Optimization",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_copy_2_1262881566":{"id":"nav-item-1024dd27f9","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/data-cloud/what-is-data-cloud/"},"linkTargetContentType":"GENERIC","text":"The AI Data Cloud Explained",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/nav/nav-item"}},":type":"snowflake-site/components/nav/nav-column",":itemsOrder":["nav_item_copy_copy_2","nav_item_copy_copy_2_1314771042","nav_item_copy_copy_2_836345186","nav_item_copy_144634","nav_item_copy_copy_2_1262881566"]},"nav_column_1298824870":{"additionalClasses":"column2","navColumnTitle":"Workloads","numberOfSubColumns":"two-columns","layout":"SIMPLE","accessibilityLabel":"column2","roleAttribute":"column2","id":"container-d16c5d479c",":items":{"nav_item_copy_copy_2":{"id":"nav-item-08e21013bc","propertiesId":"blueIcon","linkDescription":"LLMs and ML models customized with your data","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/data-cloud/workloads/ai-ml/"},"linkTargetContentType":"GENERIC","text":"AI/ML",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719963657751/nav_column_container/nav_column_1298824870/nav_item_copy_copy_2/icon.coreimg.svg/1722381577565/ai-ml-icon-test-white.svg","lazyEnabled":true,"alt":" ",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_copy":{"id":"nav-item-1845450ded","propertiesId":"blueIcon_1","linkDescription":"Easy building, distribution and scaling for applications","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/data-cloud/workloads/applications/"},"linkTargetContentType":"GENERIC","text":"Applications",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719963657751/nav_column_container/nav_column_1298824870/nav_item_copy_copy/icon.coreimg.svg/1722381592801/app-icon-test-white.svg","lazyEnabled":true,"alt":" ",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_1075397000_":{"id":"nav-item-3604d60c39","propertiesId":"blueIcon_2","linkDescription":"Sharing and monetizing data, apps and AI products across clouds","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/data-cloud/workloads/collaboration/"},"linkTargetContentType":"GENERIC","text":"Collaboration",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719963657751/nav_column_container/nav_column_1298824870/nav_item_1075397000_/icon.coreimg.svg/1722381601583/collaboration-white.svg","lazyEnabled":true,"alt":"alt",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_1075397000":{"id":"nav-item-3d273f085b","propertiesId":"blueIcon_3","linkDescription":"Powerful streaming and batch data pipeline building in SQL or Python","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/data-cloud/workloads/data-engineering/"},"linkTargetContentType":"GENERIC","text":"Data Engineering",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719963657751/nav_column_container/nav_column_1298824870/nav_item_1075397000/icon.coreimg.svg/1726173758239/data-engineering-white.svg","lazyEnabled":true,"alt":"alt",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_copy_2_1529736698":{"id":"nav-item-1df640c3d0","propertiesId":"blueIcon_4","linkDescription":"Flexible architecture patterns with interoperable storage","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/data-cloud/workloads/data-lake/"},"linkTargetContentType":"GENERIC","text":"Data Lake",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719963657751/nav_column_container/nav_column_1298824870/nav_item_copy_copy_2_1529736698/icon.coreimg.svg/1726173781068/data-lake-white.svg","lazyEnabled":true,"alt":" ",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_copy_2_1480293626":{"id":"nav-item-2c43edc7c7","propertiesId":"blueIcon_5","linkDescription":"Faster data analytics at an optimized cost","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/data-cloud/workloads/data-warehouse/"},"linkTargetContentType":"GENERIC","text":"Data Warehouse",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719963657751/nav_column_container/nav_column_1298824870/nav_item_copy_copy_2_1480293626/icon.coreimg.svg/1726173764437/data-warehouse-white.svg","lazyEnabled":true,"alt":" ",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item":{"id":"nav-item-8ea63b4b0d","propertiesId":"blueIcon_6","linkDescription":"Transactional and analytical data in one place","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/data-cloud/workloads/unistore/"},"linkTargetContentType":"GENERIC","text":"Unistore",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719963657751/nav_column_container/nav_column_1298824870/nav_item/icon.coreimg.svg/1722381639388/unistore-white.svg","lazyEnabled":true,"alt":" ",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_1278622853":{"id":"nav-item-3968b05f2f",":type":"snowflake-site/components/nav/nav-item"}},":type":"snowflake-site/components/nav/nav-column",":itemsOrder":["nav_item_copy_copy_2","nav_item_copy_copy","nav_item_1075397000_","nav_item_1075397000","nav_item_copy_copy_2_1529736698","nav_item_copy_copy_2_1480293626","nav_item","nav_item_1278622853"]},"nav_column_copy_copy":{"navColumnTitle":"Featured Capabilities","numberOfSubColumns":"two-columns","layout":"SIMPLE","id":"container-62293b86c3",":items":{"nav_item":{"id":"nav-item-4c59e08f3a","propertiesId":"testID","linkDescription":"Instant access to industry-leading LLMs","flag":"new","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/data-cloud/cortex/"},"linkTargetContentType":"GENERIC","text":"Cortex AI",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719963657751/nav_column_container/nav_column_copy_copy/nav_item/icon.coreimg.svg/1722382070714/nav-icon--cortex.svg","lazyEnabled":true,"alt":"Snowflake Cortex logo",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_1855651246":{"id":"nav-item-c2c840b80c","linkDescription":"Privacy-preserving data collaboration","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/data-cloud/workloads/collaboration/data-clean-rooms/"},"linkTargetContentType":"GENERIC","text":"Data Clean Rooms",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719963657751/nav_column_container/nav_column_copy_copy/nav_item_copy_1855651246/icon.coreimg.svg/1722382080324/nav-icon--data-clean-rooms.svg","lazyEnabled":true,"alt":"Snowflake Data Clean Rooms logo",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy":{"id":"nav-item-5f2d32bada","additionalClasses":"is-light-gray-icon","linkDescription":"Built-in compliance, security, privacy and access","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/data-cloud/horizon/"},"linkTargetContentType":"GENERIC","text":"Horizon",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719963657751/nav_column_container/nav_column_copy_copy/nav_item_copy/icon.coreimg.svg/1722382091360/nav-icon--horizon.svg","lazyEnabled":true,"alt":"Snowflake Horizon logo",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_660590635":{"id":"nav-item-4d779ec73c","linkDescription":"Third-party data and AI products for trial and purchase","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/data-cloud/marketplace/"},"linkTargetContentType":"GENERIC","text":"Marketplace",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719963657751/nav_column_container/nav_column_copy_copy/nav_item_copy_660590635/icon.coreimg.svg/1722382106118/nav-icon--marketplace.svg","lazyEnabled":true,"alt":"Snowflake Marketplace logo",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_258535199":{"id":"nav-item-20be3017c1","propertiesId":"workload-nav-1","linkDescription":"End-to-end, Snowflake-native app creation and distribution","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/data-cloud/workloads/applications/native-apps/"},"linkTargetContentType":"GENERIC","text":"Native Apps",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719963657751/nav_column_container/nav_column_copy_copy/nav_item_258535199/icon.coreimg.svg/1722382116446/nav-icon--native-apps.svg","lazyEnabled":true,"alt":"Snowflake Native Apps icon",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_660590_2121336733":{"id":"nav-item-892d8dd7b3","linkDescription":"Interactive dev environment for data and AI teams","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/data-cloud/notebooks/"},"linkTargetContentType":"GENERIC","text":"Notebooks",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719963657751/nav_column_container/nav_column_copy_copy/nav_item_copy_660590_2121336733/icon.coreimg.svg/1722382125601/nav-icon--notebooks.svg","lazyEnabled":true,"alt":"Notebooks icon",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_660590_63048622":{"id":"nav-item-c81dca74cb","linkDescription":"Libraries and code execution environments that run Python and more","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/data-cloud/snowpark/"},"linkTargetContentType":"GENERIC","text":"Snowpark",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719963657751/nav_column_container/nav_column_copy_copy/nav_item_copy_660590_63048622/icon.coreimg.svg/1722382145916/nav-icon--snowpark.svg","lazyEnabled":true,"alt":"Snowflake Snowpark logo",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_660590_983061516":{"id":"nav-item-d8316ee84c","linkDescription":"Framework for transforming Python scripts into web apps","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/data-cloud/overview/streamlit-in-snowflake/"},"linkTargetContentType":"GENERIC","text":"Streamlit",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719963657751/nav_column_container/nav_column_copy_copy/nav_item_copy_660590_983061516/icon.coreimg.svg/1722382154845/nav-icon--streamlit.svg","lazyEnabled":true,"alt":"Streamlit in Snowflake logo",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_511717659":{"id":"nav-item-fd16f9860e","propertiesId":"arcticNavItem","linkDescription":"An open, efficient LLM for enterprise AI apps","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/data-cloud/arctic/"},"linkTargetContentType":"GENERIC","text":"Arctic LLM",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719963657751/nav_column_container/nav_column_copy_copy/nav_item_511717659/icon.coreimg.svg/1725034992086/nav-icon--ai-llm.svg","lazyEnabled":true,"alt":"AI icon",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_41538387":{"id":"nav-item-d30d1ced59","propertiesId":"polarisNavItem","linkDescription":"Manage and govern data across many engines and storage locations","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/data-cloud/polaris-catalog/"},"linkTargetContentType":"GENERIC","text":"Apache Polaris",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719963657751/nav_column_container/nav_column_copy_copy/nav_item_41538387/icon.coreimg.svg/1725035167676/nav-icon--polaris-catalog.svg","lazyEnabled":true,"alt":"Apache Polaris logo",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"}},":type":"snowflake-site/components/nav/nav-column",":itemsOrder":["nav_item","nav_item_copy_1855651246","nav_item_copy","nav_item_copy_660590635","nav_item_258535199","nav_item_copy_660590_2121336733","nav_item_copy_660590_63048622","nav_item_copy_660590_983061516","nav_item_511717659","nav_item_41538387"]}},":type":"snowflake-site/components/nav/nav-column/nav-column-container",":itemsOrder":["nav_column","nav_column_1298824870","nav_column_copy_copy"]},":type":"snowflake-site/components/nav/nav-dropdown-menu","cq:panelTitle":"Platform"},"nav_dropdown_menu_2":{"id":"nav-dropdown-menu-c04b84b079","enableDropdown":true,"nav_column_container":{"layout":"SIMPLE","id":"container-c8f5bdbaff",":items":{"nav_column":{"navColumnTitle":"INDUSTRIES","numberOfSubColumns":"one-column","minWidth":"280","layout":"SIMPLE","id":"container-2da7bfcbb4",":items":{"nav_item":{"id":"nav-item-6abfd694af","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/solutions/industries/advertising-media-entertainment/"},"linkTargetContentType":"GENERIC","text":"Advertising, Media & Entertainment",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy":{"id":"nav-item-47d9f9fc0a","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/solutions/industries/financial-services/"},"linkTargetContentType":"GENERIC","text":"Financial Services",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_1970515619":{"id":"nav-item-5548c81c79","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/solutions/industries/healthcare-and-life-sciences/"},"linkTargetContentType":"GENERIC","text":"Healthcare & Life Sciences",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_1533429516":{"id":"nav-item-d9034a534b","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/solutions/industries/manufacturing/"},"linkTargetContentType":"GENERIC","text":"Manufacturing",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_1444458226":{"id":"nav-item-29e8219de2","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/solutions/industries/public-sector/"},"linkTargetContentType":"GENERIC","text":"Public Sector",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_1149488919":{"id":"nav-item-e04d95af93","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/solutions/industries/retail-consumer-goods/"},"linkTargetContentType":"GENERIC","text":"Retail & Consumer Goods",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_57417040":{"id":"nav-item-8916f883ac","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/solutions/industries/technology/"},"linkTargetContentType":"GENERIC","text":"Technology",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_361384674":{"id":"nav-item-072f801919","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/solutions/industries/telecom/"},"linkTargetContentType":"GENERIC","text":"Telecom",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_361384":{"id":"nav-item-ee62140dea","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/solutions/industries/travel-hospitality/"},"linkTargetContentType":"GENERIC","text":"Travel & Hospitality",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},":type":"snowflake-site/components/nav/nav-item"}},":type":"snowflake-site/components/nav/nav-column","appliedCssClassNames":"snowflake-responsive-container-inner-padding-extra-small",":itemsOrder":["nav_item","nav_item_copy","nav_item_copy_1970515619","nav_item_copy_1533429516","nav_item_copy_1444458226","nav_item_copy_1149488919","nav_item_copy_57417040","nav_item_copy_361384674","nav_item_copy_361384"]},"nav_column_copy":{"navColumnTitle":"DEPARTMENTS","numberOfSubColumns":"one-column","minWidth":"160","layout":"SIMPLE","id":"container-a55e189762",":items":{"nav_item":{"id":"nav-item-18045eaba7","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/solutions/departments/finance/"},"linkTargetContentType":"GENERIC","text":"Finance",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy":{"id":"nav-item-03456c1c3e","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/solutions/departments/information-technology/"},"linkTargetContentType":"GENERIC","text":"IT",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_1970515619":{"id":"nav-item-036cdbce82","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/solutions/departments/marketing/"},"linkTargetContentType":"GENERIC","text":"Marketing",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_1533429516":{"id":"nav-item-c09d2aa154","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/solutions/departments/cybersecurity/"},"linkTargetContentType":"GENERIC","text":"Cybersecurity",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/nav/nav-item"}},":type":"snowflake-site/components/nav/nav-column",":itemsOrder":["nav_item","nav_item_copy","nav_item_copy_1970515619","nav_item_copy_1533429516"]},"nav_column_833417450":{"navColumnTitle":"Enablement Solutions","numberOfSubColumns":"one-column","layout":"SIMPLE","id":"container-a28d3e3555",":items":{"nav_item_copy_107772":{"id":"nav-item-94fd2c2a9e","linkDescription":"Confident migration to a unified platform","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/migrate-to-the-cloud/"},"linkTargetContentType":"GENERIC","text":"Migrate to the AI Data Cloud",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/nav_dropdown_menu_2/nav_column_container/nav_column_833417450/nav_item_copy_107772/icon.coreimg.svg/1723828484100/nav-icon-cloud.svg","lazyEnabled":true,"alt":"Cloud icon",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_copy":{"id":"nav-item-a7da49abe1","linkDescription":"Snowflake experts to help you accelerate and achieve business goals","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/solutions/professional-services/"},"linkTargetContentType":"GENERIC","text":"Professional Services",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/nav_dropdown_menu_2/nav_column_container/nav_column_833417450/nav_item_copy_copy/icon.coreimg.svg/1723828466495/nav-icon--migrate.svg","lazyEnabled":true,"alt":"Migrate icon",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"}},":type":"snowflake-site/components/nav/nav-column",":itemsOrder":["nav_item_copy_107772","nav_item_copy_copy"]},"nav_column_copy_copy":{"navColumnTitle":"PARTNER SOLUTIONS","numberOfSubColumns":"one-column","layout":"SIMPLE","id":"container-8b2d708f0a",":items":{"nav_item":{"id":"nav-item-48f59486f3","linkDescription":"Programs with product, solutions and cloud partners","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/why-snowflake/partners/"},"linkTargetContentType":"GENERIC","text":"Snowflake Partner Network",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/nav_dropdown_menu_2/nav_column_container/nav_column_copy_copy/nav_item/icon.coreimg.svg/1723828498700/nav-icon--partner-network.svg","lazyEnabled":true,"alt":"Partner Network icon",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy":{"id":"nav-item-271fb01fa0","linkDescription":"Partners, apps and solutions for enhanced deployment","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/why-snowflake/partners/all-partners/"},"linkTargetContentType":"GENERIC","text":"Partner Finder",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/nav_dropdown_menu_2/nav_column_container/nav_column_copy_copy/nav_item_copy/icon.coreimg.svg/1726173927645/nav-icon--partner-finder.svg","lazyEnabled":true,"alt":"Partner Finder icon",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_1970515619":{"id":"nav-item-221430dcd6","linkDescription":"Live and virtual events","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/why-snowflake/partners/event-partnership-opportunities/"},"linkTargetContentType":"GENERIC","text":"Event Partnership Opportunities",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/nav_dropdown_menu_2/nav_column_container/nav_column_copy_copy/nav_item_copy_1970515619/icon.coreimg.svg/1726173935655/nav-icon--events.svg","lazyEnabled":true,"alt":"Calendar icon",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"}},":type":"snowflake-site/components/nav/nav-column",":itemsOrder":["nav_item","nav_item_copy","nav_item_copy_1970515619"]}},":type":"snowflake-site/components/nav/nav-column/nav-column-container",":itemsOrder":["nav_column","nav_column_copy","nav_column_833417450","nav_column_copy_copy"]},":type":"snowflake-site/components/nav/nav-dropdown-menu","cq:panelTitle":"Solutions"},"item_1718247184925":{"id":"nav-dropdown-menu-309b22039c","enableDropdown":false,"link_url":"/en/customers/",":type":"snowflake-site/components/nav/nav-dropdown-menu","cq:panelTitle":"Customers"},"item_1719961362824":{"id":"nav-dropdown-menu-f6ecd4c095","enableDropdown":true,"nav_column_container":{"layout":"SIMPLE","id":"container-f9061fe01c",":items":{"nav_column_copy":{"navColumnTitle":"Connect","numberOfSubColumns":"one-column","minWidth":"124","layout":"SIMPLE","id":"container-acb3c8f9c5",":items":{"nav_item":{"id":"nav-item-5651e296e3","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/blog/"},"linkTargetContentType":"GENERIC","text":"Blog",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy":{"id":"nav-item-1b20419ece","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/engineering-blog/"},"linkTargetContentType":"GENERIC","text":"Engineering Blog",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_833503282":{"id":"nav-item-9adc7c01aa","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://community.snowflake.com","attributes":{"target":"_blank"}},"linkTargetContentType":"GENERIC","text":"Community",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_180298689":{"id":"nav-item-5e2faca68a","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/about/events/"},"linkTargetContentType":"GENERIC","text":"Events",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_1639361946":{"id":"nav-item-63724ab773","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/support/"},"linkTargetContentType":"GENERIC","text":"Support",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_680912746":{"id":"nav-item-523f3a4b46","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/contact/"},"linkTargetContentType":"GENERIC","text":"Contact us",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/nav/nav-item"}},":type":"snowflake-site/components/nav/nav-column",":itemsOrder":["nav_item","nav_item_copy","nav_item_833503282","nav_item_180298689","nav_item_1639361946","nav_item_680912746"]},"nav_column_44600420_":{"navColumnTitle":"Build","numberOfSubColumns":"one-column","minWidth":"140","layout":"SIMPLE","id":"container-b85e79376f",":items":{"nav_item":{"id":"nav-item-9fc8540854","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://developers.snowflake.com/","attributes":{"target":"_blank"}},"linkTargetContentType":"GENERIC","text":"Developers",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy":{"id":"nav-item-2eddfd7538","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://docs.snowflake.com/","attributes":{"target":"_blank"}},"linkTargetContentType":"GENERIC","text":"Documentation",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_333890638":{"id":"nav-item-147ff5ff67","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://quickstarts.snowflake.com/","attributes":{"target":"_blank"}},"linkTargetContentType":"GENERIC","text":"Quickstarts",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_144634":{"id":"nav-item-d60e74765d","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://developers.snowflake.com/solutions/","attributes":{"target":"_blank"}},"linkTargetContentType":"GENERIC","text":"Solutions Center",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},":type":"snowflake-site/components/nav/nav-item"}},":type":"snowflake-site/components/nav/nav-column",":itemsOrder":["nav_item","nav_item_copy","nav_item_copy_333890638","nav_item_copy_144634"]},"nav_column_44600420__826130542":{"navColumnTitle":"Learn","numberOfSubColumns":"two-columns","layout":"SIMPLE","id":"container-2b915de82a",":items":{"nav_item_copy":{"id":"nav-item-3fa754e0ca","linkDescription":"Ebooks, podcasts, videos, white papers and more","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/resources/"},"linkTargetContentType":"GENERIC","text":"Resource Library",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719961362824/nav_column_container/nav_column_44600420__826130542/nav_item_copy/icon.coreimg.svg/1726173960290/nav-icon--notebooks.svg","lazyEnabled":true,"alt":"Notebooks icon",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item":{"id":"nav-item-0475529a02","linkDescription":"Overview of Snowflake's educational offerings","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/resources/learn/training/"},"linkTargetContentType":"GENERIC","text":"Training",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719961362824/nav_column_container/nav_column_44600420__826130542/nav_item/icon.coreimg.svg/1722382755809/nav-icon--training.svg","lazyEnabled":true,"alt":"Training icon",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_144634_1984107859":{"id":"nav-item-29580e239a","linkDescription":"Expert-led discussions and demos across industries and use cases","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/about/webinars/"},"linkTargetContentType":"GENERIC","text":"Webinars",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719961362824/nav_column_container/nav_column_44600420__826130542/nav_item_copy_144634_1984107859/icon.coreimg.svg/1722382813586/nav-icon--webinars.svg","lazyEnabled":true,"alt":"Webinars icon",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_1438098918":{"id":"nav-item-894a092f6d","linkDescription":"Snowflake's technical industry professional certifications","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/en/resources/learn/certifications/"},"linkTargetContentType":"GENERIC","text":"Certifications",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719961362824/nav_column_container/nav_column_44600420__826130542/nav_item_copy_1438098918/icon.coreimg.svg/1722382780833/nav-icon--cert.svg","lazyEnabled":true,"alt":"Certification icon",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_143809":{"id":"nav-item-c2dcfcbb08","linkDescription":"Weekly product demos showcasing key features and live Q&A ","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/live-demo/"},"linkTargetContentType":"GENERIC","text":"Live Demos",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719961362824/nav_column_container/nav_column_44600420__826130542/nav_item_copy_143809/icon.coreimg.svg/1726173969147/nav-icon--live-demo.svg","lazyEnabled":true,"alt":"Live Demo icon",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_333890638":{"id":"nav-item-b6018a6121","linkDescription":"Training courses for all levels, on-demand or instructor-led","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://learn.snowflake.com/en/","attributes":{"target":"_blank"}},"linkTargetContentType":"GENERIC","text":"Snowflake University",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719961362824/nav_column_container/nav_column_44600420__826130542/nav_item_copy_333890638/icon.coreimg.svg/1722382769808/nav-icon--education.svg","lazyEnabled":true,"alt":"Education icon",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_189945":{"id":"nav-item-957407f9b2","linkDescription":"Instructor-led virtual workshops for exploring key Snowflake features","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/virtual-hands-on-lab/"},"linkTargetContentType":"GENERIC","text":"Hands-On Labs",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_EXTERNAL"},"icon":{"id":"icon","src":"https://publish-p57963-e462109.adobeaemcloud.com/content/experience-fragments/snowflake-site/language-masters/en/site/mega-nav-header/master/_jcr_content/root/mega_header/nav_mega/item_1719961362824/nav_column_container/nav_column_44600420__826130542/nav_item_copy_189945/icon.coreimg.svg/1726173998186/nav-icon--labs.svg","lazyEnabled":true,"alt":"Hands-on Labs icon",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"}},":type":"snowflake-site/components/nav/nav-column",":itemsOrder":["nav_item_copy","nav_item","nav_item_copy_144634_1984107859","nav_item_copy_1438098918","nav_item_copy_143809","nav_item_copy_333890638","nav_item_copy_189945"]}},":type":"snowflake-site/components/nav/nav-column/nav-column-container",":itemsOrder":["nav_column_copy","nav_column_44600420_","nav_column_44600420__826130542"]},"nav_promo_section":{"id":"nav-promo-section-93f15fa159","experience_fragment_1":{"id":"experiencefragment-b204335ef2","configured":true,"localizedFragmentVariationPath":"/content/experience-fragments/snowflake-site/language-masters/en/site/nav-promo-card/master/jcr:content",":items":{"root":{"layout":"RESPONSIVE_GRID","columnCount":12,"gridClassNames":"aem-Grid aem-Grid--12 aem-Grid--default--12","columnClassNames":{"nav_promo_card":"aem-GridColumn aem-GridColumn--default--12"},"id":"container-a5461f9a61",":items":{"nav_promo_card":{"id":"nav-promo-card-84b091856e","openInNewWindow":true,"layout":"horizontal","headline":"Snowflake World Tour","description":"Explore the latest advancements in enterprise AI and app development at one of 23 Snowflake World Tour stops","linkTitle":"Learn More","linkUrl":"/en/nav-promos/snowflake-world-tour/","image":{"id":"image","src":"https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--ea2ecb5f-b441-4ea4-a2ef-f45401e2f70f/snowflake-world-tour%402x.jpg?preferwebp=true&quality=85","lazyEnabled":true,"srcset":"https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--ea2ecb5f-b441-4ea4-a2ef-f45401e2f70f/snowflake-world-tour%402x.jpg?width=320&preferwebp=true&quality=85 320w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--ea2ecb5f-b441-4ea4-a2ef-f45401e2f70f/snowflake-world-tour%402x.jpg?width=480&preferwebp=true&quality=85 480w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--ea2ecb5f-b441-4ea4-a2ef-f45401e2f70f/snowflake-world-tour%402x.jpg?width=640&preferwebp=true&quality=85 640w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--ea2ecb5f-b441-4ea4-a2ef-f45401e2f70f/snowflake-world-tour%402x.jpg?width=768&preferwebp=true&quality=85 768w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--ea2ecb5f-b441-4ea4-a2ef-f45401e2f70f/snowflake-world-tour%402x.jpg?width=960&preferwebp=true&quality=85 960w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--ea2ecb5f-b441-4ea4-a2ef-f45401e2f70f/snowflake-world-tour%402x.jpg?width=1200&preferwebp=true&quality=85 1200w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--ea2ecb5f-b441-4ea4-a2ef-f45401e2f70f/snowflake-world-tour%402x.jpg?width=1440&preferwebp=true&quality=85 1440w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--ea2ecb5f-b441-4ea4-a2ef-f45401e2f70f/snowflake-world-tour%402x.jpg?width=1920&preferwebp=true&quality=85 1920w","alt":"alt",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-promo-card"}},":type":"snowflake-site/components/container",":itemsOrder":["nav_promo_card"]}},":type":"snowflake-site/components/experiencefragment",":itemsOrder":["root"],"classNames":"aem-xf"},"experience_fragment_2":{"id":"experiencefragment-19fb760dff","configured":true,"localizedFragmentVariationPath":"/content/experience-fragments/snowflake-site/language-masters/en/site/nav-promo-card/navigation-promo-card-2/jcr:content",":items":{"root":{"layout":"RESPONSIVE_GRID","columnCount":12,"gridClassNames":"aem-Grid aem-Grid--12 aem-Grid--default--12","columnClassNames":{"nav_promo_card":"aem-GridColumn aem-GridColumn--default--12"},"id":"container-3bfb6a1de0",":items":{"nav_promo_card":{"id":"nav-promo-card-54269d54c7","openInNewWindow":true,"layout":"horizontal","headline":"The Data Executive's Guide to Effective AI","description":"Best practices from data executives to start your AI transformation journey","linkTitle":"Learn More","linkUrl":"/en/nav-promos/data-execs-guide-to-ai/","image":{"id":"image","src":"https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--6a6ddad3-d95b-4476-a895-58072d6c50e1/data-exec-guide-v2%402x.png?preferwebp=true&quality=85","lazyEnabled":true,"srcset":"https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--6a6ddad3-d95b-4476-a895-58072d6c50e1/data-exec-guide-v2%402x.png?width=320&preferwebp=true&quality=85 320w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--6a6ddad3-d95b-4476-a895-58072d6c50e1/data-exec-guide-v2%402x.png?width=480&preferwebp=true&quality=85 480w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--6a6ddad3-d95b-4476-a895-58072d6c50e1/data-exec-guide-v2%402x.png?width=640&preferwebp=true&quality=85 640w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--6a6ddad3-d95b-4476-a895-58072d6c50e1/data-exec-guide-v2%402x.png?width=768&preferwebp=true&quality=85 768w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--6a6ddad3-d95b-4476-a895-58072d6c50e1/data-exec-guide-v2%402x.png?width=960&preferwebp=true&quality=85 960w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--6a6ddad3-d95b-4476-a895-58072d6c50e1/data-exec-guide-v2%402x.png?width=1200&preferwebp=true&quality=85 1200w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--6a6ddad3-d95b-4476-a895-58072d6c50e1/data-exec-guide-v2%402x.png?width=1440&preferwebp=true&quality=85 1440w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--6a6ddad3-d95b-4476-a895-58072d6c50e1/data-exec-guide-v2%402x.png?width=1920&preferwebp=true&quality=85 1920w","alt":"Composite illustration from the PDF cover of Snowflake's 'The Data Executive's Guide to Effective AI' ebook",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-promo-card"}},":type":"snowflake-site/components/container",":itemsOrder":["nav_promo_card"]}},":type":"snowflake-site/components/experiencefragment",":itemsOrder":["root"],"classNames":"aem-xf"},"experience_fragment_3":{"id":"experiencefragment-362605ea3d","configured":true,"localizedFragmentVariationPath":"/content/experience-fragments/snowflake-site/language-masters/en/site/nav-promo-card/navigation-promo-card-3/jcr:content",":items":{"root":{"layout":"RESPONSIVE_GRID","columnCount":12,"gridClassNames":"aem-Grid aem-Grid--12 aem-Grid--default--12","columnClassNames":{"nav_promo_card":"aem-GridColumn aem-GridColumn--default--12"},"id":"container-35bb0bae84",":items":{"nav_promo_card":{"id":"nav-promo-card-5a31a0bcb9","openInNewWindow":true,"layout":"horizontal","headline":"Data Trends 2024 Report","description":"Discover how leading enterprises are building the foundation for advanced AI in this free eBook","linkTitle":"Find an event near you","linkUrl":"/en/nav-promos/data-trends-report-2024/","image":{"id":"image","src":"https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--0d6872c4-1afb-473f-afdc-c9ee9fd9e691/data-trends-2024%402x.jpg?preferwebp=true&quality=85","lazyEnabled":true,"srcset":"https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--0d6872c4-1afb-473f-afdc-c9ee9fd9e691/data-trends-2024%402x.jpg?width=320&preferwebp=true&quality=85 320w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--0d6872c4-1afb-473f-afdc-c9ee9fd9e691/data-trends-2024%402x.jpg?width=480&preferwebp=true&quality=85 480w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--0d6872c4-1afb-473f-afdc-c9ee9fd9e691/data-trends-2024%402x.jpg?width=640&preferwebp=true&quality=85 640w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--0d6872c4-1afb-473f-afdc-c9ee9fd9e691/data-trends-2024%402x.jpg?width=768&preferwebp=true&quality=85 768w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--0d6872c4-1afb-473f-afdc-c9ee9fd9e691/data-trends-2024%402x.jpg?width=960&preferwebp=true&quality=85 960w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--0d6872c4-1afb-473f-afdc-c9ee9fd9e691/data-trends-2024%402x.jpg?width=1200&preferwebp=true&quality=85 1200w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--0d6872c4-1afb-473f-afdc-c9ee9fd9e691/data-trends-2024%402x.jpg?width=1440&preferwebp=true&quality=85 1440w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--0d6872c4-1afb-473f-afdc-c9ee9fd9e691/data-trends-2024%402x.jpg?width=1920&preferwebp=true&quality=85 1920w","alt":"alt",":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-promo-card"}},":type":"snowflake-site/components/container",":itemsOrder":["nav_promo_card"]}},":type":"snowflake-site/components/experiencefragment",":itemsOrder":["root"],"classNames":"aem-xf"},":type":"snowflake-site/components/nav/nav-promo-section"},":type":"snowflake-site/components/nav/nav-dropdown-menu","cq:panelTitle":"Resources"},"item_1718247180324":{"id":"nav-dropdown-menu-74f4bfff53","enableDropdown":false,"link_url":"/en/data-cloud/pricing-options/",":type":"snowflake-site/components/nav/nav-dropdown-menu","cq:panelTitle":"Pricing"}},":itemsOrder":["item_1719963657751","nav_dropdown_menu_2","item_1718247184925","item_1719961362824","item_1718247180324"]},"languagenavigation":{"id":"languagenavigation-24d93c7f20","items":[{"id":"languagenavigation-24d93c7f20-item-c926448afd","path":"/content/snowflake-site/global/en/blog/custom-sql-now-supported-in-the-snowflake-connector-for-power-bi","link":{"valid":true,"url":"/en/blog/custom-sql-now-supported-in-the-snowflake-connector-for-power-bi/"},"children":[],"level":0,"active":true,"current":true,"title":"English","locale":"en","country":"","language":"en","lastModified":1726133108606,"description":"Learn how Custom SQL Support unlocks time savings, flexibility, and various new capabilities for Power BI and Snowflake users.",":type":"snowflake-site/components/structure/blog-page"},{"id":"languagenavigation-24d93c7f20-item-82817d8a5f","path":"/content/snowflake-site/global/pt_br","link":{"valid":true,"url":"/pt_br/"},"children":[],"level":0,"active":false,"current":false,"title":"Português","locale":"pt_BR","country":"BR","language":"pt-BR","lastModified":1725390362900,"description":"Junte-se ao Snowflake Data Cloud, uma rede global que ajuda milhares de empresas a colaborar, ativar cargas de trabalho diversas e criar aplicativos de dados.",":type":"snowflake-site/components/structure/page"},{"id":"languagenavigation-24d93c7f20-item-4a811195e3","path":"/content/snowflake-site/global/it","link":{"valid":true,"url":"/it/"},"children":[],"level":0,"active":false,"current":false,"title":"Italiano","locale":"it","country":"","language":"it","lastModified":1726527229622,"description":"Entra nel Data Cloud di Snowflake, la rete globale che consente a migliaia di organizzazioni di collaborare, eseguire workload diversificati e creare data app.",":type":"snowflake-site/components/structure/page"},{"id":"languagenavigation-24d93c7f20-item-6486f44734","path":"/content/snowflake-site/global/ko","link":{"valid":true,"url":"/ko/"},"children":[],"level":0,"active":false,"current":false,"title":"한국어","locale":"ko","country":"","language":"ko","lastModified":1725645817536,"description":"많은 조직의 협업과 다양한 워크로드, 데이터 애플리케이션 구축을 지원하는 Snowflake 데이터 클라우드의 글로벌 네트워크에 참여하세요.",":type":"snowflake-site/components/structure/page"},{"id":"languagenavigation-24d93c7f20-item-decf4bc074","path":"/content/snowflake-site/global/ja/blog/custom-sql-now-supported-in-the-snowflake-connector-for-power-bi","link":{"valid":true,"url":"/ja/blog/custom-sql-now-supported-in-the-snowflake-connector-for-power-bi/"},"children":[],"level":0,"active":false,"current":false,"title":"日本語","locale":"ja","country":"","language":"ja","lastModified":1653666165000,":type":"snowflake-site/components/structure/blog-page"},{"id":"languagenavigation-24d93c7f20-item-975791adbc","path":"/content/snowflake-site/global/es","link":{"valid":true,"url":"/es/"},"children":[],"level":0,"active":false,"current":false,"title":"Español","locale":"es","country":"","language":"es","lastModified":1726527061264,"description":"Únete a Snowflake Data Cloud, una red global que permite a miles de organizaciones colaborar, potenciar diversos workloads y crear aplicaciones de datos.",":type":"snowflake-site/components/structure/page"},{"id":"languagenavigation-24d93c7f20-item-086a1ac238","path":"/content/snowflake-site/global/de","link":{"valid":true,"url":"/de/"},"children":[],"level":0,"active":false,"current":false,"title":"Deutsch","locale":"de","country":"","language":"de","lastModified":1726527127054,"description":"Werden Sie Teil der Snowflake Data Cloud, einem globalen Unternehmensnetzwerk für Zusammenarbeit, vielfältige Workloads und Datenapplikationen.",":type":"snowflake-site/components/structure/page"},{"id":"languagenavigation-24d93c7f20-item-cb93a03c0a","path":"/content/snowflake-site/global/fr","link":{"valid":true,"url":"/fr/"},"children":[],"level":0,"active":false,"current":false,"title":"Français","locale":"fr","country":"","language":"fr","lastModified":1726777947111,"description":"Rejoignez le Data Cloud Snowflake, un réseau mondial où des milliers d’entreprises peuvent collaborer, gérer divers workloads et créer des applications de données.",":type":"snowflake-site/components/structure/page"}],":type":"snowflake-site/components/languagenavigation"},"button":{"id":"button-4e0cc911c7","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/contact/"},"linkTargetContentType":"GENERIC","text":"CONTACT",":type":"snowflake-site/components/button","appliedCssClassNames":"snowflake-button-secondary snowflake-button-blue snowflake-button-compact","linkType":"SNOWFLAKE_EXTERNAL"},"button_288358396":{"id":"button-350129d0b1","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://signup.snowflake.com/?utm_cta=trial-en-www-homepage-top-right-nav-ss-evg&_ga=2.74406678.547897382.1657561304-1006975775.1656432605&_gac=1.254279162.1656541671.Cj0KCQjw8O-VBhCpARIsACMvVLPE7vSFoPt6gqlowxPDlHT6waZ2_Kd3-4926XLVs0QvlzvTvIKg7pgaAqd2EALw_wcB"},"linkTargetContentType":"GENERIC","text":"start for free",":type":"snowflake-site/components/button","appliedCssClassNames":"snowflake-button-primary snowflake-button-blue snowflake-button-compact","linkType":"SNOWFLAKE_EXTERNAL"}},":type":"snowflake-site/components/mega-header","appliedCssClassNames":"snowflake-header-container white",":itemsOrder":["nav_mega","languagenavigation","button","button_288358396"]}},":type":"snowflake-site/components/container",":itemsOrder":["markup_editor","mega_header"]}},":type":"snowflake-site/components/experiencefragment",":itemsOrder":["root"],"classNames":"aem-xf"},"experiencefragment-sub-header":{"id":"experiencefragment-81249c3bb6","configured":true,"localizedFragmentVariationPath":"/content/experience-fragments/snowflake-site/language-masters/en/site/sub-navigation/master/jcr:content",":items":{"root":{"layout":"RESPONSIVE_GRID","columnCount":12,"gridClassNames":"aem-Grid aem-Grid--12 aem-Grid--default--12","columnClassNames":{"sub_navigation":"aem-GridColumn aem-GridColumn--default--12"},"id":"container-1e4fe219f5",":items":{"sub_navigation":{"id":"sub-navigation-fafe55e6d8","enableProgressBar":true,"dropdownTitle":"Category","primaryLink":{"id":"primary-link","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/blog/"},"linkTargetContentType":"GENERIC","text":"BLOG",":type":"snowflake-site/components/button","linkType":"SNOWFLAKE_INTERNAL"},"subNavigationItems":[{"pageTitle":"AI/ML","pagePath":"/en/blog/category/ai-ml/"},{"pageTitle":"At Snowflake","pagePath":"/en/blog/category/company/"},{"pageTitle":"Partner & Customer Value","pagePath":"/en/blog/category/customer-value/"},{"pageTitle":"Industry Solutions","pagePath":"/en/blog/category/industry-solutions/"},{"pageTitle":"Product & Technology","pagePath":"/en/blog/category/product-and-technology/"},{"pageTitle":"Strategy & Insights","pagePath":"/en/blog/category/thought-leadership/"}],":type":"snowflake-site/components/blog/sub-navigation"}},":type":"snowflake-site/components/container",":itemsOrder":["sub_navigation"]},"cq:metadata":{":type":"nt:unstructured"}},":type":"snowflake-site/components/experiencefragment",":itemsOrder":["root","cq:metadata"],"classNames":"aem-xf"},"responsivegrid":{"columnCount":12,"gridClassNames":"aem-Grid aem-Grid--12 aem-Grid--default--12","columnClassNames":{"container":"aem-GridColumn aem-GridColumn--default--12","blog_hero":"aem-GridColumn aem-GridColumn--default--12"},":items":{"blog_hero":{"id":"blog-hero-5dcccf04ce","tag":{"tagText":"AI & ML","tagColor":"#C54985"},"title":{"lines":["Custom SQL Now Supported in the Snowflake Connector for Power BI!"],"type":"heading2",":type":"snowflake-site/components/title-v2"},"image":{"id":"image-82661f1880","src":"https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--0c513aa6-ae7b-434e-ac57-69699bbb1225/new-custom-sql.jpg?preferwebp=true&quality=85","lazyEnabled":true,"srcset":"https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--0c513aa6-ae7b-434e-ac57-69699bbb1225/new-custom-sql.jpg?width=320&preferwebp=true&quality=85 320w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--0c513aa6-ae7b-434e-ac57-69699bbb1225/new-custom-sql.jpg?width=480&preferwebp=true&quality=85 480w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--0c513aa6-ae7b-434e-ac57-69699bbb1225/new-custom-sql.jpg?width=640&preferwebp=true&quality=85 640w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--0c513aa6-ae7b-434e-ac57-69699bbb1225/new-custom-sql.jpg?width=768&preferwebp=true&quality=85 768w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--0c513aa6-ae7b-434e-ac57-69699bbb1225/new-custom-sql.jpg?width=960&preferwebp=true&quality=85 960w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--0c513aa6-ae7b-434e-ac57-69699bbb1225/new-custom-sql.jpg?width=1200&preferwebp=true&quality=85 1200w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--0c513aa6-ae7b-434e-ac57-69699bbb1225/new-custom-sql.jpg?width=1440&preferwebp=true&quality=85 1440w,https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--0c513aa6-ae7b-434e-ac57-69699bbb1225/new-custom-sql.jpg?width=1920&preferwebp=true&quality=85 1920w","alt":"Custom SQL Now Supported in the Snowflake Connector for Power BI!",":type":"snowflake-site/components/image"},"publicationDate":"SEP 02, 2021",":type":"snowflake-site/components/blog/blog-hero"},"container":{"layout":"RESPONSIVE_GRID","columnCount":12,"gridClassNames":"aem-Grid aem-Grid--12 aem-Grid--default--12","columnClassNames":{"flexible_column_cont":"aem-GridColumn aem-GridColumn--default--12","related_content":"aem-GridColumn aem-GridColumn--default--12"},"id":"container-d34e7d1470",":items":{"flexible_column_cont":{"id":"flexible-column-container-17023228f1","propertiesId":"snowflake-blog-template-main-container","type":"2-column-60-40","alignColumns":"top","containerMaxWidth":"extra-large","topPadding":"small","bottomPadding":"small","spaceBetween":"small","reverseOnMobile":true,"carouselOnMobile":false,"backgroundImageOption":"none","flexible_column_content_container_1":{"layout":"SIMPLE","id":"container-81b0fbc0ff",":items":{"blog_text_1":{"id":"blog-text-081ff56db3","text":"

As the adoption of the Snowflake Data Cloud and Power BI continues to gain momentum across all business and vertical markets, it’s important that the capabilities, user experience, and integration of Snowflake and Power BI continue to evolve to provide best-in-class experiences to our users. To this end, Snowflake and Microsoft have developed a strong partnership focused on listening to our mutual community of users and delivering the capabilities they demand to achieve productivity, flexibility, and agility when using our platforms.

The most recent success of the partnership between the Snowflake and Power BI teams is the release of the highly requested feature, Custom SQL Support for the Snowflake Connector. This exciting new capability is available now in the latest version of Power BI! Custom SQL Support unlocks time savings, flexibility, and various new capabilities for Power BI and Snowflake users, enhancing their productivity and effectiveness. Additionally, Custom SQL is supported in both DirectQuery and Import modes, further enhancing your team’s ability to customize your data models to accommodate business needs.

","richText":true,":type":"snowflake-site/components/blog/blog-text"},"title_v2_1":{"id":"title-v2-ecbb512246","type":"heading3","lines":["Some of the Benefits of Custom SQL Support in Snowflake Connector for Power BI"],":type":"snowflake-site/components/title-v2","appliedCssClassNames":"left-alignment"},"blog_text_2":{"id":"blog-text-7e972986a0","text":"

Custom SQL Support for the Snowflake Connector unlocks new capabilities, including:

Enhanced Ability to Leverage the Power of Snowflake! With Snowflake’s near-infinitely scalable compute, you’ll want to perform the heavy lifting of your query operations in Snowflake when possible (rather than the Power BI service). Custom SQL allows you to write queries that will be executed directly in Snowflake.

Streamlined Migrations. If you are currently using a data source that supports Custom SQL, you can simply migrate that SQL to the Snowflake Connector, significantly reducing the time and effort required to migrate to Snowflake.

Query Folding. Query folding is the ability for a Power Query to generate a single query statement to retrieve and transform source data. I could write an entire post on the benefits of query folding, but for now the important item to note is that Custom SQL enables query folding for Snowflake, which could result in more-efficient operations in Power BI. Query folding results in SQL execution being pushed back to the database (Snowflake) for execution.

Simplify Complex Transformations. Power Query is a very powerful tool for transforming data sets in Power BI; however, some complex SQL operations are difficult or impossible to perform in Power Query. Custom SQL enables the power of Snowflake SQL directly in Power BI.

Greater Flexibility for Analysts and Business Users. Users with limited access to database objects can now use Custom SQL to perform joins, unions, and so on, while (as mentioned above) leveraging the power of Snowflake to perform the operation rather than the Power BI service.

Greater Flexibility Adding Custom Columns. Adding custom columns using Custom SQL is particularly important to overcome limitations of DAX in DirectQuery mode and also removes potential overhead of calculations performed in the Power BI service. 

","richText":true,":type":"snowflake-site/components/blog/blog-text"},"title_v2_2":{"id":"title-v2-5cad0647d4","type":"heading3","lines":["Getting Started with Custom SQL in the Snowflake Connector for Power BI"],":type":"snowflake-site/components/title-v2","appliedCssClassNames":"left-alignment"},"title_v2_3":{"id":"title-v2-23b73ad23b","type":"heading4","lines":["Solution Overview"],":type":"snowflake-site/components/title-v2","appliedCssClassNames":"left-alignment"},"blog_text_3":{"id":"blog-text-740b8cbb38","text":"

To implement this solution, you’ll complete the following high-level steps:

  1. Confirm you’re using the latest version of Power BI (or download the latest June 2021 release).
  2. Connect to Snowflake using Snowflake Connector for Power BI.
","richText":true,":type":"snowflake-site/components/blog/blog-text"},"title_v2_4":{"id":"title-v2-4587d0a94d","type":"heading4","lines":["Architecture"],":type":"snowflake-site/components/title-v2","appliedCssClassNames":"left-alignment"},"markup_editor_external_image_1":{"id":"markup-editor-dd60575b05","title":"External image (1)","htmlContent":"
\n
\n cmp-image__image\\\n
\n
",":type":"snowflake-site/components/markup-editor"},"title_v2_5":{"id":"title-v2-07528cb48f","type":"heading4","lines":["Prerequisites"],":type":"snowflake-site/components/title-v2","appliedCssClassNames":"left-alignment"},"blog_text_4":{"id":"blog-text-419cf1b6a5","text":"

Before starting this walkthrough, you must have the following:

  • The latest version of Power BI (June 2021 release). You may download the latest version here.  
  • A Snowflake account. If you do not have one, please register for a free 30-day trial account at trial.snowflake.com.
","richText":true,":type":"snowflake-site/components/blog/blog-text"},"title_v2_6":{"id":"title-v2-3a7636a265","type":"heading4","lines":["Confirm You’re Using the Latest Version of Power BI"],":type":"snowflake-site/components/title-v2","appliedCssClassNames":"left-alignment"},"blog_text_5":{"id":"blog-text-26858b2434","text":"

To confirm you’re using the latest version of Power BI Desktop, click the Help menu item and then the About option. You’ll see the version name, which should indicate June 2021 (or later).

","richText":true,":type":"snowflake-site/components/blog/blog-text"},"markup_editor_external_image_2":{"id":"markup-editor-6a4928e2d9","title":"External image (2)","htmlContent":"
\n
\n cmp-image__image\\\n
\n
",":type":"snowflake-site/components/markup-editor"},"title_v2_7":{"id":"title-v2-f565c3f497","type":"heading4","lines":["Connect to Snowflake Using Snowflake Connector for Power BI"],":type":"snowflake-site/components/title-v2","appliedCssClassNames":"left-alignment"},"blog_text_6":{"id":"blog-text-79ceca10fb","text":"

In this release, the connector currently requires a fully qualified table name (DATABASENAME.SCHEMANAME.TABLENAME) in the query, and the database name field is required (even though the UI describes the field as optional). The Microsoft Power BI Team is working on continuing to improve and streamline the user experience.

To configure Power BI, complete the following steps:

1. Select Get Data from the menu, and then find the Snowflake Connector.

Tip: Type “Snowflake” in the search box to quickly find the Snowflake Connector.

","richText":true,":type":"snowflake-site/components/blog/blog-text"},"markup_editor_external_image_3":{"id":"markup-editor-4a91a77e2f","title":"External image (3)","htmlContent":"
\n
\n cmp-image__image\\\n
\n
",":type":"snowflake-site/components/markup-editor"},"blog_text_7":{"id":"blog-text-db70c329ba","text":"

2. Enter your server (Snowflake account URL), the Snowflake Warehouse, the Snowflake Role, and the Snowflake Database. Please note, the text currently says “(optional),” but the database name is currently required. Finally, add your SQL statement in the text box and hit OK.

","richText":true,":type":"snowflake-site/components/blog/blog-text"},"markup_editor_external_image_4":{"id":"markup-editor-1e7ffb1649","title":"External image (4)","htmlContent":"
\n
\n cmp-image__image\\\n
\n
",":type":"snowflake-site/components/markup-editor"},"markup_editor_external_image_5":{"id":"markup-editor-f1ab3fe325","title":"External image (5)","htmlContent":"
\n
\n cmp-image__image\\