Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

How to keep data in events_intraday table

Hi there,

I would like to force certain data to insert in the events_intraday_YYMMDD table every day.
But as soon as this table becomes events_YYYMMDD, certain data I put in disappears.
Is there a way to keep the data I'm forced to insert?
 
 

 

INSERT INTO `events_intraday_20240229` (event_date, event_timestamp, event_name, event_params)
VALUES
  (
    '20240229', UNIX_MICROS(CURRENT_TIMESTAMP()), 'TEST_EVENT', ARRAY<STRUCT<key STRING, value STRUCT<string_value STRING, int_value INT64, float_value FLOAT64, double_value FLOAT64>>>[("name", ('test', null, null, null))]
  );

 

1 2 236
2 REPLIES 2