Skip to content

GS: Google OAuth, Picker, and snapshot export #399

Description

@BorisTyshkevich

Parent: #398

Design:

  • docs/design/google-sheets/authentication.md
  • docs/design/google-sheets/snapshot-export.md
  • docs/design/google-sheets/large-results.md

Scope

Add deployment-gated Google Identity Services authentication, Google Picker create/select flow, and one-time snapshot export using the canonical streaming/type-conversion pipeline.

Acceptance criteria

  • Google actions are absent when configuration is missing.
  • Tokens remain in browser memory and never enter URLs, logs, persistence, or exports.
  • New and existing spreadsheets can be selected with edit-permission validation.
  • Snapshot export creates no binding, refresh link, checkpoint, or history row.
  • Values use RAW input semantics and precision-safe ClickHouse type mapping.
  • Upload uses explicit byte-bounded ranges with progress, cancellation, quota backoff, and no silent truncation.
  • OAuth popup/account/permission failures are actionable and non-destructive.
  • Unit, fake-Google, browser, and scale tests cover the flow.

Non-goals

Linked refresh, server binding storage, scheduling, Apps Script, service accounts, and Google Docs.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions