Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create dbt converter for Airbyte Shopify source connector #28

Open
marcosmarxm opened this issue Jul 2, 2024 · 11 comments · May be fixed by #63
Open

Create dbt converter for Airbyte Shopify source connector #28

marcosmarxm opened this issue Jul 2, 2024 · 11 comments · May be fixed by #63
Assignees

Comments

@marcosmarxm
Copy link
Member

The goal of this task is to ensure the Airbyte Shopify connector output can be used to run Fivetran's dbt analytical model.

Definition of Done:

  • Create a pull request that adds new tables or views, enabling the execution of Fiventran's dbt with Airbyte output data.
  • Update the documentation inside the connector folder to explain how to configure the user dbt package to run the analytical model.

Resources:

@avirajsingh7
Copy link

Hey @marcosmarxm , Can you assign me this one?

@marcosmarxm
Copy link
Member Author

@avirajsingh7 any updates if not I'm gonna unassigned you.

@bala-ceg
Copy link

@marcosmarxm can u please assign this to me if the issue is available

@marcosmarxm
Copy link
Member Author

@avirajsingh7 do you have an update? I know this connector there are a lot of to be done but need to update about the status.

@avirajsingh7
Copy link

@marcosmarxm not done much of work, you can assign this to @bala-ceg

@marcosmarxm marcosmarxm assigned bala-ceg and unassigned avirajsingh7 Aug 20, 2024
@marcosmarxm
Copy link
Member Author

@bala-ceg all yours.

@bala-ceg
Copy link

@marcosmarxm, Please review the step 1

Fivetran Airbyte
shopify__customer_cohorts ❌ it doesn't exist
shopify__customers Customers
shopify__customer_email_cohorts ❌ it doesn't exist
shopify__customer_emails ❌ it doesn't exist
shopify__orders Orders
shopify__order_lines ❌ it doesn't exist
shopify__products Products
shopify__transactions Transcations
shopify__daily_shop ❌ it doesn't exist
shopify__discounts Discount Codes
shopify__inventory_levels Inventory Levels
shopify__line_item_enhanced ❌ it doesn't exist

@marcosmarxm
Copy link
Member Author

@bala-ceg can you check if the customer table has an object or array called cohors/emails?

@bala-ceg
Copy link

bala-ceg commented Aug 23, 2024

yes,@marcosmarxm. customer table has emails. Can i go ahead to next step?

@marcosmarxm
Copy link
Member Author

No can you confirm all missing tables have objects in the parent table?

@bala-ceg
Copy link

bala-ceg commented Aug 23, 2024

Yes i have checked, those missing tables are not in any of the airbyte shopify streams.

@bala-ceg bala-ceg linked a pull request Sep 4, 2024 that will close this issue
@topefolorunso topefolorunso linked a pull request Sep 4, 2024 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants