Seeds headers limitations

Help
1

Where can I find information about what headers of a csv file can and can’t look like? I’ve been trying to load a CSV with all columns and values quoted and I’m still getting a lot of errors:

←[0m11:47:45    001003 (42000): SQL compilation error:
←[0m11:47:45    syntax error line 1 at position 91 unexpected '-'.
←[0m11:47:45    syntax error line 1 at position 144 unexpected '-'.
←[0m11:47:45    syntax error line 1 at position 202 unexpected '-'.
←[0m11:47:45    syntax error line 1 at position 259 unexpected 'Formal'.
←[0m11:47:45    syntax error line 1 at position 266 unexpected 'text'.
←[0m11:47:45    syntax error line 1 at position 278 unexpected 'Code'.
←[0m11:47:45    syntax error line 1 at position 290 unexpected ','.
←[0m11:47:45    syntax error line 1 at position 304 unexpected 'Region'.
2

@moseleyi the seed parsing is handled by the agate library, and I’m pretty sure this is the method we use: Table.from_csv

Can you post the specific csv you’re trying to use as a seed?

3

Thanks @joellabes . Here is the dataset: https://www.datahub.io/core/country-codes

4

Do you mean you’ve been using quote_columns | dbt Developer Hub?

5

Yes I have tried with and without that setting