If I want to run

transformation

on tap-csv to tap-iceberg (custom plugin), which dbt adapter can I use? Should I use something like

dbt-postgres

or

dbt-mysql

? Will that transform my csv data and put it into my iceberg data lake in S3? I'd also like to mention that I'm using Trino as a query engine. In that case, can I use

dbt-trino

?

Hi @taeef_najib! Where are you storing your Iceberg-formatted data?

Hey @Edgar Ramírez (Arch.dev) I'm storing it in S3. As a side note, I'm using Hive metastore as the catalog. In the bucket that I specify in

meltano.yml

, I can normally see a folder where there are all the metadata and data.

I'm rather unfamiliar with the iceberg ecosystem, but I suppose dbt-trino should work.

I'll try it and will let you know if it works. Thanks, Edgar