Does

--full-refresh

truncate the table before loading the data?

Not really. It only ignores any state from previous elt runs. What target are you using?

I'm using bigquery target. I see that I can set

replication_method

as append or truncate for big query. If I want my rows to append but want to truncate only on full refresh, how can I achieve it?

I see. You could set the value at runtime:

TARGET_BIGQUERY_REPLICATION_METHOD=truncate meltano elt your-tap target-bigquery --full-refresh

See https://hub.meltano.com/loaders/bigquery#replication-method

Thank you very much

Glad to help! So did it work?

No. It didn't work.