{"id":1387112,"date":"2021-11-11T12:27:27","date_gmt":"2021-11-11T20:27:27","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1387112"},"modified":"2023-01-13T14:56:10","modified_gmt":"2023-01-13T22:56:10","slug":"introducing-cloud-data-warehouse-support","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support","title":{"rendered":"Introducing Cloud Data Warehouse Support"},"author":156961,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[37101,23851],"tags":[762512,762532,762522,762542,762552],"industry":[],"product":[36571,36561],"class_list":["post-1387112","blog","type-blog","status-publish","format-standard","hentry","category-announcements","category-data-management","tag-arcgis-pro2-9","tag-bigquery","tag-cloud-data-warehouse","tag-redshift","tag-snowflake","product-arcgis-enterprise","product-arcgis-pro"],"acf":{"short_description":"Learn more about the new Cloud Data Warehouse support and capabilities in ArcGIS Pro 2.9 and ArcGIS Enterprise 10.9.1.","flexible_content":[{"acf_fc_layout":"content","content":"<p>With the release of ArcGIS Pro 2.9 and ArcGIS Enterprise 10.9.1, you can now establish database connections to the following cloud data warehouses to explore, visualize, and share data within your organization.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1387262,"id":1387262,"title":"cdw_logos2","filename":"cdw_logos2-2.jpg","filesize":42598,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/cdw_logos2-2.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support\/cdw_logos2-3","alt":"","author":"156961","description":"","caption":"","name":"cdw_logos2-3","status":"inherit","uploaded_to":1387112,"date":"2021-11-03 17:53:16","modified":"2021-11-03 17:53:16","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1251,"height":176,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/cdw_logos2-2-213x176.jpg","thumbnail-width":213,"thumbnail-height":176,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/cdw_logos2-2.jpg","medium-width":464,"medium-height":65,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/cdw_logos2-2.jpg","medium_large-width":768,"medium_large-height":108,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/cdw_logos2-2.jpg","large-width":1251,"large-height":176,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/cdw_logos2-2.jpg","1536x1536-width":1251,"1536x1536-height":176,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/cdw_logos2-2.jpg","2048x2048-width":1251,"2048x2048-height":176,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/cdw_logos2-2-826x116.jpg","card_image-width":826,"card_image-height":116,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/cdw_logos2-2.jpg","wide_image-width":1251,"wide_image-height":176}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Cloud data warehouses are databases architected to handle large volumes of structured data that are accessible in public clouds as managed services. Cloud data warehouses are being used across a variety of departments and industries to make use of the following advantages:<\/p>\n<ul>\n<li>Low total cost of ownership<\/li>\n<li>Improved speed and performance<\/li>\n<li>Improved data access and integration<\/li>\n<li>Scalability and elasticity<\/li>\n<\/ul>\n<h2>Cloud Data Warehouse support in ArcGIS Pro<\/h2>\n<p>Now, GIS users can take advantage of all the benefits of a CDW with the ability to access and visualize the data on a map and perform analysis.<\/p>\n<p>With this release, we&#8217;ve added database access support for BigQuery, Snowflake, and Redshift. This allows you to access these cloud data warehouses in ArcGIS to visualize and analyze your data using advanced rendering techniques.\u00a0 You can explore data for spatial and non-spatial patterns through many tools.<\/p>\n<h3>Connect, explore, and visualize your CDW data<\/h3>\n<p>The Database Connection dialog now supports establishing connections to these cloud data warehouses. <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/help\/data\/databases\/cloud-data-warehouse-connections.htm\">Create a database connection<\/a> to view and explore the objects in a cloud data warehouse from the Catalog pane in ArcGIS Pro.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1389422,"id":1389422,"title":"Database-connection-ui-zoom","filename":"Database-connection-ui-zoom-1.jpg","filesize":61750,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/Database-connection-ui-zoom-1.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support\/database-connection-ui-zoom-2","alt":"","author":"156961","description":"","caption":"","name":"database-connection-ui-zoom-2","status":"inherit","uploaded_to":1387112,"date":"2021-11-04 20:16:41","modified":"2021-11-04 20:16:41","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":826,"height":465,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/Database-connection-ui-zoom-1-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/Database-connection-ui-zoom-1.jpg","medium-width":464,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/Database-connection-ui-zoom-1.jpg","medium_large-width":768,"medium_large-height":432,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/Database-connection-ui-zoom-1.jpg","large-width":826,"large-height":465,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/Database-connection-ui-zoom-1.jpg","1536x1536-width":826,"1536x1536-height":465,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/Database-connection-ui-zoom-1.jpg","2048x2048-width":826,"2048x2048-height":465,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/Database-connection-ui-zoom-1.jpg","card_image-width":826,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/Database-connection-ui-zoom-1.jpg","wide_image-width":826,"wide_image-height":465}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h3>Create a\u00a0Query Layer<\/h3>\n<p>You can perform analysis against CDW data using native DBMS SQL capabilities using <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/help\/mapping\/layer-properties\/create-a-query-layer-cloud-data-warehouse.htm\">query layers<\/a>. The New Query Layer dialog has several enhancements that you&#8217;ll notice when working with cloud data warehouses.<\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li><strong>List of Tables<\/strong> &#8211; By default, the list of tables is not displayed in this dialog. It is assumed that most queries will be constructed in the console for the cloud data warehouse. If you need access to view tables, you can check this on.<\/li>\n<li><strong>Create materialized view<\/strong> &#8211; You have the option to create a materialized view for the query layer to reference. This is created during the query layer creation process. Using materialized views improves map interaction performance. For BigQuery, you can decide how long will the materialized view is stored by setting an expiration. After it expires, the materialized view is automatically deleted.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":1387152,"id":1387152,"title":"new-querylayer-ui","filename":"new-querylayer-ui.png","filesize":39167,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/new-querylayer-ui.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support\/new-querylayer-ui","alt":"","author":"156961","description":"","caption":"","name":"new-querylayer-ui","status":"inherit","uploaded_to":1387112,"date":"2021-11-03 15:34:12","modified":"2021-11-03 15:34:12","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":540,"height":680,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/new-querylayer-ui-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/new-querylayer-ui.png","medium-width":207,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/new-querylayer-ui.png","medium_large-width":540,"medium_large-height":680,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/new-querylayer-ui.png","large-width":540,"large-height":680,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/new-querylayer-ui.png","1536x1536-width":540,"1536x1536-height":680,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/new-querylayer-ui.png","2048x2048-width":540,"2048x2048-height":680,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/new-querylayer-ui-369x465.png","card_image-width":369,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/new-querylayer-ui.png","wide_image-width":540,"wide_image-height":680}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"youtube","start_time":"0","end_time":"","youtube_video_url":"<iframe title=\"Introducing Cloud Data Warehouse Support\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/HwaKw-rlpnQ?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>"},{"acf_fc_layout":"content","content":"<h3>Enable Feature Binning (BigQuery and Snowflake)<\/h3>\n<p>Feature binning is a method of feature reduction that can help visualize data trends while vastly improving the drawing performance of layers that contain thousands or millions of point features. You can <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/help\/mapping\/layer-properties\/aggregate-features-into-bins.htm\">aggregate features into bins<\/a> using the Enable Feature Binning tool in ArcGIS Pro. After bin-enabled, you can visualize these features in the map view and interact with the bins by zooming in and out using different scales. You can also adjust the bin size and scale threshold. Since BigQuery and Snowflake use static feature binning it is important to ensure the bin cache is kept up to date as the underlying data changes.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1392342,"id":1392342,"title":"feature-binning-in-map","filename":"feature-binning-in-map.png","filesize":360185,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/feature-binning-in-map.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support\/feature-binning-in-map","alt":"","author":"156961","description":"","caption":"Enabling feature binning on a cloud data warehouse point dataset.","name":"feature-binning-in-map","status":"inherit","uploaded_to":1387112,"date":"2021-11-08 18:05:43","modified":"2021-11-08 18:06:07","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1920,"height":1040,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/feature-binning-in-map-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/feature-binning-in-map.png","medium-width":464,"medium-height":251,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/feature-binning-in-map.png","medium_large-width":768,"medium_large-height":416,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/feature-binning-in-map.png","large-width":1920,"large-height":1040,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/feature-binning-in-map-1536x832.png","1536x1536-width":1536,"1536x1536-height":832,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/feature-binning-in-map.png","2048x2048-width":1920,"2048x2048-height":1040,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/feature-binning-in-map-826x447.png","card_image-width":826,"card_image-height":447,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/feature-binning-in-map.png","wide_image-width":1920,"wide_image-height":1040}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h3>Share data from cloud data warehouses to your organization<\/h3>\n<p>You can <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/help\/sharing\/overview\/configure-map-image-layer.htm\">share data from your cloud data warehouse<\/a> to your organization as a map image layer. Let&#8217;s review some of the important settings to be mindful of during the publishing process.<\/p>\n<ul>\n<li>On the <strong>General<\/strong> tab of the <strong>Share As Web Layer<\/strong> pane confirm that <strong>Map Image<\/strong> is checked under <strong>Reference registered data<\/strong>.<\/li>\n<li>Use the <strong>Configuration<\/strong> tab of the <strong>Share as Web Layer<\/strong> pane and click on <strong>Configure Parameters<\/strong> and review the <strong>Data Source<\/strong> section. When cloud data warehouse datasources are detected in the map, additional options are available for how the service will access the data.<\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":1387492,"id":1387492,"title":"share-cdw-configuration-ui","filename":"share-cdw-configuration-ui-1.png","filesize":8629,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/share-cdw-configuration-ui-1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support\/share-cdw-configuration-ui-2","alt":"","author":"156961","description":"","caption":"","name":"share-cdw-configuration-ui-2","status":"inherit","uploaded_to":1387112,"date":"2021-11-03 18:47:47","modified":"2021-11-03 18:47:47","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":500,"height":177,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/share-cdw-configuration-ui-1-213x177.png","thumbnail-width":213,"thumbnail-height":177,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/share-cdw-configuration-ui-1.png","medium-width":464,"medium-height":164,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/share-cdw-configuration-ui-1.png","medium_large-width":500,"medium_large-height":177,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/share-cdw-configuration-ui-1.png","large-width":500,"large-height":177,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/share-cdw-configuration-ui-1.png","1536x1536-width":500,"1536x1536-height":177,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/share-cdw-configuration-ui-1.png","2048x2048-width":500,"2048x2048-height":177,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/share-cdw-configuration-ui-1.png","card_image-width":500,"card_image-height":177,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/share-cdw-configuration-ui-1.png","wide_image-width":500,"wide_image-height":177}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p><strong>Data Source options<\/strong><\/p>\n<p>The first radio option allows you to pick whether the data will be accessed directly or by using a materialized view.<\/p>\n<ul type=\"disc\">\n<li><strong>Access data directly<\/strong> &#8211; Use this option when the query can&#8217;t be materialized or in cases where the result set is relatively small. The service references data in CDW that was used in query layer SQL expression.<\/li>\n<li><strong>Materialized view<\/strong> &#8211; Use this option to create a materialized view during publishing for the service to reference. The materialized view is managed through the life of the service and is deleted when the service is deleted.<\/li>\n<\/ul>\n<p>The second radio option will create a snapshot for the query. A cache of query layer results are copied to the relational datastore on the hosting server for the service to reference. If your ArcGIS Enterprise isn&#8217;t running in the same cloud environment as the cloud data warehouse, creating a snapshot can improve rendering performance. Snapshots are also recommended with continuously updated data is not needed. Snapshot can be refreshed on demand through the Enterprise portal.<\/p>\n"},{"acf_fc_layout":"youtube","start_time":"0","end_time":"","youtube_video_url":"<iframe title=\"Sharing Cloud Data Warehouse\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/CPj3hEXShwI?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>"},{"acf_fc_layout":"content","content":"<h3>Take it for a spin<\/h3>\n<p>This is the initial release introducing support for Cloud Data Warehouses, so be on the lookout as we continue to improve functionality and add more capabilities with upcoming releases. We look forward to all your feedback, suggestions, and questions. If you are using CDW within your organization, this is the perfect time to make the most out of it with ArcGIS Pro 2.9 and ArcGIS Enterprise 10.9.1.<\/p>\n"}],"related_articles":"","authors":[{"ID":7501,"user_firstname":"Melissa","user_lastname":"Jarman","nickname":"Melissa Jarman","user_nicename":"melissabjarman","display_name":"Melissa Jarman","user_email":"mjarman@esri.com","user_url":"","user_registered":"2018-03-21 18:21:21","user_description":"Product Engineer on the Geodatabase team - specializing in enterprise databases, versioning, and all things geodatabase. \r\nA true southerner \/\/ Chick-fil-A lover \/\/ Beach bum","user_avatar":"<img data-del=\"avatar\" src='https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/01\/profile-150x150.jpg' class='avatar pp-user-avatar avatar-96 photo ' height='96' width='96'\/>"},{"ID":156961,"user_firstname":"Diana","user_lastname":"Muresan","nickname":"Diana Muresan","user_nicename":"dmuresan","display_name":"Diana Muresan","user_email":"dmuresan@esri.com","user_url":"","user_registered":"2021-01-12 23:13:12","user_description":"Product Engineer on the Geodatabase team, passionate about making a difference in people's lives using GIS. Hiker and a true \u00c9clair and Cr\u00eape lover in her free time.","user_avatar":"<img data-del=\"avatar\" src='https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/02\/Photo_crop-213x200.jpg' class='avatar pp-user-avatar avatar-96 photo ' height='96' width='96'\/>"}],"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/cloud-computing.jpg","wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/wide-card-3.jpg"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Introducing Cloud Data Warehouse Support<\/title>\n<meta name=\"description\" content=\"Learn more about the new Cloud Data Warehouse support and capabilities in ArcGIS Pro 2.9 and ArcGIS Enterprise 10.9.1.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introducing Cloud Data Warehouse Support\" \/>\n<meta property=\"og:description\" content=\"Learn more about the new Cloud Data Warehouse support and capabilities in ArcGIS Pro 2.9 and ArcGIS Enterprise 10.9.1.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support\" \/>\n<meta property=\"og:site_name\" content=\"ArcGIS Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-13T22:56:10+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@ESRI\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support\"},\"author\":{\"name\":\"Diana Muresan\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/4fd5d4cc17e6b2cf4dede740d9a70ca8\"},\"headline\":\"Introducing Cloud Data Warehouse Support\",\"datePublished\":\"2021-11-11T20:27:27+00:00\",\"dateModified\":\"2023-01-13T22:56:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support\"},\"wordCount\":5,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"ArcGIS Pro2.9\",\"BigQuery\",\"Cloud Data Warehouse\",\"Redshift\",\"Snowflake\"],\"articleSection\":[\"Announcements\",\"Data Management\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support\",\"name\":\"Introducing Cloud Data Warehouse Support\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2021-11-11T20:27:27+00:00\",\"dateModified\":\"2023-01-13T22:56:10+00:00\",\"description\":\"Learn more about the new Cloud Data Warehouse support and capabilities in ArcGIS Pro 2.9 and ArcGIS Enterprise 10.9.1.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Introducing Cloud Data Warehouse Support\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"name\":\"ArcGIS Blog\",\"description\":\"Get insider info from Esri product teams\",\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\",\"name\":\"Esri\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"width\":400,\"height\":400,\"caption\":\"Esri\"},\"image\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/esrigis\/\",\"https:\/\/x.com\/ESRI\",\"https:\/\/www.linkedin.com\/company\/5311\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/4fd5d4cc17e6b2cf4dede740d9a70ca8\",\"name\":\"Diana Muresan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/02\/Photo_crop-213x200.jpg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/02\/Photo_crop-213x200.jpg\",\"caption\":\"Diana Muresan\"},\"description\":\"Product Engineer on the Geodatabase team, passionate about making a difference in people's lives using GIS. Hiker and a true \u00c9clair and Cr\u00eape lover in her free time.\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/dmuresan\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Introducing Cloud Data Warehouse Support","description":"Learn more about the new Cloud Data Warehouse support and capabilities in ArcGIS Pro 2.9 and ArcGIS Enterprise 10.9.1.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support","og_locale":"en_US","og_type":"article","og_title":"Introducing Cloud Data Warehouse Support","og_description":"Learn more about the new Cloud Data Warehouse support and capabilities in ArcGIS Pro 2.9 and ArcGIS Enterprise 10.9.1.","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2023-01-13T22:56:10+00:00","twitter_card":"summary_large_image","twitter_site":"@ESRI","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support"},"author":{"name":"Diana Muresan","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/4fd5d4cc17e6b2cf4dede740d9a70ca8"},"headline":"Introducing Cloud Data Warehouse Support","datePublished":"2021-11-11T20:27:27+00:00","dateModified":"2023-01-13T22:56:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support"},"wordCount":5,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["ArcGIS Pro2.9","BigQuery","Cloud Data Warehouse","Redshift","Snowflake"],"articleSection":["Announcements","Data Management"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support","name":"Introducing Cloud Data Warehouse Support","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2021-11-11T20:27:27+00:00","dateModified":"2023-01-13T22:56:10+00:00","description":"Learn more about the new Cloud Data Warehouse support and capabilities in ArcGIS Pro 2.9 and ArcGIS Enterprise 10.9.1.","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Introducing Cloud Data Warehouse Support"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/arcgis-blog\/#website","url":"https:\/\/www.esri.com\/arcgis-blog\/","name":"ArcGIS Blog","description":"Get insider info from Esri product teams","publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization","name":"Esri","url":"https:\/\/www.esri.com\/arcgis-blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","width":400,"height":400,"caption":"Esri"},"image":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/esrigis\/","https:\/\/x.com\/ESRI","https:\/\/www.linkedin.com\/company\/5311\/"]},{"@type":"Person","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/4fd5d4cc17e6b2cf4dede740d9a70ca8","name":"Diana Muresan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/02\/Photo_crop-213x200.jpg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/02\/Photo_crop-213x200.jpg","caption":"Diana Muresan"},"description":"Product Engineer on the Geodatabase team, passionate about making a difference in people's lives using GIS. Hiker and a true \u00c9clair and Cr\u00eape lover in her free time.","url":"https:\/\/www.esri.com\/arcgis-blog\/author\/dmuresan"}]}},"text_date":"November 11, 2021","author_name":"Multiple Authors","author_page":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/introducing-cloud-data-warehouse-support","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/wide-card-3.jpg","primary_product":"ArcGIS Pro","tag_data":[{"term_id":762512,"name":"ArcGIS Pro2.9","slug":"arcgis-pro2-9","term_group":0,"term_taxonomy_id":762512,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":762532,"name":"BigQuery","slug":"bigquery","term_group":0,"term_taxonomy_id":762532,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":762522,"name":"Cloud Data Warehouse","slug":"cloud-data-warehouse","term_group":0,"term_taxonomy_id":762522,"taxonomy":"post_tag","description":"","parent":0,"count":4,"filter":"raw"},{"term_id":762542,"name":"Redshift","slug":"redshift","term_group":0,"term_taxonomy_id":762542,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":762552,"name":"Snowflake","slug":"snowflake","term_group":0,"term_taxonomy_id":762552,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"}],"category_data":[{"term_id":37101,"name":"Announcements","slug":"announcements","term_group":0,"term_taxonomy_id":37101,"taxonomy":"category","description":"","parent":0,"count":1962,"filter":"raw"},{"term_id":23851,"name":"Data Management","slug":"data-management","term_group":0,"term_taxonomy_id":23851,"taxonomy":"category","description":"","parent":0,"count":920,"filter":"raw"}],"product_data":[{"term_id":36571,"name":"ArcGIS Enterprise","slug":"arcgis-enterprise","term_group":0,"term_taxonomy_id":36571,"taxonomy":"product","description":"","parent":0,"count":972,"filter":"raw"},{"term_id":36561,"name":"ArcGIS Pro","slug":"arcgis-pro","term_group":0,"term_taxonomy_id":36561,"taxonomy":"product","description":"","parent":0,"count":2036,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=arcgis-pro","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1387112","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/users\/156961"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=1387112"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1387112\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=1387112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=1387112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=1387112"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=1387112"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=1387112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}