fivetran / dbt_shopify_source

Fivetran's Shopify source dbt package
https://fivetran.github.io/dbt_shopify_source/
Apache License 2.0
29 stars 23 forks source link

No staging file for fulfillment order line table #62

Open MounikaKusampudi opened 1 year ago

MounikaKusampudi commented 1 year ago

I am trying to transform fulfillment data. As I checked there is no staging table for fulfillment order line table.

I am using name: 'shopify' version: '0.8.0'.

Please suggest a way or any other version which has staging table for the same.

fivetran-joemarkiewicz commented 1 year ago

Hi @MounikaKusampudi thanks for opening this feature request.

You are correct at the moment the fulfillment order line table is not included in our Shopify package. That being said, this is a relevant feature request we can scope out for a future enhancement to the package. If you are interested in contributing, I would also be happy to review a PR if you wanted to add the fulfillment order line table to the package.

Otherwise, for the time being you will be able to stage and transform this data outside of the package. If you then wanted to combine the data with the output models of this package you can perform a join or other transformation on top of the package models.