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 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?

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.

     

     

4 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    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.