When attempting to import data from a database, you may encounter the error "Can't transform a data frame with duplicate names" and the import will fail. In some cases, re-importing data may fail even if the data could be successfully imported in the past.
This error occurs when you attempt to import data that contains duplicate column names.
In older versions of Exploratory, when importing data with columns sharing the same name, suffixes were automatically appended to make each column name unique.
However, this behavior has been discontinued in the latest version. As a result, duplicate column names are now passed through as-is, triggering this error.
If you encounter this error, please modify your SQL query to rename or exclude the duplicate columns so that all column names are unique.