The CLI has a way to add select patterns to an extractor, but is there a CLI command for removing a select pattern from an extractor? Doesn’t seem like it in the docs.

That’s a good question. And you don’t mean establishing an exclusion, right? You mean removing a selection? The way I would do it is just delete the line from

meltano.yml

.

That’s correct I do NOT mean establishing an exclusion. For now I did exactly that. I deleted the entire

select

portion of

meltano.yml

. This is just fine for a one off edit, but I’m trying to loop through a series of databases where the schema names will change from database to database but the table names will not requiring a complete refresh of select patterns. I’m removing the

select

configuration section through reading and rewriting the file currently but it would be handy to have a

meltano select --remove <tap_name>  [ENTITIES_PATTERN] [ATTRIBUTE_PATTERN]

. Just a thought 🙂

Yeah, that sounds like it would be handy. Do you want to log that in our issue tracker? And if I understand your use case, you might be interested to try ‘inherit_from’ syntax to establish a set of named table groups each with their own selection pattern, then parameterize the connection info as you are doing already.