CODEWITHSUNDEEP
kqlazure-data-explorerexternal-tables
Werner
Werner

Reputation: 160

ADX external tables - connect an ADLSgen2 Table `?

Is it possible to create a Kusto external table that is connected to an Azure storage account ?

The idea is not to connect a csv or parquet file in a container, but an ADLSgen2 Table like this:

.create external table ExternalTable (PartitionKey: string, RowKey:string, Timestam:datetime, col1:string, col2:string) 
kind=storage  
dataformat=table
(   h@'https://storageaccount.blob.core.windows.net/mytable;secretKey')

enter image description here

Upvotes: 0

Views: 102

Answers (1)

Yoni L.
Yoni L.

Reputation: 25955

If I understand correctly, you're asking about Azure Table Storage - that is not supported as a source for an external table in Kusto.

If you choose to do so, you can ingest the data from the Azure Table into Kusto (e.g. using Azure Data Factory).

Upvotes: 1

Related Questions