id | col1 | col2 | load_date | source |
---|---|---|---|---|
1001 | a | g | 2024-01-03 | latest |
1001 | a | g | 2024-01-02 | history |
1001 | a | b | 2024-01-01 | history |
1002 | d | e | 2024-01-01 | history |
1003 | q | r | 2024-01-03 | latest |
(3 rows affected)
(5 rows affected)
id | col1 | col2 | load_date | source |
---|---|---|---|---|
1001 | a | g | 2024-01-03 | latest |
1001 | a | g | 2024-01-02 | history |
1001 | a | b | 2024-01-01 | history |
1002 | d | e | 2024-01-01 | history |
1003 | q | r | 2024-01-03 | latest |