Interface to 'Kusto'/'Azure Data Explorer'
![[R logo]](../../../doc/html/Rlogo.svg)
![[Up]](../../../doc/html/left.jpg)
![[Top]](../../../doc/html/up.jpg)
Documentation for package ‘AzureKusto’ version 1.1.3
Help Pages
A B C D E F G I K L N O R S T U
-- A --
| add_op_join | Append a join operation to the tbl_kusto object's ops list |
| add_op_set_op | Append a set operation to the tbl_kusto object's ops list |
| add_op_single | Append an operation representing a single-table verb to the tbl_kusto object's ops list |
| anti_join | Join methods for Kusto tables |
| anti_join.tbl_kusto_abstract | Join methods for Kusto tables |
| AzureKusto | DBI interface: connect to a Kusto cluster |
| AzureKusto-connection | DBI interface: connect to a Kusto cluster |
| AzureKusto_dbi | DBI interface to Kusto |
| az_kusto | Kusto/Azure Data Explorer cluster resource class |
| az_kusto_database | Kusto/Azure Data Explorer database resource class |
-- B --
| base_agg | Aggregation function translations |
| base_scalar | Scalar operator translations (infix and prefix) |
| base_window | Window function translations |
| build_kql | Build a KQL string. |
-- C --
| collect.tbl_kusto | Compile the preceding dplyr operations into a kusto query, execute it on the remote server, and return the result as a tibble. |
| compute.tbl_kusto | Execute the query, store the results in a table, and return a reference to the new table |
| copy_to.kusto_database_endpoint | 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. |
| create_azure_data_explorer | Create Kusto/Azure Data Explorer cluster |
| create_database | Kusto/Azure Data Explorer cluster resource class |
| create_kusto_cluster | Create Kusto/Azure Data Explorer cluster |
-- D --
| dbCanConnect-method | DBI interface: connect to a Kusto cluster |
| dbColumnInfo-method | DBI methods for Kusto queries and commands |
| dbConnect-method | DBI interface: connect to a Kusto cluster |
| dbCreateTable-method | DBI methods for Kusto table management |
| dbDisconnect-method | DBI interface: connect to a Kusto cluster |
| dbExecute-method | DBI methods for Kusto queries and commands |
| dbExistsTable-method | DBI methods for Kusto table management |
| dbFetch-method | DBI methods for Kusto queries and commands |
| dbGetQuery-method | DBI methods for Kusto queries and commands |
| dbListFields-method | DBI methods for Kusto queries and commands |
| dbListTables-method | DBI methods for Kusto table management |
| dbReadTable-method | DBI methods for Kusto table management |
| dbRemoveTable-method | DBI methods for Kusto table management |
| dbSendQuery-method | DBI methods for Kusto queries and commands |
| dbSendStatement-method | DBI methods for Kusto queries and commands |
| dbWriteTable-method | DBI methods for Kusto table management |
| delete_azure_data_explorer | Delete Kusto/Azure Data Explorer cluster |
| delete_database | Kusto/Azure Data Explorer cluster resource class |
| delete_kusto_cluster | Delete Kusto/Azure Data Explorer cluster |
| delete_kusto_cluster, | Delete Kusto/Azure Data Explorer cluster |
| delete_kusto_token | Manage AAD authentication tokens for Kusto clusters |
-- E --
| escape | Escape/quote a string. |
| export | Execute the Kusto query and export the result to Azure Storage. |
| export.kusto_database_endpoint | Execute the Kusto query and export the result to Azure Storage. |
| export.tbl_kusto | Execute the Kusto query and export the result to Azure Storage. |
-- F --
| flatten_query | Walks the tree of ops and builds a stack. |
| full_join | Join methods for Kusto tables |
| full_join.tbl_kusto_abstract | Join methods for Kusto tables |
-- G --
| get_azure_data_explorer | Get existing Kusto/Azure Data Explorer cluster |
| get_database | Kusto/Azure Data Explorer cluster resource class |
| get_kusto_cluster | Get existing Kusto/Azure Data Explorer cluster |
| get_kusto_token | Manage AAD authentication tokens for Kusto clusters |
-- I --
| ident | Flag a character string as a Kusto identifier |
| ident_q | Pass an already-escaped string to Kusto |
| ingest_adls1 | Ingestion functions for Kusto |
| ingest_adls2 | Ingestion functions for Kusto |
| ingest_blob | Ingestion functions for Kusto |
| ingest_local | Ingestion functions for Kusto |
| ingest_url | Ingestion functions for Kusto |
| inner_join | Join methods for Kusto tables |
| inner_join.tbl_kusto_abstract | Join methods for Kusto tables |
| is_kusto_cluster | Information functions |
| is_kusto_database | Information functions |
-- K --
| kql | Tag character strings as Kusto Query Language. Assumes the string is valid and properly escaped. |
| kql_aggregate | Return a function representing a KQL aggregation function |
| kql_build | Build the tbl object into a data structure representing a Kusto query |
| kql_build.op_mutate | 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_escape_ident | Escape a Kusto identifier with [' '] |
| kql_escape_ident_q | Pass through an already-escaped Kusto identifier |
| kql_escape_logical | Escape a Kusto logical value. Converts TRUE/FALSE to true / false |
| kql_escape_string | Escape a Kusto string by single-quoting |
| kql_infix | Return a function representing a scalar KQL infix operator |
| kql_prefix | Return a function representing a scalar KQL prefix function |
| kql_render | Render a set of operations on a tbl_kusto_abstract to a Kusto query |
| kql_translate_env | Build a kql_variant class out of the environments holding scalar and aggregation function definitions |
| kql_translator | Builds an environment from a list of R -> Kusto query language translation pairs. |
| kql_vector | Escape/quote a string. |
| kql_window | Return a function representing a KQL window function |
| kusto-DBI | DBI interface to Kusto |
| kusto_database_endpoint | Endpoints for communicating with a Kusto database |
| kusto_dbi | DBI interface to Kusto |
| kusto_export_cmd | 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. |
-- L --
| left_join | Join methods for Kusto tables |
| left_join.tbl_kusto_abstract | Join methods for Kusto tables |
| list_databases | Kusto/Azure Data Explorer cluster resource class |
| list_kusto_tokens | Manage AAD authentication tokens for Kusto clusters |
-- N --
| nest.tbl_kusto_abstract | Nest method for Kusto tables |
-- O --
| op_base | The "base case" operation representing the tbl itself and its column variables |
| op_double | A double-table verb, e.g. joins, setops |
| op_grps | Look up the applicable grouping variables for an operation based on the data source and preceding sequence of operations |
| op_single | A class representing a single-table verb |
| op_vars | Look up the applicable variables in scope for a given operation based on the data source and preceding sequence of operations |
-- R --
| right_join | Join methods for Kusto tables |
| right_join.tbl_kusto_abstract | Join methods for Kusto tables |
| run_query | Run a query or command against a Kusto database |
-- S --
| semi_join | Join methods for Kusto tables |
| semi_join.tbl_kusto_abstract | Join methods for Kusto tables |
| show_query.tbl_kusto_abstract | Translate a sequence of dplyr operations on a tbl into a Kusto query string. |
| summarise.tbl_kusto_abstract | Summarise method for Kusto tables |
-- T --
| tbl_kusto | A tbl object representing a table in a Kusto database. |
| translate_kql | Translate R expressions into Kusto Query Language equivalents. |
-- U --
| unnest.tbl_kusto_abstract | Unnest method for Kusto tables |