Azure Databricks Query: The key didn't match any rows in the table

[Don-Bot]

I am attempting to use the azure databricks connection but instead of searching for a table I want to use a query.  However, even though I am throwing in a very simple query that works in my databricks notebook I am getting the error "The key didn't match any rows in the table"


I have tried just using a from clause that has the catalog, db, table and one with just the table.

Is there some special way to get queries to work against azure databricks using that connector?

[MFelix · Accepted solution]

Hi @Don-Bot ,

If I'm not mistaken you need to define the default catalog on the Databvricks connection when using a query, even if it's not the catalog you want to use on the sql query just add one on the connection string.

[Don-Bot]

Hi @MFelix ,
I have done that and it willl error if it ry to remove catalog.

and then i get

If I modify what i have a little bit.  IE:  Put in the db in the query and remove it from the above list I get

a working query.....  I swear it didn't work when I was testing this.... 

[MFelix]

Hi @Don-Bot ,

This is very picky you when you want to use a query you need to define the optional fields but also add them to the query.

What I have done in my use cases I have made parameter for each one and a SQLQuery line to be pickedup that way when I want to update everything I just need to change the parameters.

[Don-Bot]

Hi @MFelix ,

I agree on the parameters, and for my other models I am heavily invested in the parameters but I'm not using queries.  Just pointing to already created tables/views.  This was a special need and was trying to setup a dummy pbi to make sure it would work.  

Quite annoying but thanks for the help.