3747209 - Error:"Error occurred during the execution of a database statement" while deploying Remote Table from Databricks JDBC Connection - SAP HANA Smart Data Integration

• Try to deploy remote table through JDBC connection in sap datasphere failed with error
• Error: "Error occurred during the execution of a database statement correlation ID ***"
• In DP agent log, similar log when TRACE level is enabled. Duplicate column name listed
  WorkerThread.processImportMetadata [] - Response body:
                                  TableMetadata
                                  physicalName=***
                                  Number of Columns: 9
                                  Test_ID         VARCHAR (100)   NULL                            
                                  Test_Name             VARCHAR (100)   NULL    
                                  Test_ID         VARCHAR (100)   NULL                            
                                  Test_Name             VARCHAR (100)   NULL            
• In hana index server alert file, following error showed
  Failed to create virtual table: duplicate column name: Test_Name: line 1 col 71 (at pos 70) 

• SAP HANA Smart Data Integration
• SAP Datasphere

Remote table, deploy, failed, duplicate, column , KBA , HAN-DP-SDI-DS , SAP Datasphere specific SDI issues , Problem