3 replies
by rproffitt edited
Try the word INGEST rather than IMPORT?
I'm reading https://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-wizard
by priyalkaur31 edited
To import data from Azure Table Storage into Azure Data Explorer (ADX) without using Azure Data Factory, you can utilize the Kusto Managed Tables feature in ADX along with a script written in .NET to programmatically move data. Here's a high-level outline of the steps you can follow:
Create a Managed Table in Azure Data Explorer:
Create a new managed table in your Azure Data Explorer cluster where you want to import the data from Azure Table Storage.
Use .NET SDK for Table Storage:
You can use the Azure SDK for .NET to connect to your Azure Table Storage and retrieve the data. You will need to install the Microsoft.Azure.Cosmos.Table NuGet package.
Transform Data:
Depending on the structure of your data, you may need to transform it to match the schema of your Azure Data Explorer table.
Batching and Ingestion:
Azure Data Explorer provides the .ingest inline command which can be used to ingest data. You can use the Kusto Data Ingestion .NET SDK to execute this command programmatically.
Ingest Data into Managed Table:
Use the .ingest inline command to insert the data into the managed table you created in step 1. The command supports JSON, CSV, and TSV formats.
by Ayesha Sanan edited
This discussion is closed to new replies.
Trending Software posts
Sort by Trending