Hi, Is there a way to change target table names? (...
# troubleshooting
m
Hi, Is there a way to change target table names? (E.g: remove
public-
prefix)
a
Often there is, but the method is often specific to the given singer target. Do you mind sharing the target name and specific variant you are using? If you haven't already checked, you might look at their docs for something like "schema mapping" or "target schema" or "table prefix".
m
I'm using target-bigquery (Adswerve). I think "table prefix" adds a prefix, but I need to remove it from all table names.
a
Sorry - I don't know off the top of my head... @ruslan_bergenov - do you know if it's possible to remove the
public-
schema prefix when landing data in target-bigquery?
r
The short answer to your question is no. We only have the possibility to add table prefix. It gives you control over table names, which is convenient if your tables are in one dataset. We can change table names by adding a table prefix (default is empty), but we can't change table names by removing a table prefix which came from JSON schema from the tap.