Provide data lake access with Azure Synapse Analytics

Using a lake database with Azure Synapse Analytics and struggling to figure out permissions needed for your data readers? Patrick and Adam show you what's missing! - Azure Synapse Access Control [https://learn.microsoft.com/azure/synapse-analytics/security/synapse-workspace-access-control-overview] - How to set up access control for your Azure Synapse workspace [https://learn.microsoft.com/azure/synapse-analytics/security/how-to-set-up-access-control] * Control storage account access for serverless SQL pool in Azure Synapse Analytics [https://learn.microsoft.com/azure/synapse-analytics/sql/develop-storage-files-storage-access-control?tabs=user-identity] ## Azure Synapse Analytics Azure Synapse Analytics is a cloud-based data warehouse and analytics service from Microsoft. It enables organizations to store, process, analyze and visualize large amounts of data in the Azure Data Lake. With its advanced security features, it helps protect sensitive data while providing fast query performance for customers. Additionally, it allows users to combine structured and semi-structured data sources into one unified view with integrated machine learning capabilities that enable predictive insights. By using Azure Synapse Analytics customers can easily access their data lake with controlled access rights based on user roles or groups. This means that different users or teams in an organization can have different levels of access depending on their job function or responsibilities within the company. ## More links on about Power Platform/Power BI - [Ingest data into Azure Data Lake Storage Gen2 - Microsoft Learn](https://learn.microsoft.com/en-us/azure/synapse-analytics/data-integration/data-integration-data-lake) Sep 13, 2022 — Azure Synapse Analytics provides a shared metadata model where creating a lake database in an Apache Spark pool will make it accessible from its ... - [Tutorial: Azure Data Lake Storage Gen2, Azure Synapse](https://learn.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-use-sql) Dec 19, 2022 — This tutorial shows how to run SQL queries on an Azure Synapse serverless SQL endpoint to access data in an Azure Data Lake Storage Gen2 ... - [Create an Azure Synapse Link for Dataverse with Azure Data ...](https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-data-lake) Jan 18, 2023 — Connect your Dataverse data to your Azure Data Lake Storage Gen2 account with the Azure Synapse Link service. · Manage Dataverse tables included ...