I am having a number of problems with importing CSV data:
- Sometimes when I select a file to import it just hangs. The file is imported into Files, but it does not present the next screen to match the data types.
- Even when I have an existing table and have disabled dynamic schema definition, the import changes the format of all STRING columns to 500 and adds columns, rather then generating an error.
- If I add the type definition in the column names, I get an invalid file format error after selecting a file, so this does not appear to be a workaround for the above issue.
- After accidentally trying to import a column called invoiceId when the matching column in the database is called invoice, when I try and change the invoice column name to invoiceid I get a duplicate column error even though the column doesn’t apear in either the schema or the data browser.