Meltano

Hi I'm working on a postrges -&gt; 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.

<https://hub.meltano.com/loaders/target-snowflake--transferwise/#stage-setting|This is the target I'm using> . None of the config options seemed to be applicable either

I am currently using <https://hub.meltano.com/mappers/meltano-map-transformer|meltano map transformer> to do that using  `__alias__`  here is an <https://github.com/MeltanoLabs/meltano-map-transform/tree/main/examples#example-2-dropping-columns-aliasing-streams|example>

So that example should rename `customers` to `customers_v2` right? I tried something similar but it didn't work. I'll try again

This is the yml I used:
```    stream_maps:
      sites:
        __alias__: partners__sites ```
I want to rename the table `sites` to `partners__sites`

if sites is the stream-id for the table `sites` then yes.

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?

image.png

<@U06EMSP6J20> 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.&lt;tap-name&gt;` . In short the stream id is based on the TAP and what is selected.  Ref <https://docs.meltano.com/guide/integration#selecting-entities-and-attributes-for-extraction|docs  >and image the select has commits and tags, so there is a stream-id `commits` and `tags`

for sql it is usually a combo of `schema.table` or `schema-table`

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

if you follow the docs for the `select` command it will also show you the pattern