create TRANSIENT TABLE SUNO_PROD.PROD.FACT_CLIP_STATUS cluster by (p_date, p_hour)(
	CLIP_ID VARCHAR(255),
	IS_PUBLIC BOOLEAN,
	IS_DELETED BOOLEAN,
	LIKE_COUNT NUMBER(38,0),
	DISLIKE_COUNT NUMBER(38,0),
	FLAG_COUNT NUMBER(38,0),
	PLAY_COUNT_DISPLAYED NUMBER(38,0),
	DOWNLOAD_AUDIO_MP3_COUNT NUMBER(38,0),
	DOWNLOAD_AUDIO_WAV_COUNT NUMBER(38,0),
	DOWNLOAD_VIDEO_COUNT NUMBER(38,0),
	SHARE_COUNT NUMBER(38,0),
	P_DATE DATE,
	P_HOUR NUMBER(38,0)
);