Small question: Does someone know if it is possible to expose Kusto functions (Azure Data Explorer) as views via JDBC. Background:
- We have some (3rd Party cannot change) tools that can connect to JDBC targets. Unfortunately, most of them are not able to see or use procedures/functions, but operate only on views and tables.
- We have some quite complicated queries implemented in KQL which we would like to use in those tools and cannot be easily done in SQL.
Kusto functions are exposed as procedures by the JDBC-Driver. Is there a way to specify that some functions are exported as views (which they are, semantically?). We have not found anything in the documentation.
Kusto stored functions are indeed modelled in SQL metadata views and stored procedures as stored procedures or/and functions, aka routines (see sys.sp_stored_procedures, information_schema.routines).
Saying that, if KQL function doesn't have parameters, SQL query from it, like it was a view, would work, e.g.: select * from kusto.MyFunction