Hello all, I was trying to test meltano by creating a simple flow to extract a csv file from a local folder (or github) and load it into another folder. However seems like I haven’t done something right. I have attached my yaml file. And the output I get for it is:

(.venv) (base) Farids-MacBook-Pro:gith farid$ meltano elt tap-spreadsheets-anywhere target-csv --job_id=zadd
meltano                   | Running extract & load...
meltano                   | No state was found, complete import.
target-csv                | INFO Sending version information to <http://singer.io|singer.io>. To disable sending anonymous usage data, set the config parameter "disable_collection" to true
tap-spreadsheets-anywhere | INFO Using supplied catalog /Users/farid/WorkSpace/meltano-projects/meltano-projects/gith/.meltano/run/elt/zadd/24df7e7e-1bf4-4a16-a544-bd038b2380c0/tap.properties.json.
meltano                   | Extract & load complete!
meltano                   | Transformation skipped.

Also when I run the discover command:

(.venv) (base) Farids-MacBook-Pro:gith farid$ meltano invoke tap-spreadsheets-anywhere --discover
INFO Walking /Users/farid/WorkSpace/meltano-projects/meltano-projects/csvs.
INFO Found 1 files.
ERROR Unable to write Catalog entry for 'target_table_name' - it will be skipped due to error nothing to repeat at position 0
{
  "streams": []
}

Any ideas? Thanks

@farid_akhavan

nothing to repeat at position 0

is a regex error: https://stackoverflow.com/questions/46103756/python-regex-error-nothing-to-repeat-at-position-0/46103801 The

pattern

you're using (

*.csv

) is not a valid regex, since

*

is not a wildcard but means "zero or more of the preceding character", while in your case there's no preceding character. If you want every CSV file, try

.*\.csv

, where

.

stands for "any character", and the

*

is used to say "zero or more of those"

Oh right, I didn’t know it’s a regex pattern, I thought it’s a bash like pattern but that makes sense. Seems to be working now, thanks!