Running kqlmagic in a python script.

[amaljithkuttamath]

expectation: is to use kql function in a python script.

from Kqlmagic import kql

kql("""appinsights://appid='xxx'; appkey='xxx'; alias='xxx' """)
page_view = f'''pageViews '''

kql(page_view).to_dataframe())

This works, however, is there a way to suppress the popup schema message (html) after authentication ?

opens in file location _C:/Users/xxx/kqlmagic/tempfiles/xxx/xxx/xxx.html

[lesleyxyz]

I am also wondering this, using Kqlmagic doesn't seem to have an easy way to use in regular python, which is weird because how else would I integrate this in business applications

[mbnshtck]

yes, you can set 'auto_popup_schema' option to false. Either with the environment variable KQLMAGIC_CONFIGURATION="auto_popup_schema=False" or when calling kql method set it to False kql("""appinsights://appid='xxx'; appkey='xxx'; alias='xxx' """, options={"auto_popup_schema": False})

[amaljithkuttamath]

Thank you @mbnshtck,

However, My use-case mostly is around Application Insights, Fortunately I found this REST-API implementation by Microsoft, (saved my day) Application Insights RESTAPI

Just leaving it out here, for anyone with a similar use-case.