fix: rename part of create table

Summary

Rename [on tier("tier_name")] part of create table to [in tier "tier_name"]

---

• Close sbroad#703 (closed)
• Cherry-pick to: none
• Docs follow-up: not necessary