Hello Team, 👋 I have a simple use case of extracting data from

postgres

(pipelinewise-tap-postgres) and load it into

redshift

(pipelinewise-target-redshift) where we want to change the data type of a field from

decimal

to

bigint

. We tried making changes in our Meltano.yml file but it is not working. Certainly, we are doing something wrong. 😐

config:
      schema:
        public-amounts:
          amount:
            type: ["bigint"]

Any help would be appreciated 🙂

@ananya I think the

schema

item goes at the same level as the

config

item, not under it. Did you add that directly to meltano.yml or did you add it using the command line? If you added it directly i would try adding it via the command line to make sure the formatting is correct.

@thomas_briggs - Thank for responding. It was manual. Can you share a doc which I can refer to do the same using the CLI?

@thomas_briggs Thank you so much 🙏 😄

You're welcome 🙂

@thomas_briggs - I have one more question hope you can help me with this too. In this code:

schema:
    some_stream_id:
      created_at:
        type: ["string", "null"]
        format: date-time

what does

some_stream_id

should be?

For a stream coming from a database tap (i.e. tap-postres) that'll be the name of the table. So from your original question I think the answer is "`public-amounts"` .

ahh.. okay. let me try this. thanks again 😊