Hello, i need help with normalization.. i dont get...
# connector-development
f
Hello, i need help with normalization.. i dont get how this can be okey... is there a setting or why the normalization will not link referenced objects together?? For example: In the invoice api: i have the parent object "`invoice`" with ID which has an object named "`contact`" with an ID In the contact api: i have the object "`contact`" with an ID. as result i get... a table "`invoice`" with all invoice informations a table "`invoice_contact`" with just the object ID and some Airbyte fields a table "`contact`" with all contact informations but only the
invoice
and
invoice_contacts
are linked together with
airbyte_hashid
.... that makes no sense for me.. if the main "`contact`" table witrh all its informations about contacts isn't linked together with
invoice
the whole normalization is useless ... i mean i have everywhere the IDs in the api collected objects.. this should be easy to link together for normalization... whats wrong here? isnt this feature build in? i use BigQuery normalization! Thanks alot!
Feedback has been sent to Harvestr
@flow thanks for feedback and suggestion; today normalization only create tables based on the stream schema. Maybe is something that can be reached adding more info in the schema to create this relationships. Do you mind creating a Github issue for this?