Skip to content

feat: [Phase 3] Schema cache (FTS5) + FinOps SQL templates #218

@anandgupta42

Description

@anandgupta42

Phase 3: Schema Cache + FinOps

Parent: #214
Depends on: Phase 2

What

Port the SQLite schema cache (FTS5) and all 10 FinOps SQL template modules from Python to TypeScript.

Sub-tasks

  • native/schema/cache.ts — better-sqlite3 with FTS5, port DDL from Python
  • native/schema/pii-detector.ts — pattern matching + altimateCore.classifyPii()
  • native/schema/tags.ts — Snowflake TAG_REFERENCES queries
  • native/finops/credit-analyzer.ts — SQL templates verbatim from Python
  • native/finops/query-history.ts
  • native/finops/warehouse-advisor.ts
  • native/finops/unused-resources.ts
  • native/finops/role-access.ts
  • Register 16 dispatcher methods (6 schema + 10 finops)
  • Unit tests for SQL template generation per warehouse type
  • Schema cache search/index integration tests

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions