'Create Table As' in BigQuery

Question

How to create a table on the basis of result of select query in BigQuery?

For example:

create table abc as select x,y,z from mnp;

Is there any way or workaround to achieve the same in BigQuery?

Any leads?

Answer 1

Just try giving the GCP folder name before table name in create table statement.

Example:

create table [GCP_Folder].abc as select x,y,z from mnp