-
Notifications
You must be signed in to change notification settings - Fork 190
Parse error for '\' for dbt seed on dbt-databricks adapter #249
Description
### Describe the bug
With the dbt databricks adaptor dbt seed is throwing a parse error for /; . dbt seed command runs fine when using the dbt-spark adapter.
Rows in the CSV that cause issues:
Macy's Canada,Macy's
Macy's,Macy's
### Steps To Reproduce
Create a seed csv file with the data that contain spl character \
Sample data:
store1,store2
Macy's Canada,Macy's
Macy's,Macy's
Run dbt seed on data bricks warehouse using dbt-databricks adapter. it throws the below error:
[PARSE_SYNTAX_ERROR] Syntax error at or near ','
Expected behavior
dbt seed command should parse the special characters as well
Screenshots and log output
debug logs for both the runs using dbt-sparks adapter and dbt-databricks adapter are attached.
console_output_dbt-sparks.txt
dbt seed_output_dbt-databricks.txt
System information
The output of dbt --version:
"dbt_version": "1.3.2", "dbt_databricks_version": "1.3.2",
Works perfectly in dbt-spark adaptor but not in dbt-databricks adaptor
Additional context
Add any other context about the problem here.