If I just want to pull one table from one database through tap-mssql, will specifying that table in the select config be all I need? Or do I also need to explicitly exclude all the other objects?

yes, and if you just try it you'd see it'd be faster than asking here 😄

Well yes but it's a production server so I'm not trying to completely replicate the whole thing over lol just want to be safe

Local environment is really worth it for stuff like this is my point! Not expensive or that time consuming either https://hub.docker.com/ for postgres I do this

docker run -e POSTGRES_PASSWORD=postgres -p 5432:5432 -h postgres -d postgres

Then I go make a db / table and we're in business!

➕ to local environment like derek says, though I tend to specify things in a docker-compose file because I have trouble remembering all the docker run parameters. also useful to leverage meltano environments in the meltano.yml file.

@haleemur_ali I don't remember it either I make a

.sh

script and put it in my meltano directory. On second thought I could probably do that as a utility in meltano 😄

Now i'm intrigued. I'm curious how you use your

.sh

script or how one would go about creating a utility.

I use a .sh as well to parse my dbt manifest and start dagster