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

[Feature] dbt seeds - STRING as default for the entire project #10985

Open
3 tasks done
a51001k opened this issue Nov 10, 2024 · 1 comment
Open
3 tasks done

[Feature] dbt seeds - STRING as default for the entire project #10985

a51001k opened this issue Nov 10, 2024 · 1 comment
Labels
enhancement New feature or request triage

Comments

@a51001k
Copy link

a51001k commented Nov 10, 2024

Is this your first time submitting a feature request?

  • I have read the expectations for open source contributors
  • I have searched the existing issues, and I could not find an existing issue for this feature
  • I am requesting a straightforward extension of existing dbt functionality, rather than a Big Idea better suited to a discussion

Describe the feature

dbt seeds seemingly automatically decides data types before inserting data into for example Snowflake.

In our use-case it would be helpful if it was possible to set string as default for the entire dbt project.

That way our pipelines would be more predictable, and we can ourselves change string into number/boolean/date etc. in a staging-layer.

Describe alternatives you've considered

Hardcoding every single column into string. This is a pain.

Who will this benefit?

Everyone who wants to have predictable dbt seeds and treat seeds as an ingest.

Are you interested in contributing this feature?

No response

Anything else?

No response

@a51001k a51001k added enhancement New feature or request triage labels Nov 10, 2024
@kmarq
Copy link

kmarq commented Nov 12, 2024

Tried to override this behavior, but it had numerous challenges to do. I'd definitely appreciate this as an option. It allows loading seed files without defining each and every column in a yaml if all you want is for it to load as strings.
Even being able to default to String on a per seed file basis that'd be a big improvement.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request triage
Projects
None yet
Development

No branches or pull requests

2 participants