Hi All, I want to extract and load from gsheets to bigquery. I want to transform the data as well. Just small confusion, Is meltano is ELT or ETL tool? How to transform my data using meltano?

I use

dbt

to transform any data, so I use meltano for EL in my DWH, and then dbt for the T stage to prepare for BI layers. Meltano can do some light transformation if you need it to (https://docs.meltano.com/guide/mappers) but not really aggregation if that is what is needed (see https://docs.meltano.com/guide/mappers#out-of-scope-features)

Thanks @Andy Slater I will check