External Table Read Data From File Blob Storage in Kusto Query | Kusto Query Language Tutorial 2022

Topic: External Table Read Data From File Blob Storage in Kusto Query

In this article, we are going to learn about the Eeternaldata operator. The externaldata operator returns a table whose schema is defined in the query itself, and whose data is read from an external storage artifact, such as a blob in Azure Blob Storage or a file in Azure Data Lake Storage. Kusto Query Language is a powerful tool to explore your data and discover patterns, identify anomalies and outliers, create statistical modeling, and more.

 // externaldata operator : The externaldata operator returns a table whose schema is defined in the query itself,   
 //and whose data is read from an external storage artifact, such as a blob in Azure Blob Storage or a file in Azure Data Lake Storage.  
   
 //Sample Code  
 externaldata (UserID:string) [  
   @"https://storageaccount.blob.core.windows.net/storagecontainer/users.txt"   
    h@"?...SAS..." // Secret token needed to access the blob  
   ]  
   
   //Generate SAS for File in Blob Storage  
 externaldata (Id:int,FName:string,LName:string) [  
   @"https://ashahzadblobstorage.blob.core.windows.net/input/Customer.txt"   
    h@"?sp=r&st=2021-11-26T18:08:41Z&se=2021-11-27T02:08:41Z&spr=https&sv=2020-08-04&sr=b&sig=zwx8IKwChrcCNwVi73fGrn29nXHlAbAfSz%2FAJHaYGwE%3D" // Secret token needed to access the blob  
   ]  
   with (ignoreFirstRecord=true)  
   
   

Video Demo: External Table Read Data From File Blob Storage in Kusto Query