3644942 - Error connecting to Databricks datasets and editing queries in SAP Analytics Cloud (SAC)

• Error: "An internal server error occurred in the Data Acquisition Service", when choosing build a query from datasets connection to databricks, in SAP Analytics Cloud.
• Choosing Edit > Query on affected import job gives similar error message.
• Tomcat logs show error:
     
  "Error occurred in the SAP Analytics Cloud agent Service: "[Simba][SparkJDBCDriver](500051) ERROR processing query/statement.
   Error Code: 0, SQL state: org.apache.hive.service.cli.HiveSQLException: Error running query: [UNRESOLVED_COLUMN.WITH_SUGGESTION] org.apache.spark.sql.catalyst.ExtendedAnalysisException:
   [UNRESOLVED_COLUMN.WITH_SUGGESTION] A column, variable, or function parameter with name `column_key` cannot be resolved. Did you mean one of the following?
   [`column_name`, `column_default`, `comment`, `table_name`, `data_type`]. SQLSTATE: 42703;"  

SAC Analytics Cloud 2025.14.17

sac, query, table, databricks, datasets, databrick, dataset, SQL,  , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem