wyatt
06/10/2021, 7:24 PMmeltano elt
? Then, I could avoid re-writing a catalog json file every hour and instead pass in the relevant execution time as a variable!douwe_maan
06/10/2021, 7:36 PMsearch_path: $SEARCH_PATH
in your meltano.yml
config
for tap-spreadsheets-anywhere
, and then set SEARCH_PATH
when calling meltano elt
as in SEARCH_PATH=foo meltano elt ...
, but env var substitution doesn't currently work in arrays, and I think tap-spreadsheets-anywhere
uses an array to define the tables: https://gitlab.com/meltano/meltano/-/issues/2481douwe_maan
06/10/2021, 7:36 PMdouwe_maan
06/10/2021, 7:38 PMwyatt
06/10/2021, 10:26 PMdouwe_maan
06/10/2021, 10:27 PMwyatt
06/10/2021, 10:27 PMmeltano config tap-spreadsheets-anywhere list
to check if env vars can be set. It looks like this particular tap does not have any possible configs?douwe_maan
06/10/2021, 10:28 PMtables
, does it not list anything?wyatt
06/10/2021, 10:28 PMwyatt
06/10/2021, 10:28 PMmeltano select --list --all tap-spreadsheets-anywhere
returns Exception: Config is missing required keys: ['tables']
douwe_maan
06/10/2021, 10:29 PMmeltano config tap-spreadsheets-anywhere
say?wyatt
06/10/2021, 10:29 PM{}
douwe_maan
06/10/2021, 10:29 PMmeltano.yml
definition for the tap?wyatt
06/10/2021, 10:30 PM- name: tap-spreadsheets-anywhere
namespace: tap_spreadsheets_anywhere
pip_url: git+<https://github.com/ets/tap-spreadsheets-anywhere.git>
executable: tap-spreadsheets-anywhere
capabilities:
- catalog
- discover
- state
wyatt
06/10/2021, 10:31 PMdouwe_maan
06/10/2021, 10:32 PMtables
. I notice now that https://hub.meltano.com/taps/spreadsheets-anywhere doesn't refer to https://hub.meltano.com/extractors/spreadsheets-anywhere as it shoulddouwe_maan
06/10/2021, 10:32 PMnamespace
, executable
, and capabilities
keys?douwe_maan
06/10/2021, 10:32 PMmeltano config tap-spreadsheets-anywhere list
should at least show the `tables`` settingwyatt
06/10/2021, 10:35 PMwyatt
06/10/2021, 10:36 PMdouwe_maan
06/10/2021, 10:36 PMdouwe_maan
06/10/2021, 10:36 PMtables
using the env var you should see listedwyatt
06/10/2021, 10:36 PMdouwe_maan
06/10/2021, 10:36 PMsearch_path
is not possible yet because of https://gitlab.com/meltano/meltano/-/issues/2481wyatt
06/10/2021, 10:36 PMwyatt
06/10/2021, 10:41 PMdouwe_maan
06/10/2021, 10:41 PMwyatt
06/10/2021, 10:46 PMwyatt
06/10/2021, 10:46 PMProcessing 0 selected streams from Catalog
douwe_maan
06/10/2021, 10:48 PMdouwe_maan
06/10/2021, 10:48 PMmeltano select --list --all tap-spreadsheets-anywhere
show anything?wyatt
06/10/2021, 10:55 PMLegend:
selected
excluded
automatic
Enabled patterns:
*.*
Selected attributes:
douwe_maan
06/10/2021, 10:56 PMtables
config is likely incorrect and it's not able to find any files/streamsdouwe_maan
06/10/2021, 10:56 PMmeltano invoke tap-spreadsheets-anywhere --discover
and see if you see any relevant logs?wyatt
06/10/2021, 11:02 PM...
ERROR Unable to write Catalog entry for {tablename} - it will be skipped due to error {file} could not be parsed: Extra data: line 1 column 1716 (char 1715)
wyatt
06/10/2021, 11:03 PMwyatt
06/10/2021, 11:03 PMwyatt
06/10/2021, 11:04 PMwyatt
06/10/2021, 11:07 PMdouwe_maan
06/10/2021, 11:07 PMExtra data: line 1 column 1716 (char 1715)
looks like a JSON parsing errordouwe_maan
06/10/2021, 11:07 PMwyatt
06/10/2021, 11:08 PMwyatt
06/10/2021, 11:09 PMwyatt
06/10/2021, 11:13 PM{
is the char and it looks like the files are non-valid jsondouwe_maan
06/10/2021, 11:13 PMwyatt
06/10/2021, 11:16 PMwyatt
06/10/2021, 11:20 PMwyatt
06/10/2021, 11:20 PMwyatt
06/10/2021, 11:26 PM.replace('}{"', '}\n{"')
wyatt
06/10/2021, 11:27 PMdouwe_maan
06/10/2021, 11:27 PMwyatt
06/10/2021, 11:27 PMwyatt
06/10/2021, 11:27 PMdouwe_maan
06/10/2021, 11:29 PMwyatt
06/11/2021, 3:45 PM