Kusto Ingestion policy

Copper Contributor

Hi everybody,

I connected the Azure Data Explorer to the IoT Hub and map recieved data to my table, everythings works fine.

However, some messages include values that i dont want to include in my database.

Is there a way to filter before ingestion which data is ingested into the database and which not?


Happy for any help.



1 Reply

@TsT89 hey 


1. you can filer data out with mapping (you can ignore specific columns)

2. filter after ingestion can be done by using update policies 

you can create ingestion table with retention 0 and a destination table as you need