← Questions
Stable, unique column names across schema snapshots
0
I was asked this
No reports yet. Sign in to say where you were asked it.
You receive successive snapshots of table schemas and must give every column an effective name. Dots in an original name become underscores, and effective names must be unique within a table regardless of letter case; collisions get suffixes _1, _2 and so on. A column that already has an effective name must keep it in later snapshots even as other columns come and go. Implement the renaming across calls and explain how you keep names stable.
No official answer yet. Write yours on the right and run it.
Nothing published yet.
Sign in to submit your code; every attempt is kept here.
Write and test your solution herePython in your browser, the question's tests level by level, every submission kept for you.Sign in to start coding
