RE: How BigQuery external table works?
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.
gs://[BUCKET]/my/object/name
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.
