In metabase v44.7, report timezone was not affecting the output of timestamp fields from bigquery results as bigquery uses UTC as default timezone and in metabase i was using IST as report timezone.
After upgrading to v46.6 i am getting output of timestamp fields with +05:30 as per the report timezone.
Please suggest any configuration change to keep the output of the query in UTC as bigquery and get reports in IST.