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 * 
FRO .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}\r\n\r\n@media screen and (min-width: 992px) {\r\n.snowflake-mega-nav-navigation-title { text-transform: none; font-size: 17px; }\r\n.snowflake-mega-nav-navigation-title:hover { color: var(--ui-01); }}",":type":"snowflake-site/components/markup-editor"},"mega_header":{"layout":"SIMPLE","id":"container-9ee7f87069",":items":{"nav_mega":{"activeItem":"item_1719963657751_c","id":"tabs-5eba36d3e5",":type":"snowflake-site/components/nav/nav-mega",":items":{"item_1719963657751_c":{"id":"nav-dropdown-menu-5df4a941d0","enableDropdown":true,"nav_column_container":{"layout":"SIMPLE","id":"container-620e8d3dd8",":items":{"nav_column":{"navColumnTitle":"The AI Data Cloud","numberOfSubColumns":"one-column","minWidth":"230","layout":"SIMPLE","id":"container-ad7ce08d37",":items":{"nav_item_copy_copy_2":{"id":"nav-item-b3e5fe2d86","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-9628cc7287","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-d103721a66","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-a028ee35fa","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-0c7ca2c9ab","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","roleAttribute":"column2","accessibilityLabel":"column2","id":"container-761644155c",":items":{"nav_item_copy_copy_2":{"id":"nav-item-22a3ab1ca5","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_c/nav_column_container/nav_column_1298824870/nav_item_copy_copy_2/icon.coreimg.svg/1722381577565/ai-ml-icon-test-white.svg","alt":" ","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_copy":{"id":"nav-item-72842c6830","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_c/nav_column_container/nav_column_1298824870/nav_item_copy_copy/icon.coreimg.svg/1722381592801/app-icon-test-white.svg","alt":" ","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_1075397000_":{"id":"nav-item-39aa905747","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_c/nav_column_container/nav_column_1298824870/nav_item_1075397000_/icon.coreimg.svg/1722381601583/collaboration-white.svg","alt":"alt","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_1075397000":{"id":"nav-item-425431b906","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_c/nav_column_container/nav_column_1298824870/nav_item_1075397000/icon.coreimg.svg/1726173758239/data-engineering-white.svg","alt":"alt","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_copy_2_1529736698":{"id":"nav-item-72c6d67da7","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_c/nav_column_container/nav_column_1298824870/nav_item_copy_copy_2_1529736698/icon.coreimg.svg/1726173781068/data-lake-white.svg","alt":" ","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_copy_2_1480293626":{"id":"nav-item-e0b408e616","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_c/nav_column_container/nav_column_1298824870/nav_item_copy_copy_2_1480293626/icon.coreimg.svg/1726173764437/data-warehouse-white.svg","alt":" ","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item":{"id":"nav-item-9992cd5f25","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_c/nav_column_container/nav_column_1298824870/nav_item/icon.coreimg.svg/1722381639388/unistore-white.svg","alt":" ","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_1278622853":{"id":"nav-item-17e6e12a7b",":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-ea012fd779",":items":{"nav_item":{"id":"nav-item-a72383e62e","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_c/nav_column_container/nav_column_copy_copy/nav_item/icon.coreimg.svg/1722382070714/nav-icon--cortex.svg","alt":"Snowflake Cortex logo","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_1855651246":{"id":"nav-item-eba67286a5","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_c/nav_column_container/nav_column_copy_copy/nav_item_copy_1855651246/icon.coreimg.svg/1722382080324/nav-icon--data-clean-rooms.svg","alt":"Snowflake Data Clean Rooms logo","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy":{"id":"nav-item-fa25e66914","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_c/nav_column_container/nav_column_copy_copy/nav_item_copy/icon.coreimg.svg/1722382091360/nav-icon--horizon.svg","alt":"Snowflake Horizon logo","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_660590635":{"id":"nav-item-637dd1cb08","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_c/nav_column_container/nav_column_copy_copy/nav_item_copy_660590635/icon.coreimg.svg/1722382106118/nav-icon--marketplace.svg","alt":"Snowflake Marketplace logo","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_258535199":{"id":"nav-item-7f23c6dc44","propertiesId":"workload-nav-1","linkDescription":"End-to-end, Snowflake-native app creation and distribution","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/data-cloud/workloads/applications/native-apps/"},"linkTargetContentType":"GENERIC","text":"Native Apps",":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_c/nav_column_container/nav_column_copy_copy/nav_item_258535199/icon.coreimg.svg/1728510262005/nav-icon--native-apps.svg","alt":"Snowflake Native Apps icon","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_660590_2121336733":{"id":"nav-item-a447c1c31f","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_c/nav_column_container/nav_column_copy_copy/nav_item_copy_660590_2121336733/icon.coreimg.svg/1722382125601/nav-icon--notebooks.svg","alt":"Notebooks icon","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_660590_63048622":{"id":"nav-item-7b8f20c5db","linkDescription":"Streamlined model development and MLOps from a centralized UI","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/data-cloud/snowflake-ml/"},"linkTargetContentType":"GENERIC","text":"Snowflake ML",":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_c/nav_column_container/nav_column_copy_copy/nav_item_copy_660590_63048622/icon.coreimg.svg/1728510224646/nav-icon-snowflake-ml.svg","alt":"Snowflake ML icon","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_660590_983061516":{"id":"nav-item-1588c80f31","linkDescription":"Framework for transforming Python scripts into web apps","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/data-cloud/overview/streamlit-in-snowflake/"},"linkTargetContentType":"GENERIC","text":"Streamlit",":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_c/nav_column_container/nav_column_copy_copy/nav_item_copy_660590_983061516/icon.coreimg.svg/1728510244537/nav-icon--streamlit.svg","alt":"Streamlit in Snowflake logo","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_511717659":{"id":"nav-item-61432b078e","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_c/nav_column_container/nav_column_copy_copy/nav_item_511717659/icon.coreimg.svg/1733861942628/nav-icon--ai-llm.svg","alt":"AI icon","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_41538387":{"id":"nav-item-50962ae7ad","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/open-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_c/nav_column_container/nav_column_copy_copy/nav_item_41538387/icon.coreimg.svg/1725035167676/nav-icon--polaris-catalog.svg","alt":"Apache Polaris logo","lazyEnabled":true,":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",":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"],"appliedCssClassNames":"snowflake-responsive-container-inner-padding-extra-small"},"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","alt":"Cloud icon","lazyEnabled":true,":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","alt":"Migrate icon","lazyEnabled":true,":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","alt":"Partner Network icon","lazyEnabled":true,":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","alt":"Partner Finder icon","lazyEnabled":true,":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","alt":"Calendar icon","lazyEnabled":true,":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_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_180298689","nav_item_1639361946","nav_item_680912746"]},"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","alt":"Notebooks icon","lazyEnabled":true,":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","alt":"Training icon","lazyEnabled":true,":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","alt":"Webinars icon","lazyEnabled":true,":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","alt":"Certification icon","lazyEnabled":true,":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","alt":"Live Demo icon","lazyEnabled":true,":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","alt":"Education icon","lazyEnabled":true,":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","alt":"Hands-on Labs icon","lazyEnabled":true,":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__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 Summit | June 2–5","description":"Join fellow data and AI pioneers this summer at Snowflake's annual user conference in San Francisco.","linkTitle":"Register Now","linkUrl":"/en/nav-promos/summit/","image":{"id":"image","src":"https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--89b38d51-1108-460a-9b43-83ac8614dec5/nav-promo-snowflake-summit-wide-v4.jpg?quality=85&preferwebp=true","alt":"Snowflake Summit 25 logo","lazyEnabled":true,":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?quality=85&preferwebp=true","alt":"Composite illustration from the PDF cover of Snowflake's 'The Data Executive's Guide to Effective AI' ebook","lazyEnabled":true,":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":"Secrets of Gen AI success","description":"Real-world gen AI use cases and outcomes from 9 leaders across industries","linkTitle":"Download Now","linkUrl":"/en/nav-promos/secrets-of-gen-ai-success/","image":{"id":"image","src":"https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--49374aaa-a594-4e7f-9b4c-c879edb5d36b/612x612-ebook-secrets-of-gen-ai-success.png?quality=85&preferwebp=true","alt":"alt","lazyEnabled":true,":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_1719963657751":{"id":"nav-dropdown-menu-e78e3c5175","enableDropdown":true,"nav_column_container":{"layout":"SIMPLE","id":"container-96cd1cf823",":items":{"nav_column_copy_copy":{"navColumnTitle":"Build","numberOfSubColumns":"one-column","layout":"SIMPLE","id":"container-62293b86c3",":items":{"nav_item":{"id":"nav-item-4c59e08f3a","propertiesId":"testID","linkDescription":"Overview of the dev resources you need to build and scale","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/developers/"},"linkTargetContentType":"GENERIC","text":"Snowflake for Developers",":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/icon.coreimg.svg/1731362494574/nav-icon--devs.svg","alt":"Developers icon","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_1855651246":{"id":"nav-item-c2c840b80c","linkDescription":"Reference architectures, use cases and best practices","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/developers/solutions-center/"},"linkTargetContentType":"GENERIC","text":"Solutions Center",":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_copy_1855651246/icon.coreimg.svg/1731361885198/nav-icon--solution-center.svg","alt":"Solution Center icon","lazyEnabled":true,":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":"The latest software versions, drivers, libraries and relevant docs","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/developers/downloads/"},"linkTargetContentType":"GENERIC","text":"Downloads",":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_copy/icon.coreimg.svg/1731362660050/nav-icon-download.svg","alt":"Download icon","lazyEnabled":true,":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_column_copy_copy_1367930678":{"navColumnTitle":"Learn","numberOfSubColumns":"one-column","layout":"SIMPLE","id":"container-d6b1a183a0",":items":{"nav_item":{"id":"nav-item-ff087ddef5","propertiesId":"testID","linkDescription":"Reference docs, guides, tutorials and announcements","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"},"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_1367930678/nav_item/icon.coreimg.svg/1731361950527/nav-icon--docs.svg","alt":"Docs icon","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_1855651246":{"id":"nav-item-726f353834","linkDescription":"Tutorials to get up and running with Snowflake","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"},"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_1367930678/nav_item_copy_1855651246/icon.coreimg.svg/1731361970859/nav-icon--quickstarts.svg","alt":"Quickstart icon","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy":{"id":"nav-item-5cb262280d","additionalClasses":"is-light-gray-icon","linkDescription":"Key projects Snowflake engineers maintain and support","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/developers/open-source/"},"linkTargetContentType":"GENERIC","text":"Open Source",":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_1367930678/nav_item_copy/icon.coreimg.svg/1731365437016/nav-icon-open-source.svg","alt":"Open Source icon","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_copy":{"id":"nav-item-b6159bb691","additionalClasses":"is-light-gray-icon","linkDescription":"Online and in-person classes and workshops to upskill on Snowflake","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"/en/developers/northstar/"},"linkTargetContentType":"GENERIC","text":"Builder Education",":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_1367930678/nav_item_copy_copy/icon.coreimg.svg/1731362475640/nav-icon--northstar.svg","alt":"Northstar logo","lazyEnabled":true,":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_copy"]},"nav_column_copy_copy_1101894776":{"navColumnTitle":"Connect","numberOfSubColumns":"one-column","layout":"SIMPLE","id":"container-77265b9709",":items":{"nav_item":{"id":"nav-item-a7f0b4cae0","propertiesId":"testID","linkDescription":"Snowflake’s technical leaders on what, why and how they build features","button":{"id":"button","showOutboundIcon":false,"buttonLink":{"valid":true,"url":"https://www.snowflake.com/engineering-blog/","attributes":{"target":"_blank"}},"linkTargetContentType":"GENERIC","text":"Engineering Blog",":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_1101894776/nav_item/icon.coreimg.svg/1731362440315/nav-icon--developer-center.svg","alt":"Developers icon","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-item"},"nav_item_copy_1855651246":{"id":"nav-item-404e7f209d","linkDescription":"Tips, tricks and discussion with fellow Snowflake developers","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"},"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_1101894776/nav_item_copy_1855651246/icon.coreimg.svg/1731362644348/nav-icon--partner-network.svg","alt":"Partner Network icon","lazyEnabled":true,":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"]}},":type":"snowflake-site/components/nav/nav-column/nav-column-container",":itemsOrder":["nav_column_copy_copy","nav_column_copy_copy_1367930678","nav_column_copy_copy_1101894776"]},"nav_promo_section":{"id":"nav-promo-section-19fcb2c9d5","experience_fragment_1":{"id":"experiencefragment-f493cad38d","configured":true,"localizedFragmentVariationPath":"/content/experience-fragments/snowflake-site/language-masters/en/site/nav-promo-card/nav-promo-5/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-d25abf9ca3",":items":{"nav_promo_card":{"id":"nav-promo-card-f6037781ab","openInNewWindow":false,"layout":"horizontal","headline":"Get started with your first Snowflake Notebook","description":"Write and execute code, visualize results, and tell the story of your analysis all in one place.","linkTitle":"Learn More","linkUrl":"/en/developers/solutions-center/getting-started-with-your-first-snowflake-notebook-project/","image":{"id":"image","src":"https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--dc7e334a-c38b-4283-b1de-fcf829952eef/nav-promo-first-notebook.jpg?quality=85&preferwebp=true","alt":"alt","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-promo-card"}},":type":"snowflake-site/components/container",":itemsOrder":["nav_promo_card"]},"cq:LiveSyncConfig":{":type":"cq:LiveCopy","cq:isDeep":true,"cq:rolloutConfigs":[],"cq:master":"/content/experience-fragments/snowflake-site/language-masters/en/site/nav-promo-card/nav-promo-card-4"}},":type":"snowflake-site/components/experiencefragment",":itemsOrder":["root","cq:LiveSyncConfig"],"classNames":"aem-xf"},"experience_fragment_2":{"id":"experiencefragment-361a2866ae","configured":true,"localizedFragmentVariationPath":"/content/experience-fragments/snowflake-site/language-masters/en/site/nav-promo-card/nav-promo-card-4/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-e120ce0824",":items":{"nav_promo_card":{"id":"nav-promo-card-fe5acd5795","openInNewWindow":true,"layout":"horizontal","headline":"Northstar Builder Workshops","description":"Join other developers as you roll up your sleeves and explore the possibilities of Snowflake.","linkTitle":"Learn More","linkUrl":"/en/nav-promos/northstar-builders-workshop/","image":{"id":"image","src":"https://publish-p57963-e462109.adobeaemcloud.com/adobe/dynamicmedia/deliver/dm-aid--14341ced-bc5e-4a29-9762-b7857f6cadfc/nav-promo-northstar.jpg?quality=85&preferwebp=true","alt":"Snowflake Northstar logo","lazyEnabled":true,":type":"snowflake-site/components/image"},":type":"snowflake-site/components/nav/nav-promo-card"}},":type":"snowflake-site/components/container",":itemsOrder":["nav_promo_card"]},"cq:LiveSyncConfig":{":type":"cq:LiveCopy","cq:isDeep":true,"cq:rolloutConfigs":[],"cq:master":"/content/experience-fragments/snowflake-site/language-masters/en/site/nav-promo-card/master"}},":type":"snowflake-site/components/experiencefragment",":itemsOrder":["root","cq:LiveSyncConfig"],"classNames":"aem-xf"},":type":"snowflake-site/components/nav/nav-promo-section"},":type":"snowflake-site/components/nav/nav-dropdown-menu","cq:panelTitle":"Developers"},"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_c","nav_dropdown_menu_2","item_1718247184925","item_1719961362824","item_1719963657751","item_1718247180324"]},"languagenavigation":{"id":"language-navigation-24d93c7f20","languageNavItems":[{"title":"English","path":"/en/blog/custom-sql-now-supported-in-the-snowflake-connector-for-power-bi/","locale":"en","active":true},{"title":"Português","path":"/pt_br/","locale":"pt_br","active":false},{"title":"Italiano","path":"/it/","locale":"it","active":false},{"title":"한국어","path":"/ko/","locale":"ko","active":false},{"title":"日本語","path":"/ja/blog/custom-sql-now-supported-in-the-snowflake-connector-for-power-bi/","locale":"ja","active":false},{"title":"Español","path":"/es/","locale":"es","active":false},{"title":"Deutsch","path":"/de/","locale":"de","active":false},{"title":"Français","path":"/fr/","locale":"fr","active":false}],":type":"snowflake-site/components/nav/language-navigation"},"button":{"id":"button-4e0cc911c7","heapButtonClasses":["contact_nav"],"showOutboundIcon":true,"buttonLink":{"valid":true,"url":"/en/contact-sales/"},"linkTargetContentType":"GENERIC","text":"CONTACT SALES",":type":"snowflake-site/components/button","appliedCssClassNames":"snowflake-button-secondary snowflake-button-blue snowflake-button-compact","linkType":"SNOWFLAKE_INTERNAL"},"button_288358396":{"id":"button-350129d0b1","heapButtonClasses":["start_for_free_nav"],"showOutboundIcon":true,"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",":itemsOrder":["nav_mega","languagenavigation","button","button_288358396"],"appliedCssClassNames":"snowflake-header-container white"}},":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?quality=85&preferwebp=true","alt":"Custom SQL Now Supported in the Snowflake Connector for Power BI!","lazyEnabled":true,":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\\