title: How to query data from Azure Databricks Spark cluster without notebooks?
body: <p>I have a running Spark 2.3.1 cluster hosted in https:azuredatabricks.net, I have created a database with a permanent table and I have been able to run queries through the Notebook web interface.<br>
  Now I am looking for a way to query the same cluster from a .Net console application and I am lost.    </p>
  
  <p><strong>1. Is there Rest API that can be used to perform SQL/Python queries?<br>
  2. How to configure ODBC connection string to connect to the cluster and what are the working ODBC drivers out there?</strong></p>
  
  <p>Eventually I am looking for a way to enable users to run one of several predefined parametrized queries against the Spark cluster through a Web App/REST service written using JavaScript or .Net code.</p>