Feature Request: Include "Open in Azure Data Explorer" link next to result

jruales commented 5 years ago

An "Open in Azure Data Explorer" link next to results would allow continuing the exploration of Kusto data in Data Explorer. This is especially important when the query has Python variables replaced into it, since then it's not possible to simply copy and paste the query into Data Explorer

mbnshtck commented 5 years ago

Good idea, will add it to our feature wish list. Thank you, Michael

jruales commented 5 years ago

Another similar ask is to have a way of showing the replaced query directly in the notebook, for example having a tabbed view that shows the table or plot on one tab and the underlying, replaced query on the other one

mbnshtck commented 5 years ago

What do you mean by replaced query? The query after it was parametrized? This exist: _kql_rawresult.parametrized_query

Michael

From: Joaquín Ruales notifications@github.com Sent: Thursday, August 8, 2019 11:32 PM To: microsoft/jupyter-Kqlmagic jupyter-Kqlmagic@noreply.github.com Cc: Michael Binshtock michabin@microsoft.com; Comment comment@noreply.github.com Subject: Re: [microsoft/jupyter-Kqlmagic] Feature Request: Include "Open in Azure Data Explorer" link next to result (#19)

Another similar ask is to have a way of showing the replaced query directly in the notebook, for example having a tabbed view that shows the table or plot on one tab and the underlying, replaced query on the other one

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fjupyter-Kqlmagic%2Fissues%2F19%3Femail_source%3Dnotifications%26email_token%3DACGKLXSLKBGJGX7QQPLWSUTQDSGGBA5CNFSM4IHGRJP2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD346Y3Q%23issuecomment-519695470&data=02%7C01%7Cmichabin%40microsoft.com%7Ca1e61a7a21a84d879fd408d71c47e31d%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637008967385963146&sdata=h80PS2RsB5sc89yAwxSUBBEURlZkRlZRm1%2B9wyh7hU4%3D&reserved=0, or mute the threadhttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FACGKLXWD52YWMUBYPVM6IQTQDSGGBANCNFSM4IHGRJPQ&data=02%7C01%7Cmichabin%40microsoft.com%7Ca1e61a7a21a84d879fd408d71c47e31d%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637008967385973139&sdata=q07ZO6CkfcBXrjZjeV2xF5yIu0XNHADHSkI1tmrWiQ4%3D&reserved=0.

jruales commented 5 years ago

I understand that _kql_raw_result_.parametrized_query exists. What I'm suggesting is to automatically show the parameterized query whenever we show a table or plot. As in, to have some button or tab mechanism to reveal/hide the parameterized query. This would have two advantages:

the possibility for having Kusto syntax highlighting in the shown query
not having to execute the extra command "_kql_rawresult.parametrized_query". For us, it will be especially helpful since we're executing the notebooks via Papermill and in the process are removing the input cells, so this addition would be an easy way to understand what Kusto query a visualization came from

mbnshtck commented 5 years ago

Excellent idea, will add this as an option to the query. Michael

From: Joaquín Ruales notifications@github.com Sent: Friday, August 9, 2019 12:32 AM To: microsoft/jupyter-Kqlmagic jupyter-Kqlmagic@noreply.github.com Cc: Michael Binshtock michabin@microsoft.com; Comment comment@noreply.github.com Subject: Re: [microsoft/jupyter-Kqlmagic] Feature Request: Include "Open in Azure Data Explorer" link next to result (#19)

Another similar ask is to have a way of showing the replaced query directly in the notebook, for example having a tabbed view that shows the table or plot on one tab and the underlying, replaced query on the other one

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fjupyter-Kqlmagic%2Fissues%2F19%3Femail_source%3Dnotifications%26email_token%3DACGKLXSLKBGJGX7QQPLWSUTQDSGGBA5CNFSM4IHGRJP2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD346Y3Q%23issuecomment-519695470&data=02%7C01%7Cmichabin%40microsoft.com%7Ca1e61a7a21a84d879fd408d71c47e31d%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637008967385963146&sdata=h80PS2RsB5sc89yAwxSUBBEURlZkRlZRm1%2B9wyh7hU4%3D&reserved=0, or mute the threadhttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FACGKLXWD52YWMUBYPVM6IQTQDSGGBANCNFSM4IHGRJPQ&data=02%7C01%7Cmichabin%40microsoft.com%7Ca1e61a7a21a84d879fd408d71c47e31d%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637008967385973139&sdata=q07ZO6CkfcBXrjZjeV2xF5yIu0XNHADHSkI1tmrWiQ4%3D&reserved=0.

mbnshtck commented 5 years ago

This feature was added in Kqlmagic version 0.1.102 To use it use option -show_query (or abbreviation -sq) with the query. For example: %kql -sq {your query}

If you want it to be the default you can change the default as follow: %config Kqlmagic.show_query=True

You can also make it the default outside of the notebook, by setting the environment variable: KQLMAGIC_CONFIGURATION=’show_query=True’

btw: KQLMAGIC_CONFIGURATION environment variable can have many options set to custom defaults, separated by ‘;’ for example: KQLMAGIC_CONFIGURATION=’show_query=True; show_query_time=False’

Michael

From: Joaquín Ruales notifications@github.com Sent: Wednesday, August 14, 2019 12:03 AM To: microsoft/jupyter-Kqlmagic jupyter-Kqlmagic@noreply.github.com Cc: Michael Binshtock michabin@microsoft.com; Comment comment@noreply.github.com Subject: Re: [microsoft/jupyter-Kqlmagic] Feature Request: Include "Open in Azure Data Explorer" link next to result (#19)

I understand that _kql_rawresult.parametrized_query exists. What I'm suggesting is to automatically show the parameterized query whenever we should a table or plot. As in, to have some button or tab mechanism to reveal/hide the parameterized query. This would have two advantages:

the possibility for having Kusto syntax highlighting in the shown query
not having to execute the extra command "kql_raw_result.parametrized_query". For us, it will be especially helpful since we're executing the notebooks via Papermill and in the process are removing the input cells, so it would be an easy was to understand what Kusto query a visualization came from

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fjupyter-Kqlmagic%2Fissues%2F19%3Femail_source%3Dnotifications%26email_token%3DACGKLXWBXCYEHA2ULNEATUTQEMOO5A5CNFSM4IHGRJP2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD4G7G4A%23issuecomment-521007984&data=02%7C01%7Cmichabin%40microsoft.com%7C60e2ec89ef2b453836dd08d7203192e6%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637013269602235193&sdata=yBWTRz0nMB3RC%2BbfjJBoECLA8%2B4HTgQwqCeZcf4SyxA%3D&reserved=0, or mute the threadhttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FACGKLXR3N2YIR4VNLQWG75LQEMOO5ANCNFSM4IHGRJPQ&data=02%7C01%7Cmichabin%40microsoft.com%7C60e2ec89ef2b453836dd08d7203192e6%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637013269602245193&sdata=gNIpKqTxD3mJNJVr%2FeJVNUNYhYwmkg1iswZqQsEFsJw%3D&reserved=0.

jruales commented 5 years ago

I've just tried it and it works great! I'm wondering if you've considered adding the "Open in Azure Data Explorer" link? the format for those URLs is relatively simple, since it's possible to simply include the UTF-8 base64 encoded query in the URL itself

mbnshtck commented 5 years ago

Feature was added in version 0.1.103. Download latest version of Kqlmagic, click on 'what's new button in the Kqlmagic init banner, to see the details of version 0.1.103. To support it two option were added, show_query_link (default False, abbreviation sql) and query_link_destination (default "Kusto.webexplorer", abbreviation dlq). To activate it on a query use %kql -sql {your query} you can also modify the defaults using %config

microsoft / jupyter-Kqlmagic

Feature Request: Include "Open in Azure Data Explorer" link next to result #19