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'
- integer
Matt 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