When attempting to import data from PostgreSQL or PostgreSQL-compatible databases (such as Amazon Redshift or HP Vertica), the data import may fail with the error: “Can’t transform a data frame with duplicate names.” In some cases, re-importing data may also fail, even if it had been 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 identical column names, a suffix was automatically appended to make each column name unique.
However, in the latest version, this behavior has been removed. As a result, this error is triggered when duplicate column names are passed.
If you encounter this error, please modify your SQL query to rename or exclude the duplicate columns to ensure that all column names are unique.