create TRANSIENT TABLE SUNO_PROD.PROD.AGG_PLAY_INFO_HOURLY_V0 cluster by (p_date, p_hour)(
	CLIP_ID VARCHAR(255),
	USER_ID NUMBER(38,0),
	USER_UID VARCHAR(255),
	PLAY_DURATION_SEC FLOAT,
	PLAY_CNT NUMBER(38,0),
	PLAY_DURATION_THRESHOLD FLOAT,
	IS_USER_SONG_OWNER BOOLEAN,
	PLATFORM VARCHAR(255),
	P_DATE DATE,
	P_HOUR NUMBER(38,0),
	IOS_TEMP_PLAY_DURATION_SEC FLOAT
);
