Matt Menzenski
07/11/2023, 9:01 PM'*' in schema overrides to match all streams or all columns:
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?
plugins:
extractors:
- name: tap-spreadsheets-anywhere
variant: ets
schema:
'*':
'*':
type:
- 'null'
- string
my_int_column:
type:
- 'null'
- integerMatt Menzenski
07/11/2023, 9:07 PMMatt Menzenski
07/11/2023, 9:16 PM_ so I think maybe I can change '*' to '[!_]*' in my first example above. Going to try that.Matt Menzenski
07/13/2023, 1:11 PMchangethis change worked greatto'*''[!_]*'
edgar_ramirez_mondragon
07/13/2023, 3:53 PM