# Load data from a non partition table to partition table

**URL:** <https://discourse.getdbt.com/t/load-data-from-a-non-partition-table-to-partition-table/10444>\
**Category:** Help\
**Created:** [October 20, 2023, 3:15pm UTC](https://discourse.getdbt.com/t/load-data-from-a-non-partition-table-to-partition-table/10444 "2023-10-20T15:15:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![aagnirupa](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/aagnirupa/32/3129_2.png) [@aagnirupa](https://discourse.getdbt.com/u/aagnirupa)\
**Post date:** [October 20, 2023, 3:15pm UTC](https://discourse.getdbt.com/t/load-data-from-a-non-partition-table-to-partition-table/10444/1 "2023-10-20T15:15:33Z")

</div>

Hi ,

I am trying to create a dbt model which will fetch data from a non partitioned table (Table A) and insert in a partitioned table (Table B). On daily basis , all data will be fetched from table A and will be inserted into a new partition in Table B.

```auto
{{
    config(
        materialized='incremental',
        partition_by = { 'field': 'load_dt', 'data_type': 'date' },
        incremental_strategy = 'insert_overwrite'
    )
}}

select * from {{ source('Own_Data', 'non_part_bike') }}

```

This one is working fine , but just trying to understand if there is a better approach or any other best practice for this.