Forum Discussion

Don-Bot's avatar
Don-Bot
Icon for Helper V rankHelper V
1 year ago
Solved

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

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 databric...
Need Help
  • MFelix's avatar
    MFelix
    1 year ago

    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's avatar
Don-Bot
Icon for Helper V rankHelper V
1 year ago

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's avatar
MFelix
Icon for Super User rankSuper User
1 year ago

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's avatar
    Don-Bot
    Icon for Helper V rankHelper V
    1 year ago

    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.