How to auto-increment in posgresql?

Question

i have a star schema datawarehouse i did the load with python and i set the id of the employee = id in the database , ron has id number = 99 , Tom =201 ,Alice =87 but in the database i found the id where set by default . should i add another column id_employee or should i change the id into the real id also i want the fact_table to have the real id

the code i used to load the database :

for row in pandasSource:
    row["id"]=row["id_employee"]
    dimemployee.ensure(row)
connection.commit()
connection.close
pgconn.close()

I don't understand. How is the table defined, and with what SQL statements did you add the rows? — Laurenz Albe, Mar 21 '22 at 09:55
this is dimension employee , i did the load using python and psycopg2 including the mapping , `id` is the primary key , in the python code that i have the id is different of what i get in database — Smordy, Mar 21 '22 at 10:15
I asked for the table definition and the SQL statement that inserted the rows. — Laurenz Albe, Mar 21 '22 at 10:41

score 0 · Answer 1 · answered Mar 21 '22 at 10:30

0

Dimensions should have auto-incremented surrogate keys as their primary keys. PKs from source tables should be held as columns in your dimensions

answered Mar 21 '22 at 10:30

NickW

8,430
2
6
19

so its like an artificial key ? – Smordy Mar 21 '22 at 10:32
yes, that’s correct – NickW Mar 21 '22 at 10:38
i see but i want the real id linked with the fact table and it fills automatically like auto-increment – Smordy Mar 21 '22 at 11:32
You put SKs in a fact table, not the keys from a source system – NickW Mar 21 '22 at 12:19

How to auto-increment in posgresql?

1 Answers1