https://community.databricks.com/t5/get-started-discussions/sql-query-on-information-schema-tables-via-service-principal/m-p/61061#M6561 <P>Hi,</P><P>I have a simple python notebook with below code -</P><P>---</P><DIV><DIV><SPAN>query </SPAN><SPAN>=</SPAN> <SPAN>"select table_catalog, table_schema, table_name from system.information_schema.tables where table_type!='VIEW' and table_catalog='TEST' and table_schema='TEST'"</SPAN></DIV><DIV><SPAN>test </SPAN><SPAN>=</SPAN><SPAN> spark</SPAN><SPAN>.sql</SPAN><SPAN>(query)</SPAN></DIV><DIV><SPAN>display</SPAN><SPAN>(test)</SPAN></DIV><DIV><SPAN>---</SPAN></DIV><DIV>&nbsp;</DIV><DIV>Running the above in my workspace returns a dataframe with appropriate results. But running the same as a task in a job which runs as a service principle is not returning any results and gives the output as "<SPAN>Query returned no results". I ensured service principal has select grant on&nbsp;system.information_schema.tables.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>What am I missing here? Appreciate the help.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>THank you</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV></DIV> Mon, 19 Feb 2024 08:03:31 GMT Sanky 2024-02-19T08:03:31Z https://community.databricks.com/t5/get-started-discussions/sql-query-on-information-schema-tables-via-service-principal/m-p/61061#M6561 <P>Hi,</P><P>I have a simple python notebook with below code -</P><P>---</P><DIV><DIV><SPAN>query </SPAN><SPAN>=</SPAN> <SPAN>"select table_catalog, table_schema, table_name from system.information_schema.tables where table_type!='VIEW' and table_catalog='TEST' and table_schema='TEST'"</SPAN></DIV><DIV><SPAN>test </SPAN><SPAN>=</SPAN><SPAN> spark</SPAN><SPAN>.sql</SPAN><SPAN>(query)</SPAN></DIV><DIV><SPAN>display</SPAN><SPAN>(test)</SPAN></DIV><DIV><SPAN>---</SPAN></DIV><DIV>&nbsp;</DIV><DIV>Running the above in my workspace returns a dataframe with appropriate results. But running the same as a task in a job which runs as a service principle is not returning any results and gives the output as "<SPAN>Query returned no results". I ensured service principal has select grant on&nbsp;system.information_schema.tables.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>What am I missing here? Appreciate the help.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>THank you</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV></DIV> Mon, 19 Feb 2024 08:03:31 GMT https://community.databricks.com/t5/get-started-discussions/sql-query-on-information-schema-tables-via-service-principal/m-p/61061#M6561 Sanky 2024-02-19T08:03:31Z