Dear daljeet-singh
Thank you very much for your reply.
I did read the document and could not find information about creating internal temp table during querying external table (permanent and temporary). That’s why I believe my colleagues misunderstand the meaning of temporary table. Temporary table does query files in GCS directly and doesn’t do create an internal temporary table and load data into it. Unfortunately, I can’t find GCP document mentioning the detail about how it works.
Thank you again
Best regards,