Is your feature request related to a problem? Please describe.
Grafana Live streaming datasource plugins enable real time subscription to backends; eliminating polling, reducing latency and reducing requests. It should work well with Firestore subscription to collections and queries.

Describe the solution you'd like
Implement the interface described here
https://grafana.com/tutorials/build-a-streaming-data-source-plugin

Describe the solution you'd like
Right now the plugin doesn't support Grafana template variables. It would be really useful to have this feature, because right now, I have to create separate dashboards for collections. A variables which queries the collection names, or even "Custom" type variable support for queries would be great to have.

Additional context

These days I wanted to connect the plugin to Grafana but I have not been able to because it has been updated to version 10. I would like to know if there will be support for this version in the near future. Thank you very much!

First of all: thank you for building such a cool plugin!

I'm developing an app using the local Firebase eumlators, including the local Firestore emulator. I want to use Grafana to query some documents on that local Firestore DB. The problem: when configuring this plugin, I don't see an option to tell it to connect to the local Firestore instance. I can only configure a name, projectId and the service account details.

Ideally, I could "flip a switch" and tell the plugin to connect to the local instance using a local URL like
"http://localhost:8080"

Thanks
Kurt

Describe the bug
I am trying to run the following query, select * from orders, in order to get the corresponding data but it does not work and in the query inspector it says the following:

{
"request": {...},
"response": {
"message": "An error occurred within the plugin",
"messageId": "plugin.downstreamError",
"statusCode": { "statusCode": 500,
"traceID": "56cf6ca5699814f9"
}
}

I'm currently running the same query but with another table and it's working normally. Does anyone know what it could be?

Expected behavior
The expected result would be to be able to fetch the information from the table.

Screenshots

I am using grafana cloud version 9.5.3. From the grafana website.

in my database i have a collection of users and then for each user a subcollection.
is there a documentation on how to access the subcollections and the data because everything i have tried it returns an error on the syntax.
I need to loop for each document id and get the data

Is your feature request related to a problem? Please describe.
I'm running multiple managed Firestore databases in GCP, so I can not use the default

Describe the solution you'd like
When creating the datasource, an optional input field for database id

Describe alternatives you've considered
Right now looking into writing a separate service to subscribe to a collection and write it to an InfluxDB instead

Additional context
The go firestore library has support for selecting database by using firestore.NewClientWithDatabase(ctx, project, db)

Hello 👋

Just letting you know that Grafana 10 is coming out soon and your grafanaDependency is currently set to not support it. This means customers that will get Grafana 10 will not be able to use your plugin.

You can test your plugin compatibility using the latest Grafana 10 grafana/grafana-dev docker images

Describe the bug
Grafana v9.3.2, running on an Ubuntu AWS instance

• Installed the plugin via Grafana CE UI.
• Successfully configured Firestore data source using GCP service account credentials
• Created new test Dashboard using the new Firestore data source
• Created new panel, selected new Firestore datasource
• Panel shows no data.
• Query inspector shows the following in the json response

Object
request:Object
url:"api/ds/query"
method:"POST"
data:Object
queries:Array[1]
range:Object
from:"1641024000000"
to:"1672559999999"
hideFromInspector:false
response:Object
message:"An error occurred within the plugin"
messageId:"plugin.downstreamError"
statusCode:500
traceID:""

OS log shows the following (Grafana log level = debug)

logger=secrets.kvstore t=2023-02-21T00:11:50.147991679Z level=debug msg="got secret value" orgId=1 type=datasource namespace=Firestore-backend
logger=plugin.pgollangi-firestore-datasource t=2023-02-21T00:11:50.150593661Z level=debug msg="QueryData called" numQueries=1
logger=plugin.pgollangi-firestore-datasource t=2023-02-21T00:11:50.150980051Z level=debug msg="FirestoreQuery: " EXTRA_VALUE_AT_END="map[CollectionPath:user_events IsCount:false Limit:0 OrderBy:<nil> Select:<nil> Where:<nil>]"
logger=plugin.pgollangi-firestore-datasource t=2023-02-21T00:11:50.151356351Z level=debug msg="Query ready!"
logger=plugin.pgollangi-firestore-datasource t=2023-02-21T00:11:50.402701399Z level=debug msg="panic: interface conversion: interface {} is []float64, not []string"
logger=plugin.pgollangi-firestore-datasource t=2023-02-21T00:11:50.403348915Z level=debug msg=
logger=plugin.pgollangi-firestore-datasource t=2023-02-21T00:11:50.403789611Z level=debug msg="goroutine 33 [running]:"
logger=plugin.pgollangi-firestore-datasource t=2023-02-21T00:11:50.404847291Z level=debug msg="github.com/pgollangi/firestore/pkg/plugin.(*Datasource).query(0xc000126c00?, {0xea3578, 0xc00045c270}, {0x1, {0xc00026e7a0, 0x1e}, 0xc000466200, 0x0, 0xc000126c00}, {{0x13f0448, ...}, ...})"
logger=plugin.pgollangi-firestore-datasource t=2023-02-21T00:11:50.40526078Z level=debug msg="\t/home/runner/work/firestore-grafana-datasource/firestore-grafana-datasource/pkg/plugin/datasource.go:189 +0x1525"
logger=plugin.pgollangi-firestore-datasource t=2023-02-21T00:11:50.40580811Z level=debug msg="github.com/pgollangi/firestore/pkg/plugin.(*Datasource).QueryData(0xc00027d580?, {0xea3578, 0xc00045c270}, 0xc000275cc0)"
logger=plugin.pgollangi-firestore-datasource t=2023-02-21T00:11:50.406305742Z level=debug msg="\t/home/runner/work/firestore-grafana-datasource/firestore-grafana-datasource/pkg/plugin/datasource.go:61 +0x276"