I am trying to replicate an existing dashboard panel using the grafanalib api in python.
I am stumbled at the doc as it doesnt seem to explain how i can input my query
This is the code i have that generates the panel json which then i upload
dashboard = Dashboard( title="Test Dashboard", description="Python code generated Dashboard", tags=[ 'test' ], timezone="browser", panels=[ Stat( title='Resolved alerts', dataSource='Amazon Athena', description='Number alerts that has been resolved', format='table', transparent=True, targets=[ Target( datasource='AwsDataCatalog', format=1, expr="SELECT count(*) FROM pd_alert WHERE status='resolved'", refId="A", ), ], gridPos=GridPos(h=8, w=16, x=0, y=0), ), ], ).auto_panel_ids()
Can someone point out how i can include the athena query expression for a panel of Stat type?
I also tried backtracking from the json model of the existing panel but the fields are not consistent