[CT-1543] [Bug] dbt seed raise error mismatched input 's' when there is 's in csv file

[grhaonan]

Is this a new bug in dbt-core?

• I believe this is a new bug in dbt-core
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

dbt seed will raise the following error when there is a 's expression in csv

botocore.errorfactory.InvalidRequestException: An error occurred (InvalidRequestException) when calling the StartQueryExecution operation: line 2:2611: mismatched input 's'. Expecting: ')', ','
Failed to execute query.

Expected Behavior

it should work

Steps To Reproduce

csv with format

2500, dustin's test

The issue will gone if it is

2500, dustins test, the issue is ' character before the letter s

Relevant log output

No response

Environment

- OS: Macos 12.6
- Python: 3.9
- dbt: 1.0.8
- athena plugin athena: 1.0.1

Which database adapter are you using with dbt?

No response

Additional Context

I am not sure if this issue is related to athena adapter or dbt core

if ' character is not supported in the csv form seed would expect, may I suggest to update the documentation to mention this limitation as I spent 1 hour to figure out this.

if ' character is supposed to be supported( my understanding), then this is an issue either related to core or athena adapterfiguring

[dbeatty10]

Thanks for reaching out @grhaonan !

Did you include column headers in the first line of CSV (like my_number,my_string as shown below)?

If so, then I suspect this is an issue in Athena adapter you are using, as all of the following work for me when testing with dbt-snowflake:

my_number,my_string
2500,dustin's test

Or:

my_number,my_string
2500,"dustin's test"

Or:

my_number,my_string
"2500","dustin's test"

[grhaonan]

Hi Doug,

Thanks for your quick check and test.

Yes, it did have the headers and I am able to reproduce the issue with your sample as well

The issue is gone after removing the ' before s

Okay, I will route this issue to athena-adapter community then, thanks for your help.

[dbeatty10]

Closing in favor of dbt-athena/dbt-athena#60

[owenprough-sift]

Closing in favor of dbt-athena/dbt-athena#60

@dbeatty10 you may have forgotten to close this issue. :)

[dbeatty10]

😅 Thank you @owenprough-sift