I'd recommend following the Databrick's guide to accomplish this:
https://docs.cloud.databricks.com/docs/latest/databricks_guide/index.html#04%20SQL,%20DataFrames%20%...
I've imported this guide myself into my environment and was able to get a similar example working no problem.
