3406001 - Cannot preview an imported remote table in Datasphere with SQL syntax error - SAP HANA Smart Data Integration

• When trying to preview an imported remote table in Datasphere, receiving the following error message.
  • The error message: internal error: Camel execution failed.
• The framework.trc from the Data Provisioning Agent may contain the following error message.
  • DatabaseSQLRewriter.rewrite [] - Rewritten SQL: SELECT TOP 1000  ***, "***" FROM "<Table_Name>", You have an error in your SQL syntax; check the manual that corresponds to your <> server version for the right syntax to use near '1000 "
  • DefaultErrorHandler | CamelLogger.log [] - Failed delivery for (MessageId: <Message_Id> on ExchangeId: <Exchange_ID>). Exhausted after delivery attempt: 1 caught: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1000  <table>.<column> ...' at line 1

• SAP HANA smart data integration
• SAP Datasphere

Camel execution failed, SDI, Datasphere, check the manual that corresponds to your <> server version for the right syntax to use near, TOP, LIMIT, preview, Data Viewer , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem