Oracle Federation failing to find a data source

Upgrade compute runtime to 16.1 or use Pro SQL warehouse 2024.50

Written by alberto.umana

Last published at: March 12th, 2025

Problem

When exploring a federated catalog in the UI connected to an Oracle database, you receive an error message. 

Failed to find the data source: UNKNOWN_CONNECTION_TYPE

 

Cause

You are using an unsupported version of Databricks Runtime to access the table or catalog. 

Additionally, network connectivity issues between the Databricks compute resource and Oracle can contribute to the issue.

 

Solution

If you are using all-purpose compute, ensure that you are using Databricks Runtime 16.1 or above. For more information, refer to the Run federated queries on Oracle (AWS | Azure | GCP) documentation.

If you are using SQL Pro Warehouse, ensure it is running version 2024.50 or above. 

 

To ensure network connectivity between the Databricks compute resource and Oracle, run the following command in a notebook.

%sh
nc -vz <your-oracle-database-hostname> <your-oracle-database-port>

 

If network connectivity is failing, follow steps in the Networking recommendations for Lakehouse Federation (AWS | Azure | GCP) documentation to establish the connection.