https://linen.dev logo
#ask-community-for-troubleshooting
Title
# ask-community-for-troubleshooting
a

Anton Svetlov

11/24/2021, 2:08 PM
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

[DEPRECATED] Augustin Lafanechere

11/25/2021, 5:58 PM
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

Anton Svetlov

11/25/2021, 9:03 PM
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

[DEPRECATED] Augustin Lafanechere

12/07/2021, 3:19 PM
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
3 Views