DuckDb command not working in DataGrip but works in DuckDb CLI
Answered
If Irun this command using the DuckDB CLI it works fine:
CREATE TABLE Usage AS SELECT * FROM read_csv('Usage_2022*.txt', delim='\t',QUOTE='',HEADER=true,AUTO_DETECT=TRUE);
But when I run the same command within DataGrip query console the command fails.
Or, it runs but the parsing is not working so the header is just read in as a single VARCHAR column.
I suspect this is has to do with the tab character not being passed along to the DuckDb.
Has anyone here got any suggestions for how to fix this?
My settings are as follows
Please sign in to leave a comment.
I found out that the dialect for the driver had to be changed to SQLite. Once I did that it works fine.