KQL log analysis
KQL is a case-sensitive language, and it is very similar to Transact-SQL (T-SQL). You can run single statements or organize them in a query by specifying a pipe sign (|) between each single operator.
You could consider your Application Insights resource as your database and signals as stored in tables in this database. If you look at the left side of the Logs whiteboard, you will notice a list of tables. There are two where Dynamics 365 Business Central sends signals: pageViews and traces. pageViews collects information related to pages opened within the environment, while the rest of the signals are all collected in the traces table.
Double-click on pageViews; it will add the table name on the whiteboard so that you can run it as a KQL query statement returning the entire table record set.
If you expand any of these two tables, you will see the metadata structure definition for the ingestion tables and their column data types.
Figure 11.6: Column...
