Hi Guys,
Is there any way to add a prefix to table...
# plugins-generala
atif_imam
10/13/2021, 12:15 PMHi Guys,
Is there any way to add a prefix to table name when loading it to target database.
Lets say i have table in mysql named "table_1" and i want to load it as "final_table_1" in redshift. Is there any way to achieve that ?
t
taylor
10/13/2021, 5:15 PMThat’s usually a feature of specific targets. target-bigquery for example has that ability https://hub.meltano.com/targets/bigquery
a
atif_imam
10/13/2021, 6:02 PM@taylor , it means we dont have a prefix option for target-redshift ?
atif_imam
10/13/2021, 6:10 PMyes , its not there. But prefixing a table is much needed feature.
t
taylor
10/13/2021, 6:23 PMYou could maybe control it with this config option https://hub.meltano.com/loaders/redshift#schema-mapping
a
atif_imam
10/14/2021, 4:22 AM@taylor . Thank you so much for the above link. But i can't see any such option in redshift loader
t
taylor
10/14/2021, 1:55 PMWhich variant are you using @atif_imam?
a
atif_imam
10/15/2021, 10:21 AMI am using transferwise variant @taylor
t
taylor
10/15/2021, 2:34 PMUnderstood - I think this would be something useful to have in the SDK for targets https://gitlab.com/meltano/sdk/-/issues/74