| Append a join operation to the tbl_kusto object's ops list | add_op_join |
| Append a set operation to the tbl_kusto object's ops list | add_op_set_op |
| Append an operation representing a single-table verb to the tbl_kusto object's ops list | add_op_single |
| Kusto/Azure Data Explorer cluster resource class | az_kusto create_database delete_database get_database list_databases |
| Kusto/Azure Data Explorer database resource class | az_kusto_database |
| DBI interface: connect to a Kusto cluster | AzureKusto AzureKusto-connection dbCanConnect,AzureKustoDriver-method dbConnect,AzureKustoDriver-method dbDisconnect,AzureKustoDriver-method |
| Aggregation function translations | base_agg |
| Scalar operator translations (infix and prefix) | base_scalar |
| Window function translations | base_window |
| Build a KQL string. | build_kql |
| Compile the preceding dplyr operations into a kusto query, execute it on the remote server, and return the result as a tibble. | collect.tbl_kusto |
| Execute the query, store the results in a table, and return a reference to the new table | compute.tbl_kusto |
| This function uploads a local data frame into a remote data source, creating the table definition as needed. If the table exists, it will append the data to the existing table. If not, it will create a new table. | copy_to.kusto_database_endpoint |
| Create Kusto/Azure Data Explorer cluster | create_azure_data_explorer create_kusto_cluster |
| DBI methods for Kusto queries and commands | dbColumnInfo,AzureKustoResult-method dbExecute,AzureKustoConnection,character-method dbFetch,AzureKustoResult-method dbGetQuery,AzureKustoConnection,character-method dbListFields,AzureKustoConnection,character-method dbSendQuery,AzureKustoConnection-method dbSendStatement,AzureKustoConnection,character-method |
| DBI methods for Kusto table management | dbCreateTable,AzureKustoConnection-method dbExistsTable,AzureKustoConnection,ANY-method dbListTables,AzureKustoConnection-method dbReadTable,AzureKustoConnection,character-method dbRemoveTable,AzureKustoConnection,ANY-method dbWriteTable,AzureKustoConnection,ANY-method |
| Delete Kusto/Azure Data Explorer cluster | delete_azure_data_explorer delete_kusto_cluster delete_kusto_cluster, |
| Escape/quote a string. | escape kql_vector |
| Execute the Kusto query and export the result to Azure Storage. | export export.kusto_database_endpoint export.tbl_kusto |
| Walks the tree of ops and builds a stack. | flatten_query |
| Get existing Kusto/Azure Data Explorer cluster | get_azure_data_explorer get_kusto_cluster |
| Manage AAD authentication tokens for Kusto clusters | delete_kusto_token get_kusto_token list_kusto_tokens |
| Flag a character string as a Kusto identifier | ident |
| Pass an already-escaped string to Kusto | ident_q |
| Ingestion functions for Kusto | ingest_adls1 ingest_adls2 ingest_blob ingest_local ingest_url |
| Join methods for Kusto tables | anti_join anti_join.tbl_kusto_abstract full_join full_join.tbl_kusto_abstract inner_join inner_join.tbl_kusto_abstract left_join left_join.tbl_kusto_abstract right_join right_join.tbl_kusto_abstract semi_join semi_join.tbl_kusto_abstract |
| Information functions | is_kusto_cluster is_kusto_database |
| Tag character strings as Kusto Query Language. Assumes the string is valid and properly escaped. | kql |
| Return a function representing a KQL aggregation function | kql_aggregate |
| Build the tbl object into a data structure representing a Kusto query | kql_build |
| dplyr's mutate verb can include aggregations, but Kusto's extend verb cannot. If the mutate contains no aggregations, then it can emit an extend clause. If the mutate contains an aggregation and the tbl is ungrouped, then it must emit a summarize clause grouped by all variables. If the mutate contains an aggregation and the tbl is grouped, then it must join to a subquery containing the summarize clause. | kql_build.op_mutate |
| Escape a Kusto identifier with [' '] | kql_escape_ident |
| Pass through an already-escaped Kusto identifier | kql_escape_ident_q |
| Escape a Kusto logical value. Converts TRUE/FALSE to true / false | kql_escape_logical |
| Escape a Kusto string by single-quoting | kql_escape_string |
| Return a function representing a scalar KQL infix operator | kql_infix |
| Return a function representing a scalar KQL prefix function | kql_prefix |
| Render a set of operations on a tbl_kusto_abstract to a Kusto query | kql_render |
| Build a kql_variant class out of the environments holding scalar and aggregation function definitions | kql_translate_env |
| Builds an environment from a list of R -> Kusto query language translation pairs. | kql_translator |
| Return a function representing a KQL window function | kql_window |
| Endpoints for communicating with a Kusto database | kusto_database_endpoint |
| Execute the query, store the results in a table, and return a reference to the new table Run a Kusto query and export results to Azure Storage in Parquet or CSV format. | kusto_export_cmd |
| DBI interface to Kusto | AzureKusto_dbi kusto-DBI kusto_dbi |
| Nest method for Kusto tables | nest.tbl_kusto_abstract |
| The "base case" operation representing the tbl itself and its column variables | op_base |
| A double-table verb, e.g. joins, setops | op_double |
| Look up the applicable grouping variables for an operation based on the data source and preceding sequence of operations | op_grps |
| A class representing a single-table verb | op_single |
| Look up the applicable variables in scope for a given operation based on the data source and preceding sequence of operations | op_vars |
| Run a query or command against a Kusto database | run_query |
| Translate a sequence of dplyr operations on a tbl into a Kusto query string. | show_query.tbl_kusto_abstract |
| Summarise method for Kusto tables | summarise.tbl_kusto_abstract |
| A tbl object representing a table in a Kusto database. | tbl_kusto |
| Translate R expressions into Kusto Query Language equivalents. | translate_kql |
| Unnest method for Kusto tables | unnest.tbl_kusto_abstract |
