search

fivetran / dbt_stripe

Data models for Stripe built using dbt.
https://fivetran.github.io/dbt_stripe/
Apache License 2.0
30 stars 31 forks source link

[Feature] DuckDB Support #66

Open ericmichael opened 1 year ago

ericmichael commented 1 year ago

Is there an existing feature request for this?

Describe the Feature

I propose adding support for the DuckDB database engine in the fivetran/stripe package. DuckDB is an in-memory analytical database that is gaining popularity due to its speed and efficiency.

However, when trying to use the fivetran/stripe package with the dbt-duckdb adapter, I encountered an error related to the + operator not being supported for adding an interval to a string in DuckDB, similar to Postgres.

Describe alternatives you've considered

No response

Are you interested in contributing this feature?

Anything else?

https://github.com/jwills/dbt-duckdb

elanfivetran commented 1 year ago

Hey Eric, thanks for reaching out about this and we're glad that you are finding value out of Stripe data.

Considering that your organization uses DuckDB it definitely makes sense that you would like destination support there. Since Fivetran currently does not support DuckDB as a database we would not make this change ourself, however if you are open to creating a PR for the addition our team would happily review it and include the update in our package.

I noticed you are interested in coming to our office hours however I do not that you scheduled any time with us yet. If you would like some assistance with creating the PR, you can schedule time for office hours using this link.