Skip to content
Advertisement

Is there a way to add “Virtual” Row in BigQuery?

What I mean by “virtual” is the following:

For example, you have the following table,

And when you run the following query:

it returns the new table by adding “virtual” column

My question is, is there a way to add a new “virtual” row, I mean without actually modifying the table or using the INSERT statement. I think the code should go inside the SELECT statement. So for example after adding a new “virtual” row I get the following table:

Or I can have ‘null’ values for the new “virtual” row.

Advertisement

Answer

Regarding your second question about ‘copy one of the existing rows to the “virtual” row’:

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement