I want to create a permanent table in azure monitor KQL environment. Are clients have informal and formal names and I need to drag back the formal name and normal Id just create a table

Yes I know I could get a repeating SQL to send it daily but this seems super silly method

I want to send it once and just say there - are there any suggestions?

I want to create a permanent table in azure monitor KQL environment. Are clients have informal and formal names and I need to drag back the formal name and normal Id just create a table

Yes I know I could get a repeating SQL to send it daily but this seems super silly method

I want to send it once and just say there - are there any suggestions?

• azure
• kql

• Have you tried any query so far! @Symon Turner – Jahnavi Commented Feb 7 at 11:05
• 1 No but I don't think it's a query issue. KQL code can't perist data into a table as far as I know. If you have KQL that does please provide – Symon Turner Commented Feb 8 at 12:59

1 Answer 1

In Azure Monitor, it is not possible to create permanent tables unlike in SQL. Instead, you can create a custom table under Log Analytics which can be used for sending and retrieving logs and can also apply all the relevant data policies or retention periods to it according to the requirement.

Refer MSDoc for the same detailed information.

To create a custom table, follow the below process.

Go to Monitor >> Log Analytics Workspaces >> Tables >> Create

Now, choose custom log (Dcr-based) table which set up data collection rules for data ingestion. Once, it is done provide the custom table and the relevant DCR details (existed or create new one) and now provide a sample data of logs in the schema column as shown.

The custom table has been created successfully in the below way.

Note: You can be able to edit the schema and also manage the table properties or fields accordingly even after the table creation.