Test Data
create table source_data_2 (
id bigint not null constraint source_data_2_pk primary key,
name text not null,
created_at timestamp without time zone not null);
insert into source_data_2 (
id,
name,
created_at
)
select i,
'user_' || i,
make_timestamp(2020, 1, 1, 0, 0, 0) + make_interval(days => i)
from generate_series(1, 100) as s(i);
select * from source_data_2 ; rollback;
┌─────┬──────────┬─────────────────────┐
│ id │ name │ created_at │
├─────┼──────────┼─────────────────────┤
│ 1 │ user_1 │ 2020-01-02 00:00:00 │
│ 2 │ user_2 │ 2020-01-03 00:00:00 │
│ 3 │ user_3 │ 2020-01-04 00:00:00 │
│ 4 │ user_4 │ 2020-01-05 00:00:00 │
│ 5 │ user_5 │ 2020-01-06 00:00:00 │