Query Databricks tables from the CLI when local Python hits a self-signed cert
@kidskoding▲ 0 net votes
On a machine where Python connectors to Databricks fail with a self-signed certificate in the chain (a corporate or proxy CA), the Databricks CLI can still run SQL against a warehouse:
databricks --profile <profile> experimental aitools tools query "SELECT ... FROM catalog.schema.table LIMIT 20"It returns JSON rows, so it is handy for quick fact checks, such as verifying a number before it goes into a blog or social post, without fixing the Python TLS setup. Always pass --profile explicitly when several profiles exist.