kusto-DBI function

DBI interface to Kusto

AzureKusto implements a subset of the DBI specification for interfacing with databases in R. The following methods are supported:

• Connections: dbConnect , dbDisconnect , dbCanConnect
• Table management: dbExistsTable , dbCreateTable , dbRemoveTable , dbReadTable , dbWriteTable
• Querying: dbGetQuery , dbSendQuery , dbFetch , dbSendStatement , dbExecute , dbListFields , dbColumnInfo

Details

Kusto is quite different to the SQL databases that DBI targets, which affects the behaviour of certain DBI methods and renders other moot.

• Kusto is connectionless. dbConnect simply wraps a database endpoint object, created with kusto_database_endpoint . Similarly, dbDisconnect always returns TRUE. dbCanConnect attempts to check if querying the database will succeed, but this may not be accurate.
• Temporary tables are not a Kusto concept, so dbCreateTable(*, temporary=TRUE) will throw an error.
• It only supports synchronous queries, with a default timeout of 4 minutes. dbSendQuery and dbSendStatement will wait for the query to execute, rather than returning immediately. The object returned contains the full result of the query, which dbFetch extracts.
• The Kusto Query Language (KQL) is not SQL, and so higher-level SQL methods are not implemented.