Is something like this possible? Select * except...

- name: tap-salesforce
  variant: meltano
  select:
    - Lead.*
  exclude:
    - Lead.Name

Not really following https://meltano.com/docs/plugins.html#select-filter-extra

https://meltano.com/docs/plugins.html#select-extra supports exclusion rules prefixed with

!

That helps, after running

meltano select --exclude tap-salesforce '*' 'Name'

I get:

- name: tap-salesforce
    variant: meltano
    select:
      - Lead.*
      - '!*.Name'

However, Name seems to still be included in Lead

What does

meltano select --list tap-salesforce

say?

hmm interesting, it doesnt have Lead.Name listed there. Let me try and dig more

@dan_ladd OK, that means that the catalog tap-salesforce is receiving has it as

selected: false

as well. There is a chance that the tap isn't respecting that, but I think it supports property selection correctly

Ok maybe I missed something. While the name property is still included in the schema message, it is not included in the salesforce query and therefore just null now. Thanks for your help Douwe!

You always already have an issue for everything! I'll search there next time too!

😄