Design a cloud analytics database system (like ClickHouse Cloud)

Design a cloud-based analytics database system from first principles, similar to ClickHouse Cloud. The design should cover key architectural concerns including coordination, metadata storage, storage format, and provisioning. A common sub-question involves designing a distributed monotonically-increasing sequence number generator as a component of the system.