Joining data from two data source in to build a dashboard panel

Hi, i have an csv file in google sheet. There are two column pid, scaling_factor and the csv has 182 rows.

on the other hand i have timeseries data(pid, pval) saved in aws timestream database. Now i want to have a dashboard panel where i want to join both data on pid and want to calculate a value using pval/scaling_factor. Is it possible to do this kind of operation? I heard about Transformation but not been able to find any direction.