Can I escape single quotes in seed csv? #1143
Unanswered
dargmuesli
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
When a seed .csv file contains single quotes in a string field, the SQL insert fails. A
.csv
file with the following content...... for example crashes due to an "unexpected
^
" as the first'
throws off the insert statement which itself uses single quotes for strings. Is there a way to tell dbt to escape such'
characters?I found macros/utils/escape_single_quotes.sql but as I understand it this macro should already be applied? Maybe it serves a different use-case, I'm not entirely sure.
Beta Was this translation helpful? Give feedback.
All reactions