https://linen.dev logo
#contributing-to-airbyte
Title
# contributing-to-airbyte
p

Ping

05/28/2021, 10:25 PM
Regarding normalization and https://github.com/airbytehq/airbyte/issues/1927, I know that a general solution might be far away, but I'm wondering if we could get to structured rows by hand-editing a DBT model to do the appropriate transformation for our specific tables. Is that something you think would be worth trying?
u

user

05/31/2021, 7:46 AM
Yes, you can try editing and running your own queries to build the struct types with dbt!
u

user

06/01/2021, 2:42 AM
If there exist any tips on how to get started with that, that would be awesome! Thanks 🙂
u

user

06/01/2021, 7:53 AM
You can go over the serie of tutorials on transformations in airbyte: https://docs.airbyte.io/tutorials/transformation-and-normalization/transformations-with-dbt Here’s an example blog post on how to flatten struct/array (the contrary of what you actually want), but you’d have examples of how to build some too: https://shotlefttodatascience.com/2019/12/27/tutorial-bigquery-arrays-and-structs/
u

user

06/01/2021, 5:16 PM
Wonderful! Thank you 🙂
u

user

06/07/2021, 5:00 AM
@Ping did you get time to look into it. We have an immediate requirement here will be happy to know any details regarding this. If you have not started I can pick this.