[google-cloud-sql-discuss] Re: auto sync table using query

Dully Noted and thanks for bringing it to my attention.

On Monday, December 16, 2019 at 8:38:42 PM UTC+5:30, Jun (Cloud Platform Support) wrote:

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.

On Friday, November 29, 2019 at 8:45:30 AM UTC-5, LETS LEARN SOMETHING wrote:

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

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/c7a63df7-8f6a-474a-8801-b12f0898b010%40googlegroups.com.