# Creating a PDS from a source with a fraction of the columns

**URL:** <https://community.dremio.com/t/creating-a-pds-from-a-source-with-a-fraction-of-the-columns/10496>\
**Category:** Dremio Cloud\
**Created:** [April 7, 2023, 4:02pm UTC](https://community.dremio.com/t/creating-a-pds-from-a-source-with-a-fraction-of-the-columns/10496 "2023-04-07T16:02:58Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ismail](https://avatars.discourse-cdn.com/v4/letter/i/779978/32.png) [@Ismail](https://community.dremio.com/u/Ismail)\
**Post date:** [April 7, 2023, 4:02pm UTC](https://community.dremio.com/t/creating-a-pds-from-a-source-with-a-fraction-of-the-columns/10496/1 "2023-04-07T16:02:58Z")

</div>

I am trying to promote a source to a PDS, it brings in all of the available columns, I tried limiting it with features but it still brings in all the columns. The data is in parquet and I am using the REST API for promotion.  
Does anyone else have a similar use case and/or know how to do this?

---

<div class="post-metadata">

**Author:** ![cindy.la](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/cindy.la/32/6730_2.png) [@cindy.la](https://community.dremio.com/u/cindy.la)\
**Post date:** [April 7, 2023, 5:45pm UTC](https://community.dremio.com/t/creating-a-pds-from-a-source-with-a-fraction-of-the-columns/10496/2 "2023-04-07T17:45:11Z")

</div>

Hi @Ismail ,

Are you promoting a dataset for the very first time? It will promote the entire dataset if it’s the first time, and after the metadata retrieval has been done you can run other SQL commands to limit the return. We have more documentation on dataset promotion here:

[https://docs.dremio.com/cloud/sources/format/](https://docs.dremio.com/cloud/sources/format/)

---

<div class="post-metadata">

**Author:** ![Ismail](https://avatars.discourse-cdn.com/v4/letter/i/779978/32.png) [@Ismail](https://community.dremio.com/u/Ismail)\
**Post date:** [April 7, 2023, 6:13pm UTC](https://community.dremio.com/t/creating-a-pds-from-a-source-with-a-fraction-of-the-columns/10496/3 "2023-04-07T18:13:10Z")

</div>

So you’re saying, Promoting to a PDS would retrieve the entire metadata and we should and can only apply transformations in Tables and VDS?

---

<div class="post-metadata">

**Author:** ![cindy.la](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/cindy.la/32/6730_2.png) [@cindy.la](https://community.dremio.com/u/cindy.la)\
**Post date:** [April 7, 2023, 6:21pm UTC](https://community.dremio.com/t/creating-a-pds-from-a-source-with-a-fraction-of-the-columns/10496/4 "2023-04-07T18:21:27Z")

</div>

Hi Ismail,

That’s correct. You can then create VDS from the source PDS, by selecting the columns you’d like in the new VDS

Cindy

---

<div class="post-metadata">

**Author:** ![Ismail](https://avatars.discourse-cdn.com/v4/letter/i/779978/32.png) [@Ismail](https://community.dremio.com/u/Ismail)\
**Post date:** [April 7, 2023, 8:45pm UTC](https://community.dremio.com/t/creating-a-pds-from-a-source-with-a-fraction-of-the-columns/10496/5 "2023-04-07T20:45:43Z")

</div>

Sure, Thanks a lot!

Syed Ismail