Hi I'm working on a postrges -> snowflake load right now. Is there a way I can rename the tables as they arrive in snowflake? The documentation seems to provide ways to do this with stream maps but only for renaming columns and not tables.

I am currently using meltano map transformer to do that using

__alias__

here is an example

So that example should rename

customers

to

customers_v2

right? I tried something similar but it didn't work. I'll try again

if sites is the stream-id for the table

sites

then yes.

Ahhh that might be my mistake

Stream-id's are crucial it is how everything communicates

Is there a place I can verify what the stream ID is? any logs or anything like that?

@Andrew Hintermeier what tap are you using? If you can share your tap, I can point out the stream-id or at least how it is generated outside of that you could use

discover

if your tap has it or look at the

tap.properties.json

file in

.meltano.run.<tap-name>

. In short the stream id is based on the TAP and what is selected. Ref docs and image the select has commits and tags, so there is a stream-id

commits

and

tags

We're using this one: https://github.com/transferwise/pipelinewise-tap-postgres I'm like 70% sure it's

schema-table

like you mentioned but that was not working for me

there should be a folder for the tap in

.meltano

ref image that file has all of the stream id's