Error when editing queries with v3.0 or higher: Could not load datasource schema: [object Object]

grafana / azure-data-explorer-datasource

Grafana datasource plugin for Microsoft Azure Data Explorer (formerly Azure Kusto)

Apache License 2.0

49 stars 40 forks source link

Error when editing queries with v3.0 or higher: Could not load datasource schema: [object Object] #144

Closed L3bannen closed 3 years ago

L3bannen commented 4 years ago

With plugin version 3.0 or higher I can't edit queries, instead I get an error.

I connect to the datasource just fine, but when I want do a new query, the field doesn't appear and I get the error

Could not load datasource schema: [object Object] grafana_error_datasource

I tried using older version of grafana but it doesn't change anything with my problem so it seems to be something that changed since 3.0.

Is there a workaround to this issue?

My data source is playfab, I have no issues when using Azure Data Explorer directly or older versions (2.x.x) of the Azure data explorer datasource.

I'm sorry if this was already resolved elsewhere, tried to search everywhere but couldn't find anything.

mckn commented 4 years ago

Thanks for reporting this. To be able to help you to resolve this I would need some more information from the network tab in your browser. Could you please send me the response on the following request?

L3bannen commented 4 years ago

Is this helpful ?

L3bannen commented 4 years ago

I tried running the same command from Azure Explorer directly and it does respond with an error as well:

Unsupported management command: .show databases schema as json

mckn commented 4 years ago

I tried running the same command from Azure Explorer directly and it does respond with an error as well:

Unsupported management command: .show databases schema as json

Perfect thanks! I will look into this asap.

mckn commented 4 years ago

@zivcaspi do you know in what version of ADX this command was added?

https://docs.microsoft.com/en-us/azure/data-explorer/kusto/management/show-schema-database

And do you know what version the playfab is running?

L3bannen commented 4 years ago

Hello,

If that can help: the command .show databases schema does work on the version playfab is running. It seems it doesn't like the "as json" part.

Let me know if you want me to try anything.

Cheers

mckn commented 4 years ago

Ah, super! That helps a lot. I will try to fix this to the next release. Thanks for the help 🙏

sloutsky commented 3 years ago

@L3bannen - can you please elaborate which cluster / data source you are working with? All Kusto (ADX) clusters support this command - and if playfab mid-tier/proxy is blocking this command - we can get in touch with them to get it completed.

@mckn : I would not recommend using .show databases schema command, as it has significantly worse performance when it comes to clusters with many databases.

L3bannen commented 3 years ago

@sloutsky Here is the cluster URL: https://insights.playfab.com/

Playfab is part of Microsoft (and has now been renamed "Azure playfab" https://playfab.com/ )

Here is the official documentation from Microsoft to connect grafana to playfab: https://docs.microsoft.com/en-us/gaming/playfab/features/insights/connectivity/connecting-grafana-to-insights

I checked this morning and the command .show databases schema as json still doesn't work.

Hope it helps.

grilme99 commented 3 years ago

I am also having trouble with this when using PlayFab like @L3bannen. I am on the https://insights.rblx.playfab.com cluster, however. Is there any sort of workaround until this can be fixed?

I too am receiving the Unsupported management command: .show databases schema as json error.

Thanks!

sunker commented 3 years ago

@gabilehner it seems like Playfab is using an old version of ADX. This is not something we can fix or provide a workaround for on our side, right?