22. Create Login and User for Server less SQL Pool in Azure Synapse Analytics

[@deepak0417]

Wait is worth. You bring value in your sessions. I eagerly wait for it.

[@WafaStudies]

Thank you 😊

[@justair07]

Hello - what would a use case be for creating the SQL user? From my experience, the a SQL user can not query from a datalake in serverless which is a primary purpose for serverless. Thoughts?

[@sushmithashetty3436]

I have the same question.. what is the need of SQL Server Authentication when it cannot read from external tables

[@f4bglv]

Thanks a lot Maheer, this video is very very useful. I was wondering how you can grant your "mary" user with the access to the external tables - without permissions, their content cannot be listed.

[@aricamarao4144]

How?

[@guru1234prasad6789]

Thanks Maheer. I love your series on ADF, Azure Functions and Azure Synapse. If I have any questions, I will reach out to you. Thanks again for your hard work. Regards, Guru

[@WafaStudies]

Welcome 🤗

[@stoyyeti3671]

@@WafaStudies I have to load fact table from parquet files available under mutiple subfolders under folder1/folder2. After doing initial load subsequent runs should do only delta load . How to achieve this in databricks . Please suggest.

[@LearnFunWithYashasvi-ut9jh]

@WafaStudios I am not able to access the Storage Account using the System Assigned Managed Identity , I have already assigned the Contributor role to System Assigned managed identity.

[@sangeethasubburaj-er6kq]

Thanks a lot for useful video..I have built in sql pool which has database created in portal but I could not see the database name same in SSMS..can you help me on this

[@karthikinu]

Got what i required, Thank you!!!

[@WafaStudies]

Thank you ☺️

[@followmanish]

how can we use above login credentials in a python script to fetch the table content locally??

[@AshutoshThakur-g6u]

Hi, I am not able to create external table using pipeline with storedprocedure but can do it manually can u help me

[@sampathmessi]

Can we create multiple login and users to serverless sql pool instead of adding each user one at a time?

[@garymelhaff7779]

Serverless is all about access to external sources such as datalake. Why would you talk about the easy part that's no different than any other Sql db and not address what's unique which is access to underlying/external data? So confused why you'd bother doing this when what you talked about is 100% same as any sql db.