Meltano

Could anyone point me to a working example of `tap-mssql` ? Where I'm struggling is how do I define my pipelines and what tables/columns to pull

<https://github.com/BuzzCutNorman/tap-mssql>

THe catalog will be of all available tables and columns to the login user

You can define your selection in the normal way, each table becomes a separate stream name

<https://docs.meltano.com/concepts/plugins#select-extra>

so the "select" extra is where you dictate the streams? And these streams can be discovered in the catalog once I run`--discover` ?

I've only ever created a custom tap hahaha sorry new to this

You can specify your streams and fields in `select` in your <http://meltano.at|meltano.yml >at any time. But running discover first is a good idea to see what is available from your tap.

Depending on the number of schemas/tables available to your user this can take more or less time.

I would just try with a simple `meltano invoke tap-mssql` as this will run discovery if required and save a local version of your catalog. But you won't get much feedback from meltano during this time

Okay cool, I'll get back to you in a few weeks when I actually get all the config and database access done right first lmao