Hey,
Is your table in Unity Catalog or in Hive Metastore ?
just my guess(es):

- use full table path Catalog_name.Schema_Name.Table_name (maybe you had some context saved when querying data interactively. 

- if your table is in UC - is your Job Cluster running in UC enabled mode (single / shared) ? 

From your post it is bit uncleare where and what you are running.