# Multiple data source convert into single data source

**URL:** <https://community.dremio.com/t/multiple-data-source-convert-into-single-data-source/10669>\
**Category:** Dremio Cloud\
**Created:** [May 29, 2023, 10:37am UTC](https://community.dremio.com/t/multiple-data-source-convert-into-single-data-source/10669 "2023-05-29T10:37:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kom\_al](https://avatars.discourse-cdn.com/v4/letter/k/838e76/32.png) [@Kom\_al](https://community.dremio.com/u/Kom_al)\
**Post date:** [May 29, 2023, 10:37am UTC](https://community.dremio.com/t/multiple-data-source-convert-into-single-data-source/10669/1 "2023-05-29T10:37:55Z")

</div>

Hi,  
Is it possible in dremio that we take different data sets from different source and combine them and convert into single file format like JSON and store into a single data source like s3?

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [May 29, 2023, 12:43pm UTC](https://community.dremio.com/t/multiple-data-source-convert-into-single-data-source/10669/2 "2023-05-29T12:43:11Z")

</div>

@Kom_al You can union the difference queries (# and type of columns should be same) and then do a CTAS as PARQUET or ICEBERG

---

<div class="post-metadata">

**Author:** ![Kom\_al](https://avatars.discourse-cdn.com/v4/letter/k/838e76/32.png) [@Kom\_al](https://community.dremio.com/u/Kom_al)\
**Post date:** [May 30, 2023, 5:14am UTC](https://community.dremio.com/t/multiple-data-source-convert-into-single-data-source/10669/3 "2023-05-30T05:14:33Z")

</div>

Thanks @balaji.ramaswamy but my question is I want to try Dremio as a tool through which we can connect multiple data sources and convert them into a single data source and that single data source we can utilize in our integration. By that our integration model will be fairly easy. So is it possible through dremio that after querying the data , it stored into S3, so that we can use S3 in our model as a single source of data.

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [June 1, 2023, 5:26pm UTC](https://community.dremio.com/t/multiple-data-source-convert-into-single-data-source/10669/4 "2023-06-01T17:26:43Z")

</div>

@Kom_al You can write whatever query you want and CTAS into S3. Then query S3 as a single source

With V24 you can also use COPY INTO