Forum Discussion

TsT89's avatar
TsT89
Copper Contributor
Mar 27, 2020

Kusto Ingestion policy

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.

Thanks,

Thomas

1 Reply

  • Tzvia's avatar
    Tzvia
    Icon for Microsoft rankMicrosoft
    Mar 29, 2020

    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 

     

Resources