PracHub
QuestionsPremiumLearningGuidesCheatsheetNEWCoaches
|Home/System Design/Airtable

Design a scalable search service with sharding

Last updated: May 15, 2026

Quick Overview

This question evaluates understanding of search system architecture, including indexing, querying, and sharding strategies, and measures competency in designing scalable, low-latency data pipelines; it falls under system design and distributed systems and emphasizes practical application-level architecture rather than purely conceptual theory.

  • medium
  • Airtable
  • System Design
  • Software Engineer

Design a scalable search service with sharding

Company: Airtable

Role: Software Engineer

Category: System Design

Difficulty: medium

Interview Round: Onsite

## Technical Design: Search + Sharding Trade-offs Design a search service that lets users query documents/products with keywords. ### Functional requirements - `GET /search?q=...` returns top results ranked by relevance. - Support basic filtering (e.g., category, language, tenant/app id). - P95 latency target (e.g., < 200 ms) and ability to scale to large corpora. ### Non-functional requirements - Data size grows to billions of docs. - Frequent reads, continuous ingestion/updates. - High availability. ### Prompt 1. Describe how you would implement the core search algorithm at a high level (indexing + querying). 2. Propose a **sharding strategy** for the index. 3. Discuss trade-offs: latency, cost, rebalancing, hot keys, consistency, and operational complexity. No need to write production code, but be concrete about components and data flows.

Quick Answer: This question evaluates understanding of search system architecture, including indexing, querying, and sharding strategies, and measures competency in designing scalable, low-latency data pipelines; it falls under system design and distributed systems and emphasizes practical application-level architecture rather than purely conceptual theory.

Related Interview Questions

  • Design an async API with idempotency - Airtable (medium)
  • Design JSON serialization for circular references - Airtable (hard)
  • Design a lazy-initialized connection pool - Airtable (medium)
  • Design a lazy ConnectionPool - Airtable (medium)
Airtable logo
Airtable
Jan 22, 2026, 12:00 AM
Software Engineer
Onsite
System Design
8
0
Loading...

Technical Design: Search + Sharding Trade-offs

Design a search service that lets users query documents/products with keywords.

Functional requirements

  • GET /search?q=... returns top results ranked by relevance.
  • Support basic filtering (e.g., category, language, tenant/app id).
  • P95 latency target (e.g., < 200 ms) and ability to scale to large corpora.

Non-functional requirements

  • Data size grows to billions of docs.
  • Frequent reads, continuous ingestion/updates.
  • High availability.

Prompt

  1. Describe how you would implement the core search algorithm at a high level (indexing + querying).
  2. Propose a sharding strategy for the index.
  3. Discuss trade-offs: latency, cost, rebalancing, hot keys, consistency, and operational complexity.

No need to write production code, but be concrete about components and data flows.

Solution

Show

Comments (0)

Sign in to leave a comment

Loading comments...

Browse More Questions

More System Design•More Airtable•More Software Engineer•Airtable Software Engineer•Airtable System Design•Software Engineer System Design
PracHub

Master your tech interviews with 7,500+ real questions from top companies.

Product

  • Questions
  • Learning Tracks
  • Interview Guides
  • Resources
  • Premium
  • For Universities
  • Student Access

Browse

  • By Company
  • By Role
  • By Category
  • Topic Hubs
  • SQL Questions
  • Compare Platforms
  • Discord Community

Support

  • support@prachub.com
  • (916) 541-4762

Legal

  • Privacy Policy
  • Terms of Service
  • About Us

© 2026 PracHub. All rights reserved.