Skip to content

Parse error for '\' for dbt seed on dbt-databricks adapter #249

@gunnava

Description

@gunnava

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions