Kapacitor with influxdb2.7.10

InfluxDB 2
1

HI, I am upgrading my influx1.8 to influx2.7.10. I have a tick template which includes: batch
|query(‘SELECT last(’+column+‘), mean(’+column+‘), stddev(’+column+‘) FROM mydb.’+retentionPolicy+‘.’+measurement). Influx2 contains buckets now instead of db and rp. how can I update the query string to access bucket ‘one_hour’ with specific measurement? I have tried to specify one_hour.measurement or one_hour/autogen.measurement and it did not work. Help is much appreciated. P.S - I have configured kapacitor to work with influx2: disable-subscriptions = true and added user and oken