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
-
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