Hi, is it possible to rename the table with a pref...
# getting-startedb
binoy_shah
08/03/2023, 1:41 PMHi, is it possible to rename the table with a prefix/suffix or add prefix to table name in the destination ? We have data coming in from 2 distinct sources but they are of same business function so we want to store them in the same schema with different names.. Suffix/Prefix is okay
a
Andy Carter
08/03/2023, 2:02 PMSometimes your target plugin offers this. What are you using for your target? Snowflake? Postgres?
Andy Carter
08/03/2023, 2:04 PMOh, you want to alter the stream name right? So you can put tickets_a and tickets_b into the same schema?
b
binoy_shah
08/03/2023, 2:04 PMyes
binoy_shah
08/03/2023, 2:04 PMSource database is MySQL
binoy_shah
08/03/2023, 2:04 PMso its
tap-mysqlb
binoy_shah
08/03/2023, 2:06 PMThanks @Andy Carter it was exactly what I was looking at
a
Andy Carter
08/03/2023, 2:06 PMYou will need to install separate mapper for that and put it between tap and target.
Andy Carter
08/03/2023, 2:07 PMIf your tap supports stream maps already with the meltano sdk then: https://sdk.meltano.com/en/latest/stream_maps.html#aliasing-a-stream-using-alias
Andy Carter
08/03/2023, 2:08 PMBut I think you will need to spell out all of your streams to do this, you can't say 'I need this prefix' to all
b
binoy_shah
08/03/2023, 2:08 PMno, I dont think tap-mysql supports it.. its a legacy tap
a
Andy Carter
08/03/2023, 2:10 PMb
binoy_shah
08/03/2023, 2:10 PMawesome, thanks
u
user
08/03/2023, 3:04 PMno, I dont think tap-mysql supports it.. its a legacy tapIf your target is SDK based then you could configure it on the target side also.
But I think you will need to spell out all of your streams to do this, you can't say 'I need this prefix' to allTheres this PR draft that was recently created to address https://github.com/meltano/sdk/issues/699
3 Views