@Andrew Begg​ 

First of all, cache table creates a view, not table, so you won't be able to use pd.read_table (https://docs.databricks.com/sql/language-manual/sql-ref-syntax-aux-cache-cache-table.html).

About the second method - .select() still gives a dataframe as an output. You need to find a way to convert DF to dict.