I have a Kusto table, which has incoming streaming data. However, I need to store the aggregates per day in another table. Is there a way to run scheduled functions in Kusto which for example runs at midnight and ingests the result into an aggregate table? If no, how can I achieve my goal? Are there some connectors available with which I can achieve this?
Materialized views is the ideal solution for it. Please note that materialized views over table with streaming data is now in private preview so you will need to open a support ticket for it. See the applicable comment in "create materialized views" document:
Materialized views over streaming ingestion tables are supported in preview mode. Enabling this feature on your cluster requires creating a support ticket.