Hey guys, I would like to sync my data from diffe...
# ask-community-for-troubleshooting
a
Hey guys, I would like to sync my data from different data sources to PostgreSQL database: • How to do my data structure flattens? Now I got 3 columns (Airbyte AB ID, Airbyte Data, Airbyte Emitted At). I would like to have a columns from Airbyte Data as well • How to have a name for tables without "airbyte" prefix? Now I got: "airbyte tmp uru amplitude active users", "airbyte tmp rgr amplitude average session lengths", ... Looking forward
1
u
Hi Anton, did you use basic normalization feature for your sync to postgres? Tables can be renamed with namespace / prefix settings,
airbyte
prefixed table are used internally by airbyte.
a
Hey @[DEPRECATED] Augustin Lafanechere I use a basic normalization feature
I use a table prefix but I got "airbyte tmp uru amplitude active users"
u
Hi @Anton Svetlov tmp table are used and required by airbyte, but you should also have table prefixed by
amplitude_
in which you'll find your normalized output