The Databricks assistant tells me (sometimes) that `CREATE TEMP TABLE` is a valid SQL operation.  And other sources (e.g., https://www.freecodecamp.org/news/sql-temp-table-how-to-create-a-temporary-sql-table/) say the same.

But in actual practice, this generates a syntax error.  And also, sometimes the Assistant tells me that it's not a valid operation, and I should use CREATE TEMP VIEW instead.  

But I don't want a view.  I want the data materialized.  Is there an option to actually do TEMP TABLE, or something like it?