https://linen.dev logo
b

Bala

12/06/2020, 7:03 PM
Question : Why Airbyte choose the approach to do the sync as json structure instead of full schema as it is sync to target DB similar to fivetran , stitch?
u

user

12/06/2020, 7:05 PM
like Similar to Source Table Structure on Target DB . I am primarly talking about Postgres to Postgres connection
u

user

12/06/2020, 7:05 PM
instead of custom JSON format.
u

user

12/06/2020, 7:06 PM
My usecase : I want to use grafana or superset on the destination directly. With custom json i need to post process for visualization client
u

user

12/06/2020, 7:18 PM
Hey Bala, Airbyte can write a normalized table (with a schema, not just JSON) for most destinations if the normalize option is set to true
u

user

12/06/2020, 7:19 PM
You can change this by going to the destination settings and setting basic_normalization to true
u

user

12/06/2020, 7:26 PM
got it . let me try the same.
u

user

12/06/2020, 8:37 PM
@Bala did that fix it?
u

user

12/06/2020, 8:38 PM
didnt tried still , give me 30
u

user

12/06/2020, 8:49 PM
@s yes its works as expected. Tried one connector.
u

user

12/06/2020, 8:49 PM
will try more