The story
First attested in Old French as Camaalot in Chrétien de Troyes' Lancelot, the Knight of the Cart. In the US politics sense a reference to the contemporary musical Camelot (1960), associated with the Kennedy era.
Etymology from Wiktionary, CC BY-SA 4.0.