Azure Data Lake Analytics - Accessing External Sources with USQL

[@TheRocksportsArena]

Nicely explained

[@amitjaju9060]

Hello Sir, I am seeing all your videos and all are very knowledgeable. I have below query could you please help me with these. I have 1 external table conatins 10 columns which reads data from processing blob file .But external table unable to read the blob file because few rows has 9 fields and few have 10 and this is happening because last column if no data then no delimeter coming for that from Source..So how can we assign last filed as NULL if not present through external table. Thanks in advance

[@rkvvrkvarma]

Hi Dinesh !! Firstly, I would like to congratulate you for this awesome videos on ADF v2 !! I would really appreciate if you can let me know whether we can perform Upsert mechanism at the pipeline level without executing any stored procedures!! Thanks again for this wonderful video series

[@DineshPriyankara]

Thanks Venkata. Unfortunately, we cannot have UPSERT operations without using a compute environment. If your source data is in data lake, you can use ADLA (better avoid it) or Databricks or HDInsight for handling such operations, if not, SP is the only option.

[@998595998595]

Hi Dinesh, Can you explain how to set credentials through AAD integrated authentication?

[@DineshPriyankara]

Hi Ravi, Is it for SQL Server? Or ADLS?

[@998595998595]

Dinesh Priyankara For SQL server

[@DineshPriyankara]

I believe that you have already created AAD and users in AAD. In order to get your Azure SQL Database authenticated using AAD users, first you need to make one AAD user as an admin and then use it for adding other users. Here are the steps; 1. Get your sql server opened using the portal and click "Active Directory Admin" page in left pane. It allows you to search AAD users and add one as an admin. 2. Use that AAD user to log in sql server using Management Studio. You need to select "Active Directory - Password" as authentication and enter user id (something like [e-mail]) and password for logging in. 3. Once logged in, use CREATE USER statement for adding more AAD users (Ex. CREATE USER [[e-mail]] FROM EXTERNAL PROVIDER; 4. Add user to relevant roles using sp_addrolemember. Hope it is clear.

[@998595998595]

Dinesh Priyankara Hi Dinesh, Here in the -credential parameter it is mentioned as Get-credential(interactive login). As per my understanding we need to pass PSCredential object type where it needs the information of username and password(as secure string). I am already the user of AAD and have integrated authentication to connect to azure database (which actually doesnt need username andpassword). I want to create Analytics catalog credential as an AAD integrated user.