Hi @Saf4Databricks ,

As mentioned in databricks documentation and also by @balajij8 , you can only use temp table with SQL warehouse cluster. if you are working with non-serverless cluster i.e. interactive cluster then simply run your Called_Notebook in your Caller_Notebook in first cell.
once you run your called_notebook as your first cell then the created temp view directly available to query in your caller notebook.

PFB sample code in caller_notebook:

cell 1:

%run ./Called_Notebook

cell 2:

df = spark.table("myview")
df.display()

or also you can try 

%sql SELECT * FROM myview

Please try it and accept as solution if its working as per your requirement