Notes: Azure Synapse

Quickstart tutorial

Quickstart: Get started - create a Synapse workspace - Azure Synapse Analyticsdocsmsft

Troubleshoot Azure Data Factory Studio - Azure Data Factorydocsmsft

Notes:

What is abfss ? (https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-abfs-driver)

• https://contosolake.dfs.core.windows.net/users/NYCTripSmall.parquet

• abfss://[e-mail]/NYCTripSmall.parquet

Tutorial: Get started analyze data with a serverless SQL pool - Azure Synapse Analyticsdocsmsft

Copy and transform data in Azure Data Lake Storage Gen2 - Azure Data Factory & Azure Synapsedocsmsft

Concepts

What is a server in Azure SQL Database and Azure Synapse Analytics?docsmsft

Username and Password

DATA_SOURCE = 'TabLake',

data_explorer WITH PASSWORD = 'My Very Strong Password that I like to use all the time, everywhere';

DataExplorationDB

tab-synapses-ondemand.sql.azuresynapse.net

Tested Connecting with OAuth

Basic Admin setup:

Quickstart: Get started add an Administrator - Azure Synapse Analyticsdocsmsft

Best Practice:

How to set up access control for your Synapse workspace - Azure Synapse Analyticsdocsmsft

Error "Authentication failed" When Connecting to Azure Data Lake Storage Gen2 | Tableau Software

[Recorded Webcast] Tableau and Microsoft Azure Synapse AnalyticsThorogood

Configure Azure Active Directory authentication - Azure SQL Database & SQL Managed Instance & Azure Synapse Analyticsdocsmsft

SQL on-demand pools in Azure Synapse AnalyticsSQL Shack - articles about database auditing, server performance, data recovery, and more

SQL Roles and Permissions

Configure Azure Active Directory authentication - Azure SQL Database & SQL Managed Instance & Azure Synapse Analyticsdocsmsft

Database users (with the exception of administrators) cannot be created using the Azure portal. Azure roles are not propagated to the database in SQL Database, the SQL Managed Instance, or Azure Synapse. Azure roles are used for managing Azure Resources, and do not apply to database permissions. For example, the SQL Server Contributor role does not grant access to connect to the database in SQL Database, the SQL Managed Instance, or Azure Synapse. The access permission must be granted directly in the database using Transact-SQL statements.

To create a contained database user representing an Azure AD or federated domain group, provide the display name of a security group:

CREATE USER [ICU Nurses] FROM EXTERNAL PROVIDER;

Connecting using Azure Active Directory authentication - JDBC Driver for SQL Serverdocsmsft

App Registration

Default API Permissions on New App Registration

Testing out Admin Consent: