3278495 - [CamelJdbcAdapter] SELECT query causes syntax error - SAP HANA Smart Data Integration

• Connection test works towards Azure Databricks / Snowflake / MySQL through an SDI CamelJDBCAdapter remote source.
• Able to retrieve the table list from the remote source and browse the remote object list.
• Running a SQL statement in a isql session (e.g. HANA ODBC Databricks connection) retrieves the result.
• Running a simple SELECT query via the SDI remote source throws the following error:
  • SELECT "DatabricksTest"."date", "DatabricksTest"."client_id", "DatabricksTest"."engagement_score", "DatabricksTest"."date_part" FROM "clean"."databricks_test_table_ci_cd_csv" "DatabricksTest" [PARSE_SYNTAX_ERROR] org.apache.spark.sql.catalyst.parser.ParseException: [PARSE_SYNTAX_ERROR] Syntax error at or near '"date"'
• The above example is taken from Databricks. The exact error message might differ between databases, but it is always a SQL syntax error (e.g. "java.sql.SQLSyntaxErrorException").

• SAP HANA Smart Data Integration
• CamelJdbcAdapter

CamelJdbcAdapter, databricks, parsing, starrocks, snowflake, mysql, syntax error, delimident, delimiter , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem