Global Queries - Is possible to define which one to use based for example on the value of a Grafana variable, dynamically?

[canob]

Hello everyone,

I created a Data Source variable on Grafana, with Infinity as its data source:

And I have two Infinity Data Sources configured:

I want to change between that two different Data Sources with the variable I created. For that, I defined a Global Querie for each of them on each Data Source I previously configured, but the problem is that, like I'm doing with the Data Source Variable, I cannot change dynamically too the Global Query, and I cannot use the same name/ID for both.

I need to use Global Query because I'm creating fixed columns and selecting specific fields/columns.

Maybe my only option is to use UQL?

Any help appreciated.

Thanks.

[canob]

Ended using UQL, in this way:

parse-json
| project "resources"
parse-json
| extend "IOC_type"="type", "IOC_value"="value", "timestamp"=todatetime("created_on")
| extend "customer"=strcat('$customer')
| extend "customer_id"=extract('(.*) - .*',1,'$customer')
| extend "tech"=strcat('Crowdstrike')
| extend "device"=strcat("customer_id",' - ', "tech")
| where "IOC_type" in (${list_type:singlequote})
| where "device" in (${device:singlequote})
| where "tech" in (${technology:singlequote})
| project "IOC_type", "IOC_value", "timestamp", "customer", "device"

With this, I can create the customer name dynamically. Maybe is not going to be enough if I need really different UQL queries, to obtain different field names (is there something like "IF" in UQL lenguage?), bot for now, it's ok.