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

Hawkar Mahmod

06/07/2021, 1:21 PM
Hey folks, Is it possible to stop the creation of multiple tables for streams created from API data sources that have nested data? Ideally I just have one table with the top level data and I can nest as I need to further down my pipeline. I’m not referring here to stopping normalization altogether.
1
c

Chris (deprecated profile)

06/07/2021, 1:29 PM
We are releasing soon a new feature to run your custom dbt transformation: (issue to track its progress is here: https://github.com/airbytehq/airbyte/issues/2959) Here is an updated tutorial linked to that new feature: https://github.com/airbytehq/airbyte/blob/97f8f3847af7c80df257c28b18af1ad433b8397f[…]ls/transformation-and-normalization/transformations-with-dbt.md This describes how to export the normalization project that is being generated, then from there you could edit it to remove the additional exploded tables for nested data and run your new “custom” normalized dbt project as part of airbyte: https://github.com/airbytehq/airbyte/blob/97f8f3847af7c80df257c28b18af1ad433b8397f[…]ransformation-and-normalization/transformations-with-airbyte.md
🔥 1
h

Hawkar Mahmod

06/07/2021, 1:34 PM
Got you! So the proposed way to do it going forward is to either allow the user to tinker with normalization or to do a thorough normalisation of all nested data structures encountered? There will never be a assumed level of normalisation?
c

Chris (deprecated profile)

06/07/2021, 1:35 PM
there will but it might come later for example this issue: https://github.com/airbytehq/airbyte/issues/3522 the issue is not specifically about turning off the nested tables in their separate table… But we do think about having that option (toggling nested) exposed as configuration too
“As proof”, In the code, we have a configuration object that is currently “empty” (with a enum of one value) 🙄 the option you are asking is written there in a comment: https://github.com/airbytehq/airbyte/blob/913c55df6b7933df77ec611d77db13104ec1722a[…]nfig/models/src/main/resources/types/OperatorNormalization.yaml
h

Hawkar Mahmod

06/07/2021, 2:30 PM
Ah got you
2 Views