-
Notifications
You must be signed in to change notification settings - Fork 153
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
[Regression] dbt seed is not accepting custom delimiter in the seed configs #1352
Comments
Thanks for reporting this @roshravoof ! I was able to replicate what you described. This only looks like it affects dbt-bigquery (and not dbt-postgres, dbt-snowflake, etc), so I'm going to transfer this issue to the dbt-bigquery repo. ReprexCreate these files:
seeds:
- name: mappings
config:
delimiter: '|' Run these commands: dbt seed See this output in dbt 1.6:
See this output in dbt 1.7 and 1.8:
|
@dbeatty10 is this still an issue as it works with the latest version. Anything I can do on this issue? |
Took a look at this, what's interesting is that without the it seems to work if you do it in dbt_project.yml like:
|
Will investigate what/how dbt-bigquery is handling this differently |
So after much investigating it's not clear exactly what broke this functionality in 1.7 but I can confirm it works in 1.6. This was already being fixed (see #1122) in the upcoming 1.9 release but we'll look at backporting to 1.8 as well |
Is this a new bug in dbt-core?
Current Behavior
dbt seed is not accepting custom/pipe delimiter in the seed configs
Above seed config doesnt work in dbt version 1.7.18
Expected Behavior
dbt seed should accept any custom or multiple delimiters in the seed configs. dbt seed should be able to process comma and pipe delimited files in the same project.
Steps To Reproduce
setup dbt version 1.7.18 and python version 3.11
Setup seed config
Relevant log output
No response
Environment
Which database adapter are you using with dbt?
bigquery
Additional Context
No response
The text was updated successfully, but these errors were encountered: