Ingesting data using KQL management commands
In the previous section, we imported our English Premier League data and you may have noticed that over half of the columns were related to betting statistics. In this section, we will create a custom CSV mapping schema and exclude those columns.
We will also introduce some KQL management commands. Like SQL, KQL has two categories of commands – data and management. The data commands allow us to query our data and the management commands allow us to manage our clusters, databases, tables, and schemas. We will cover KQL in depth in the next chapter, Introducing Kusto Query Language.
The first step is to create a table with the columns that we are interested in. When creating tables, we use the .create table
command.
We will now specify our columns and their data types as shown in the following code snippet. Here, we are creating a table with clear column names and are not including any of the betting statistics. You may have...