https://community.databricks.com/t5/get-started-discussions/sql-end-point-and-jdbc-driver/m-p/45027#M5814 <P>When we try and connect to a sql warehouse endpoint with the databricks jdbc driver our query is failing if we use first_value().&nbsp; We've rewritten the query to use limit 1, but we would like to understand if this is a gap in the simba/databricks driver or in the sql warehouse endpoint/databricks.</P><P>&nbsp;</P> Fri, 15 Sep 2023 13:59:33 GMT 190857 2023-09-15T13:59:33Z https://community.databricks.com/t5/get-started-discussions/sql-end-point-and-jdbc-driver/m-p/45027#M5814 <P>When we try and connect to a sql warehouse endpoint with the databricks jdbc driver our query is failing if we use first_value().&nbsp; We've rewritten the query to use limit 1, but we would like to understand if this is a gap in the simba/databricks driver or in the sql warehouse endpoint/databricks.</P><P>&nbsp;</P> Fri, 15 Sep 2023 13:59:33 GMT https://community.databricks.com/t5/get-started-discussions/sql-end-point-and-jdbc-driver/m-p/45027#M5814 190857 2023-09-15T13:59:33Z https://community.databricks.com/t5/get-started-discussions/sql-end-point-and-jdbc-driver/m-p/45028#M5815 <P>A sample error message when using first_value() is:</P><P><SPAN>An error occurred while calling o132.csv. [Databricks][JDBC](10140) Error converting value to BigDecimal.</SPAN></P> Fri, 15 Sep 2023 14:04:19 GMT https://community.databricks.com/t5/get-started-discussions/sql-end-point-and-jdbc-driver/m-p/45028#M5815 190857 2023-09-15T14:04:19Z