user_id in segment.pages is bigint and can't be unioned with varchar

[ernestoongaro]

Getting these errors:

UNION types character varying and bigint cannot be matched
COALESCE types bigint and character varying cannot be matched

so added cast of user_id to varchar in the following places and working fine. Not sure if Segment changed the user_id type in the Redshift destination or why this happened now.

segment_1_aliases_mapping.view.lkml-        union
segment_1_aliases_mapping.view.lkml-
segment_1_aliases_mapping.view.lkml:        select user_id::varchar
segment_1_aliases_mapping.view.lkml-          , null
segment_1_aliases_mapping.view.lkml-          , received_at
--
--
segment__A_alias_mapping.view.lkml-
segment__A_alias_mapping.view.lkml-        select anonymous_id
segment__A_alias_mapping.view.lkml:          , user_id::varchar
segment__A_alias_mapping.view.lkml-          , received_at
segment__A_alias_mapping.view.lkml-        from segment.pages
--
--
segment__A_alias_mapping.view.lkml-        union
segment__A_alias_mapping.view.lkml-
segment__A_alias_mapping.view.lkml:        select user_id::varchar
segment__A_alias_mapping.view.lkml-        , null
segment__A_alias_mapping.view.lkml-        , received_at
--
--
segment__B_mapped_events.view.lkml-        from segment.pages as t
segment__B_mapped_events.view.lkml-        inner join ${page_aliases_mapping.SQL_TABLE_NAME} as a2v
segment__B_mapped_events.view.lkml:          on a2v.alias = coalesce(t.user_id::varchar, t.anonymous_id)
segment__B_mapped_events.view.lkml-      ) as e
segment__B_mapped_events.view.lkml-       ;;