auto sync table using query

[LETS LEARN SOMETHING]

HI friends ,

I am new in Google Big query . Currently I am trying to create a table/view based on data of few different tables.

let us assume the query is like this :

create table datasetC.TableA as

select col1, col2, ..... from (

select col1,col2,col3 ,sum(col5),sum(col6) .....

   datasetA.tableA   left join  datasetA. tableb   left join  datasetA.tablec ) inner join ( select ....... datasetA.tablea ,datasetA.tableb)

union all

select col1, col2, ..... from (

select col1,col2,col3 ,sum(col5),sum(col6) .....

   datasetB.tableB   left join   datasetB.tableC   left join  datasetB.tableD ) inner join ( select ....... datasetB.tablee ,datasetB.tablef)

Now these tables are being refreshed at different times and while loading data in our table, we may have some tables which are yet to be refreshed.

Is there any way to set auto sync of the table just like we have materialised view.

normal view is not reliable as we have very huge data (around 6 tables with 50+ TB of data )  and we get memory issue.

any advice will be helpful .

Thanks in advance

[Jun (Cloud Platform Support)]

Hi, 

Google Groups are reserved for general product discussion, StackOverflow for technical questions whereas Issue Tracker for product bugs (unexpected behaviors) and feature requests.

To get a better support you should post to the relevant forum, thus please read the Community Support article for better understanding.

[LETS LEARN SOMETHING]

Dully Noted and thanks for bringing it to my attention.