# Creathe PDS with sql

**URL:** <https://community.dremio.com/t/creathe-pds-with-sql/9991>\
**Category:** Dremio University\
**Created:** [December 2, 2022, 4:45pm UTC](https://community.dremio.com/t/creathe-pds-with-sql/9991 "2022-12-02T16:45:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vitoravancini](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/vitoravancini/32/4566_2.png) [@vitoravancini](https://community.dremio.com/u/vitoravancini)\
**Post date:** [December 2, 2022, 4:45pm UTC](https://community.dremio.com/t/creathe-pds-with-sql/9991/1 "2022-12-02T16:45:28Z")

</div>

Is it possible tu use sql queries to create Physical Datasets?

I’m aware of this option [Dremio](https://docs.dremio.com/software/acceleration/offloading-operational-databases/)  
but its not enough, I do need to copy the sources table from other sql sources. The source database have updates on its lines and I would lose history if I just cache views on top of it

---

<div class="post-metadata">

**Author:** ![Benny\_Chow](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/benny_chow/32/5527_2.png) [@Benny\_Chow](https://community.dremio.com/u/Benny_Chow)\
**Post date:** [December 6, 2022, 4:30pm UTC](https://community.dremio.com/t/creathe-pds-with-sql/9991/2 "2022-12-06T16:30:44Z")

</div>

If you are trying to make an existing dataset queryable in Dremio, then you need to promote it using: [Dremio](https://docs.dremio.com/software/sql-reference/sql-commands/datasets/#managing-physical-datasets)

Otherwise, if you are trying to create tables and load data, then you can use this: [Dremio](https://docs.dremio.com/software/sql-reference/sql-commands/apache-iceberg-tables/apache-iceberg-create/)