Examples ccloud : ksqlDB queries : you now need to project key columns in value schema

The pageviews_regions query should now be something like this

CREATE TABLE pageviews_regions AS SELECT gender, regionid , AS_VALUE(gender) AS v_gender, AS_VALUE(regionid) AS v_regionid, COUNT(*) AS numusers FROM pageviews_female WINDOW TUMBLING (size 30 second) GROUP BY gender, regionid HAVING COUNT(*) > 1;

else the gender and regionid columns do not appear in resulting table