Notes: Azure Synapse
Last updated
Was this helpful?
Last updated
Was this helpful?
Was this helpful?
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://users@contosolake.dfs.core.windows.net/NYCTripSmall.parquet
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
Basic Admin setup:
Best Practice:
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;Default API Permissions on New App Registration
Testing out Admin Consent:
