# how to create a transformed table for existing ones

**URL:** <https://discourse.getdbt.com/t/how-to-create-a-transformed-table-for-existing-ones/7847>\
**Category:** Help\
**Tags:** jinja, bigquery\
**Created:** [April 14, 2023, 4:15pm UTC](https://discourse.getdbt.com/t/how-to-create-a-transformed-table-for-existing-ones/7847 "2023-04-14T16:15:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rezee](https://avatars.discourse-cdn.com/v4/letter/r/eb9ed0/32.png) [@rezee](https://discourse.getdbt.com/u/rezee)\
**Post date:** [April 14, 2023, 4:15pm UTC](https://discourse.getdbt.com/t/how-to-create-a-transformed-table-for-existing-ones/7847/1 "2023-04-14T16:15:41Z")

</div>

I am a total newbie, one week reading about dbt.

The problem I’m having is learning my way around the different models.

The context of why I’m trying to do this is I have connected to BigQuery and have read all of my needed data. Just for a proof of concept, I want to create a new table that is a result of a query from the data I have read.

I understand the concept of the schema.yml files.

Is there a good reference for this level of training need?

---

<div class="post-metadata">

**Author:** ![alexnataf](https://avatars.discourse-cdn.com/v4/letter/a/e56c9b/32.png) [@alexnataf](https://discourse.getdbt.com/u/alexnataf)\
**Post date:** [April 14, 2023, 4:26pm UTC](https://discourse.getdbt.com/t/how-to-create-a-transformed-table-for-existing-ones/7847/2 "2023-04-14T16:26:01Z")

</div>

Hey ! Just read this : [Getting Started with dbt (data building tool), demystifying terminology - Datacoves](https://datacoves.com/post/getting-started-with-dbt-data-building-tool-demystifying-terminology)

---

<div class="post-metadata">

**Author:** ![rezee](https://avatars.discourse-cdn.com/v4/letter/r/eb9ed0/32.png) [@rezee](https://discourse.getdbt.com/u/rezee)\
**Post date:** [April 14, 2023, 4:50pm UTC](https://discourse.getdbt.com/t/how-to-create-a-transformed-table-for-existing-ones/7847/3 "2023-04-14T16:50:11Z")

</div>

I will take a look, thank you

---

<div class="post-metadata">

**Author:** ![brunoszdl](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/brunoszdl/32/4113_2.png) [@brunoszdl](https://discourse.getdbt.com/u/brunoszdl)\
**Post date:** [April 14, 2023, 5:55pm UTC](https://discourse.getdbt.com/t/how-to-create-a-transformed-table-for-existing-ones/7847/4 "2023-04-14T17:55:26Z")

</div>

Hi @rezee , I would suggest the official dbt courses [Learn Analytics Engineering with dbt | dbt Learn](https://courses.getdbt.com/collections)