Skip to content

🪢 Open source agent evals & observability: Trace, evaluate, and improve LLM applications with one open platform.

1.5 KB
Raw Blame
import { singleFilterList } from "@langfuse/shared";
import { z } from "zod";

export type DatabaseRow = {
  [key: string]: string | number | Date | Record<string, unknown> | null;
};

const temporalUnit = z.enum(["month", "week", "day", "hour", "minute"]);

const aggregations = z
  .enum([
    "SUM",
    "AVG",
    "COUNT",
    "MAX",
    "MIN",
    "50thPercentile",
    "75thPercentile",
    "90thPercentile",
    "95thPercentile",
    "99thPercentile",
  ])
  .optional();

const groupByInterface = z.array(
  z.discriminatedUnion("type", [
    z.object({
      type: z.literal("datetime"),
      column: z.string(),
      temporalUnit: temporalUnit,
    }),
    z.object({ type: z.literal("number"), column: z.string() }),
    z.object({ type: z.literal("string"), column: z.string() }),
  ]),
);

const orderByInterface = z.array(
  z.object({
    column: z.string(),
    direction: z.enum(["ASC", "DESC"]),
    agg: aggregations,
  }),
);

export const filterInterface = singleFilterList;

export const sqlInterface = z.object({
  from: z.enum([
    "traces",
    "traces_observations",
    "observations",
    "traces_scores",
    "traces_parent_observation_scores",
    "traces_observationsview",
    "traces_metrics",
  ]),
  filter: filterInterface.optional(),
  groupBy: groupByInterface.optional(),
  select: z.array(
    z.object({
      column: z.string(),
      agg: aggregations,
    }),
  ),
  orderBy: orderByInterface.optional(),
  limit: z.number().optional(),
});