And another one, how can I cast a string value .env into an integer in a config? meltano.yaml

- name: tap-instagram
    variant: voxmedia
    pip_url: tap-instagram
    config:
      ig_user_ids:
      - ${TAP_INSTAGRAM_USER_ID}

.env

TAP_INSTAGRAM_USER_ID=12345

results in

singer_sdk.exceptions.ConfigValidationError: Config validation failed: '${TAP_INSTAGRAM_USER_ID}' is not of type 'integer'

@Andy Carter the answer is usually to update the

kind

setting value which defines the type, for this tap the type is array. It looks like the problem youre running into this issue https://github.com/meltano/meltano/issues/3171. Its literally receiving

${TAP_INSTAGRAM_USER_ID}

as the value vs

12345

as you expect

That last one did the trick, thanks 🙂 The config command is super-useful to see what's happening for each tap