Meltano

Hey guys, unfortunately I can't find anything about this in the documentation: I want a job to do a full load every time and ignore the state. Whats the best way to do this?

Metadata:
 '*'
    replication-method: FULL_TABLE

<https://gitlab.com/vischous/oracle2mssql/-/blob/master/oracle2mssql/meltano.yml#L48>

<https://meltano.com/docs/plugins.html#metadata-extra>

I agree it's hard to grok what's going on.

The best way to think about I"ve found is this.

Meltano manages the catalog file for you. Part of that is metadata inside of the catalog metadata for each stream. Metadata-extra in meltano gives you the ability to change the catalog file on the fly (The manual option is to manually update the flag in the catalog file)

did not know you could override all streams like that :rocket: