In case someone facing the same error I can recommend to compare the schemas of you tables. My issue was difference between STRING - VARCHAR(), and TIMESTAMP_LTZ(3) - TIMESTAMP(3). After fixing the types my join work perfectly.
STRING
VARCHAR()
TIMESTAMP_LTZ(3)
TIMESTAMP(3)