Trying to import a 6 column CSV into a Azure SQL database table via the DataGrip import feature.
I'm setting all columns to VARCHAR(MAX) datatype as I have no need for typing in a quick bit of analysis I want to do.
Import creates the table fine then fails with error:
class java.lang.String cannot be cast to class java.lang.Number
I'm not trying to cast any string field as a number so this is confusing.
Anyone encountered this before? Thanks.