# Ingest SQL relationships as nested documents
**URL:** https://discuss.elastic.co/t/ingest-sql-relationships-as-nested-documents/131645
**Category:** Logstash
**Created:** [May 14, 2018, 12:28am UTC](https://discuss.elastic.co/t/ingest-sql-relationships-as-nested-documents/131645 "2018-05-14T00:28:32Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@mwmouawad](https://discuss.elastic.co/u/mwmouawad)
#### Post date: [May 14, 2018, 12:28am UTC](https://discuss.elastic.co/t/ingest-sql-relationships-as-nested-documents/131645/1 "2018-05-14T00:28:32Z")
Hi everyone, I’m trying to figure out a way to index my Postgres data into elasticsearch. I have a user table, and a purchase table with a user\_id column linking to a user. I want to have a elasticsearch document for each user and within a nested document with each purchase that this user has made.
I’m planning to use the user\_id as the elasticsearch document id reference, however:
1- I can’t figure a way to create nested objects with logstash input.
2- Can’t find a way to add multiple purchases fields to a same document. (It’s being overwritten)
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [May 14, 2018, 4:55am UTC](https://discuss.elastic.co/t/ingest-sql-relationships-as-nested-documents/131645/2 "2018-05-14T04:55:23Z")
Have you considered denormalising your model and store each order as a separate document with the relevant customer information added to each document?
---
### Author:  [@mwmouawad](https://discuss.elastic.co/u/mwmouawad)
#### Post date: [May 17, 2018, 2:37pm UTC](https://discuss.elastic.co/t/ingest-sql-relationships-as-nested-documents/131645/3 "2018-05-17T14:37:48Z")
Hi i will probably try that. Still I wonder if there isn't another way of doing this.
Thank you very much
---
### Author:  [@Johnnycc1](https://discuss.elastic.co/u/Johnnycc1)
#### Post date: [May 18, 2018, 11:26pm UTC](https://discuss.elastic.co/t/ingest-sql-relationships-as-nested-documents/131645/4 "2018-05-18T23:26:38Z")
Hey mwmouawad,
I have not done it myself however I think you can get postgres to create the nested json for you, using row\_to\_json, you might want to hide your query behind a view so logstash just queries one view and gets the nested json back. If this does work please let me know.
Alternatively you can use the jdbc streaming filter. Your logstash input query gets all the users, then using the jdbc filter it queries postgres for all transactions for that user and adds it to the event.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 15, 2018, 11:26pm UTC](https://discuss.elastic.co/t/ingest-sql-relationships-as-nested-documents/131645/5 "2018-06-15T23:26:44Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.