Hi all, I am new to Meltano and exploring the tool. While running "meltano run" getting below error as showing in snip. How to resolve this? Thanks in advance.

The

meltano run

command expects at least one argument. https://docs.meltano.com/reference/command-line-interface#run

Thanks @Edgar Ramírez (Arch.dev)

You need entity, path and keys specificed under the

files:

{	"entity" : "leads",
						"path" : "/path/to/leads.csv",
						"keys" : ["Id"],
						"delimiter": ";"
					},

Thanks @Andy Carter Will check by adding this

Sorry this is a better link if you want to define files in

meltano.yml

https://hub.meltano.com/extractors/tap-csv#files-setting

Thanks. but still facing issue

What's the absolute path of the file on your machine?

this is the path(/home/rsiva_sai/meltano-project/poc/)

Ok. What's the output of

head -n1 /home/rsiva_sai/meltano-project/poc/testing.csv

?

name,legacy_id,location

Ok. What does

meltano.yml

look like after the changes? I think something's still misconfigured.

Ok. Try instead

config:
  files:
  - entity: testing
    path: /home/rsiva_sai/meltano-project/poc/testing.csv
    keys: [name]

Thanks @Edgar Ramírez (Arch.dev) The data is able to load. But, why the schema is changed?

changed from what?

you might wanna give https://github.com/z3z1ma/target-bigquery/?tab=readme-ov-file#usage-notes a read

Thanks let me check that link

only table is creating and data is not loading

I haven't used z3z1ma/target-bigquery beyond simple testing, but it seems to be doing some work. You could also try setting the

LOGLEVEL=debug

environment variable and rerunning in case the target is logging things at the debug level.

also, if you dontmind can you please share some documents regarding how to start and end learning Meltano completely.

https://docs.meltano.com/getting-started/ is probably the best resource

Thanks @Edgar Ramírez (Arch.dev)

Does

meltano config tap-google-sheets test

work for you?

Hi

Can you confirm your credentials have access to that instance of gsheet?

ya its working now

@amor apprendido they are the record metadata columns added by targets (not taps): https://sdk.meltano.com/en/latest/implementation/record_metadata.html#record-metadata Under your

target-bigquery

config in yaml, try adding

add_record_metadata: false

and then see if that removes the columns. You might need to delete your target tables and run a full refresh.

Hi @Andy Carter I tried the same but still metadata creating