I know that I can use `'*'` in schema overrides to...
# troubleshooting
m
I know that I can use
'*'
in schema overrides to match all streams or all columns:
Copy code
plugins:
  extractors:
    - name: tap-spreadsheets-anywhere
      variant: ets
      schema:
        '*':
          '*':
            type:
              - 'null'
              - string
is there a way to do “all columns except one”? Like, if I want one column to be an integer, and all the rest to be strings, could I do this? Are they evaluated in order?
Copy code
plugins:
  extractors:
    - name: tap-spreadsheets-anywhere
      variant: ets
      schema:
        '*':
          '*':
            type:
              - 'null'
              - string
          my_int_column:
            type:
              - 'null'
              - integer
it looks like the library used for the shell style wildcard behavior is https://docs.python.org/3/library/fnmatch.html
I think in my case, the column I want to keep as an int has a name beginning with
_
so I think maybe I can change
'*'
to
'[!_]*'
in my first example above. Going to try that.
change
'*'
to
'[!_]*'
this change worked great
e
This is probably worth documenting 🙂