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

1. Login to SAP Analytics Cloud.
2. Navigate to the Databrick dataset
3. Click: "from a data source"
4. Select: "SQL databases"
5. For the Connection type, select: "Generic JDBC connection"
6. For connection, select: "databricks"
7. Click next and choose build a query
8. Notice the error message "An internal server error occurred in the Data Acquisition Service..."

• Databricks has a non-standard query specification, therefore using the Generic JDBC datasource is not fully compatible during the initial creation or edit workflow, and causes the error.

• Update the SAC agent driver properties file to enable native Databricks connection.  

  1. Add to the SAC agent driver properties file the Databrick connection. It will look like:
     
          Databricks=C:\JDBCDriver\DatabricksJDBC42.jar

  2. Create a new Databricks connection with connection type Databricks.
       

• Note: If you want to use the Generic JDBC connection to Databrick, use the Freehand SQL method instead of Build a Query, but note that the Edit query is disabled for Freehand SQL method.

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