Hi, I'm testing pipelinewise-tap-mssql to synch da...
# plugins-generale
ejaz_ul_karimi
06/27/2021, 1:10 PMHi, I'm testing pipelinewise-tap-mssql to synch data from MS SQL Server to Postgres. It is working but table in the destination is created with prefix of MS SQL Server schema name e.g. "dbo_inventory". In this example source table is "Inventory" in default schema "dbo". How can I manage to have destination table name in Postgres without the prefix of MS SQL Server schema name i.e. instead of "dbo_inventory" it need to be "Inventory" only. Many thanks for your support
t
taylor
06/28/2021, 3:16 PMhttps://hub.meltano.com/targets/postgres--transferwise#schema-mapping The transferwise variant has a schema mapping variable that you can use.
taylor
06/28/2021, 3:17 PMdepending on the use case I'd suggest this is a good use case for dbt. dbt can be the cleaning layer where you can create a downstream table/view in whatever schema you want.
e
ejaz_ul_karimi
06/30/2021, 8:16 AMThank you very much, yup transferwise variant of Postgres translated destination table name better i.e. without the prefix of MS SQL schema 👍