I am a bit confused about how to use range join hints. Consider the following query ```SELECT p.id, p.ts, p.value, rg.metric1, rg.metric2, rg.ts AS range_tsFROM points pLEFT JOIN LATERAL ( SELECT r.metric1, r.metric2, r.ts FROM ranges r WHE...
This article (Connect Python and pyodbc to Databricks | Databricks on AWS) states the following"However pyodbc may have better performance when fetching queries results above 10 MB."This is a bit vague. The word "may" implies "maybe not". Also, "bett...
Interesting article but it seems that Cloud Fetch is supported on both odbc and sql connectorDriver capability settings for the Databricks ODBC Driver | Databricks on AWSDatabricks SQL Connector for Python | Databricks on AWS (see section getting sta...
