Is there any way to replicate a table to a defined schema? I have a table from mssql that is in dbo schema in mssql but when I replicate it to Snowflake I want to load it into a "raw" schema, but it seems to be using the dbo schema by default. Also is there a way to rename the table in my target database without breaking everything?

To rename the table you can use inline stream maps with an alias property, I believe this is what you want: https://sdk.meltano.com/en/stable/stream_maps.html#aliasing-a-stream-using-alias I don’t think I understood the other questions to be honest, can you give more context of what is happening vs what you want to achieve?

The other question is just the schema. My table in my source database is dbo.table and its landing in dbo.table in my warehouse but I want it to land in my warehouse in raw.table. For whatever reason the default target schema isn't applying to it