Connector Improvement: Add Date column to Event Param and User property in GA4
Our GA4 event_param and user_property are HUGE, the only way to link the tables to the Event table is by using the _fivetran_id
Adding the Date column to all tables will allow the creation of a cluster key on this column thus avoiding full table scans.
Hi Alberto, Drew from the product team here.
Do you have any data on how much not having date affects query speeds or cost? This is something we will also test internally.
Please sign in to leave a comment.