{"id":2024,"date":"2018-11-07T00:00:00","date_gmt":"2018-11-07T00:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse"},"modified":"2025-04-29T15:02:46","modified_gmt":"2025-04-29T22:02:46","slug":"row-level-security-is-now-supported-for-azure-sql-data-warehouse","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/","title":{"rendered":"Row-Level Security is now supported for Microsoft Azure SQL Data Warehouse"},"content":{"rendered":"<p>Today we\u2019re announcing the general availability of Row-Level Security (RLS) for Microsoft Azure SQL Data Warehouse, an additional capability for managing security for sensitive data. Azure SQL Data Warehouse is a fast, flexible, and secure cloud data warehouse tuned for running complex queries fast and across petabytes of data.<\/p>\n<p>As you move data to the cloud, securing your data assets is critical to building trust with your customers and partners. With the introduction of RLS, you can implement security policies to control access to rows in your tables, as in who can access what rows. RLS enables this fine-grained access control without having to redesign your data warehouse. This simplifies the overall security model as the access restriction logic is located in the database tier itself rather than away from the data in another application. RLS also eliminates the need to introduce views to filter out rows for access control management. In addition, RLS supports both SQL authentication and Azure Active Directory (AAD) authentication.<\/p>\n<p>Here are a few scenarios where RLS could be leveraged today:<\/p>\n<ul>\n<li>A healthcare provider enforces a security policy that allows nurses to view only data rows for their own patients.<\/li>\n<li>A financial services firm restricts access to rows of financial data based on either the employee\u2019s business division or employee\u2019s role within the company.<\/li>\n<li>A multi-tenant application enforces logical separation of each tenant&#8217;s data rows from every other tenant&#8217;s rows.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"RLS Diagram\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/003f5372-d3bb-42d5-ad19-a3d427c5abb7.webp\" alt=\"RLS Diagram\" width=\"671\" height=\"309\" \/><\/p>\n<p>RLS is a form of predicate-based access control that works by automatically applying a security predicate to all queries on a table. The predicate determines which users can access what rows. For example, a simple predicate might be, \u201cWHERE SalesRep = SYSTEM_USER,\u201d while a complicated predicate might include JOINs to look up information in other tables.<\/p>\n<p>There are two types of security predicates:<\/p>\n<ul>\n<li>Filter predicates silently filter SELECT, UPDATE, and DELETE operations to exclude rows that do not satisfy the predicate.<\/li>\n<li>Block predicates explicitly block INSERT, UPDATE, and DELETE operations that do not satisfy the predicate.<\/li>\n<\/ul>\n<p>In this release, Azure SQL Data Warehouse only supports filter predicates while support for block predicates will be released soon. Also, in this release, RLS doesn\u2019t support external tables created via PolyBase.<\/p>\n<p>To add a security predicate on a table, you first need an inline table-valued function that defines your access criteria. Then, you create a security policy that adds filter predicate on any tables you like, using this function. Here\u2019s a simple example that prevents sales representatives from accessing rows in a customers table that are not assigned to them:<\/p>\n<pre>CREATE SCHEMA security;\n\nCREATE FUNCTION security.customerPredicate(@SalesRepName AS sysname)\nRETURNS TABLE\n    WITH SCHEMABINDING\nAS\n    RETURN SELECT 1 AS accessResult\nWHERE @SalesRepName = SYSTEM_USER OR SYSTEM_USER = 'Manager';\ngo\n\nCREATE SECURITY POLICY security.customerAccessPolicy\nADD FILTER PREDICATE security.customerPredicate(SalesRepName) ON dbo.Customers\nWITH (STATE = ON);\ngo<\/pre>\n<p>This capability is available now in all Azure regions with no additional charge. The rollout has been completed in a few regions, with the goal to finish worldwide deployment within the next two weeks. Azure SQL Data Warehouse continues to lead in the areas of security, compliance, privacy, and auditing.<\/p>\n<h2>Next steps<\/h2>\n<ul>\n<li>For more information on RLS in Azure SQL Data Warehouse, refer to our <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/row-level-security?toc=\/azure\/sql-data-warehouse\/toc.json\" target=\"_blank\" rel=\"noopener\">online documentation<\/a>.<\/li>\n<li>For more information about Azure SQL Data Warehouse security capabilities, refer to the \u201cGuide to enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform\u201d from the <a href=\"https:\/\/www.microsoft.com\/en-us\/trustcenter\" target=\"_blank\" rel=\"noopener\">Microsoft Trust Center<\/a>, or our <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/sql-data-warehouse\/sql-data-warehouse-overview-manage-security\" target=\"_blank\" rel=\"noopener\">online documentation<\/a>.<\/li>\n<li>To get started today, <a href=\"https:\/\/docs.microsoft.com\/azure\/sql-data-warehouse\/create-data-warehouse-portal\" target=\"_blank\" rel=\"noopener\">create an Azure SQL Data Warehouse<\/a>.<\/li>\n<li>To stay up-to-date on the latest Azure SQL Data Warehouse news and features, follow us on Twitter <a href=\"https:\/\/twitter.com\/AzureSQLDW\" target=\"_blank\" rel=\"noopener\">@AzureSQLDW<\/a>.<\/li>\n<li>For feature requests, please vote on our <a href=\"https:\/\/feedback.azure.com\/forums\/307516-sql-data-warehouse\" target=\"_blank\" rel=\"noopener\">UserVoice<\/a>.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Today we\u2019re announcing general availability of Row-Level Security (RLS) for Azure SQL Data Warehouse, an additional capability for managing security for sensitive data.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","footnotes":"","msx_community_cta_settings":[]},"categories":[1474],"tags":[],"audience":[3054,3057,3053],"content-type":[1465],"product":[1477],"tech-community":[],"topic":[],"coauthors":[97],"class_list":["post-2024","post","type-post","status-publish","format-standard","hentry","category-analytics","audience-business-decision-makers","audience-data-professionals","audience-it-decision-makers","content-type-announcements","product-azure-synapse-analytics","review-flag-1-1680286581-825","review-flag-gener-1680286584-335"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Row-Level Security is now supported for Microsoft Azure SQL Data Warehouse | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"Today we\u2019re announcing general availability of Row-Level Security (RLS) for Azure SQL Data Warehouse, an additional capability for managing security for sensitive data.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Row-Level Security is now supported for Microsoft Azure SQL Data Warehouse | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"Today we\u2019re announcing general availability of Row-Level Security (RLS) for Azure SQL Data Warehouse, an additional capability for managing security for sensitive data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Azure Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/microsoftazure\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-07T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-29T22:02:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/003f5372-d3bb-42d5-ad19-a3d427c5abb7.webp\" \/>\n<meta name=\"author\" content=\"Microsoft Azure\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@azure\" \/>\n<meta name=\"twitter:site\" content=\"@azure\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Azure\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/\",\"@type\":\"Person\",\"@name\":\"Microsoft Azure\"}],\"headline\":\"Row-Level Security is now supported for Microsoft Azure SQL Data Warehouse\",\"datePublished\":\"2018-11-07T00:00:00+00:00\",\"dateModified\":\"2025-04-29T22:02:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/\"},\"wordCount\":577,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/003f5372-d3bb-42d5-ad19-a3d427c5abb7.webp\",\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/\",\"name\":\"Row-Level Security is now supported for Microsoft Azure SQL Data Warehouse | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/003f5372-d3bb-42d5-ad19-a3d427c5abb7.webp\",\"datePublished\":\"2018-11-07T00:00:00+00:00\",\"dateModified\":\"2025-04-29T22:02:46+00:00\",\"description\":\"Today we\u2019re announcing general availability of Row-Level Security (RLS) for Azure SQL Data Warehouse, an additional capability for managing security for sensitive data.\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/003f5372-d3bb-42d5-ad19-a3d427c5abb7.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/003f5372-d3bb-42d5-ad19-a3d427c5abb7.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Analytics\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/analytics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Row-Level Security is now supported for Microsoft Azure SQL Data Warehouse\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"name\":\"Microsoft Azure Blog\",\"description\":\"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.\",\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\",\"name\":\"Microsoft Azure Blog\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"width\":512,\"height\":512,\"caption\":\"Microsoft Azure Blog\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/microsoftazure\",\"https:\/\/x.com\/azure\",\"https:\/\/www.instagram.com\/microsoftdeveloper\/\",\"https:\/\/www.linkedin.com\/company\/16188386\",\"https:\/\/www.youtube.com\/user\/windowsazure\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117\",\"name\":\"shakir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"caption\":\"shakir\"},\"sameAs\":[\"https:\/\/azure.microsoft.com\"],\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Row-Level Security is now supported for Microsoft Azure SQL Data Warehouse | Microsoft Azure Blog","description":"Today we\u2019re announcing general availability of Row-Level Security (RLS) for Azure SQL Data Warehouse, an additional capability for managing security for sensitive data.","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:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/","og_locale":"en_US","og_type":"article","og_title":"Row-Level Security is now supported for Microsoft Azure SQL Data Warehouse | Microsoft Azure Blog","og_description":"Today we\u2019re announcing general availability of Row-Level Security (RLS) for Azure SQL Data Warehouse, an additional capability for managing security for sensitive data.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2018-11-07T00:00:00+00:00","article_modified_time":"2025-04-29T22:02:46+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/003f5372-d3bb-42d5-ad19-a3d427c5abb7.webp","type":"","width":"","height":""}],"author":"Microsoft Azure","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Microsoft Azure","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/","@type":"Person","@name":"Microsoft Azure"}],"headline":"Row-Level Security is now supported for Microsoft Azure SQL Data Warehouse","datePublished":"2018-11-07T00:00:00+00:00","dateModified":"2025-04-29T22:02:46+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/"},"wordCount":577,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/003f5372-d3bb-42d5-ad19-a3d427c5abb7.webp","articleSection":["Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/","name":"Row-Level Security is now supported for Microsoft Azure SQL Data Warehouse | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/003f5372-d3bb-42d5-ad19-a3d427c5abb7.webp","datePublished":"2018-11-07T00:00:00+00:00","dateModified":"2025-04-29T22:02:46+00:00","description":"Today we\u2019re announcing general availability of Row-Level Security (RLS) for Azure SQL Data Warehouse, an additional capability for managing security for sensitive data.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/003f5372-d3bb-42d5-ad19-a3d427c5abb7.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/11\/003f5372-d3bb-42d5-ad19-a3d427c5abb7.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/row-level-security-is-now-supported-for-azure-sql-data-warehouse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Analytics","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/analytics\/"},{"@type":"ListItem","position":3,"name":"Row-Level Security is now supported for Microsoft Azure SQL Data Warehouse"}]},{"@type":"WebSite","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","name":"Microsoft Azure Blog","description":"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.","publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization","name":"Microsoft Azure Blog","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","width":512,"height":512,"caption":"Microsoft Azure Blog"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/microsoftazure","https:\/\/x.com\/azure","https:\/\/www.instagram.com\/microsoftdeveloper\/","https:\/\/www.linkedin.com\/company\/16188386","https:\/\/www.youtube.com\/user\/windowsazure"]},{"@type":"Person","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117","name":"shakir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4","url":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","caption":"shakir"},"sameAs":["https:\/\/azure.microsoft.com"],"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/"}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Azure Blog","distributor_original_site_url":"https:\/\/azure.microsoft.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/2024","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=2024"}],"version-history":[{"count":1,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/2024\/revisions"}],"predecessor-version":[{"id":40052,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/2024\/revisions\/40052"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=2024"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=2024"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=2024"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=2024"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=2024"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=2024"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=2024"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=2024"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=2024"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}