Update clickhouse data and starter site Analytics widget to use new field/property names

[john-thomas-dotcms]

Parent Issue

No response

Task

See #30411

The data already collected in clickhouse, and the analytics widget in the starter site, need to be modified so the field values match.

Proposed Objective

Technical User Experience

Proposed Priority

Priority 2 - Important

Acceptance Criteria

No response

External Links... Slack Conversations, Support Tickets, Figma Designs, etc.

No response

Assumptions & Initiation Needs

No response

Quality Assurance Notes & Workarounds

No response

Sub-Tasks & Estimates

No response

[freddyDOTCMS]

Some changes were done in the ClickHouse datase so we need to run the follow script

If you start with the events table already created then run first:

ALTER TABLE events DROP COLUMN object_id;
ALTER TABLE events DROP COLUMN rendermode;
ALTER TABLE events DROP COLUMN object_content_type_var_name;
ALTER TABLE events DROP COLUMN host;
ALTER TABLE events DROP COLUMN object_response;
ALTER TABLE events DROP COLUMN object_content_type_id;
ALTER TABLE events DROP COLUMN object_content_type_name;
ALTER TABLE events DROP COLUMN object_content_type_var_name;
ALTER TABLE events DROP COLUMN object_response;
ALTER TABLE events DROP COLUMN object_detail_page_url;
ALTER TABLE events DROP COLUMN object_url;

No matter if any on the statement fails just continue with the next one

Later run the follow statement, run just this second set if you start with a empty database

ALTER TABLE events ADD COLUMN object_working String;
ALTER TABLE events ADD COLUMN object_live String;
ALTER TABLE events ADD COLUMN object_contenttypeid String;
ALTER TABLE events ADD COLUMN object_contenttypename String;
ALTER TABLE events ADD COLUMN object_identifier String;
ALTER TABLE events ADD COLUMN conhost String;
ALTER TABLE events ADD COLUMN conhostname String;
ALTER TABLE events ADD COLUMN sessionid String;
ALTER TABLE events ADD COLUMN sessionnew bool;
ALTER TABLE events ADD COLUMN useragent String;
ALTER TABLE events ADD COLUMN object_contenttype String;
ALTER TABLE events ADD COLUMN languageid String;
ALTER TABLE events ADD COLUMN object_action String;
ALTER TABLE events ADD COLUMN object_forward_to String;
ALTER TABLE events ADD COLUMN object_basetype String;
ALTER TABLE events ADD COLUMN request_id String;
ALTER TABLE events ADD COLUMN object_title String;

[freddyDOTCMS]

I updated this document, the queries there were the test cases use to test the changes

https://docs.google.com/document/d/1Qq2v-rxYGmmNNZ2HrMvTiYMg59sQr6FfHXNIniCh3L4/edit?tab=t.0

[github-actions]

PRs:

• #30802 Updating CubeJs Schema to match with the last attribute renami… #31012