RE: How BigQuery external table works?
To directly query a Cloud Storage external data source, provide the Cloud Storage URI path to your data and create a table that references the data source. The table used to reference the Cloud Storage data source can be a permanent table or a temporary table.
Which is achieving through selecting External Table ‘Yes’ and provide the Cloud Storage source URI path which is referencing external table. This option is given at design level.