Pipelinepipeline · returns table

SAMPLE

Take a random sample of rows

Table-in, table-out — composes downstream of SELECTs.

pipelinellmpipeline-composabletext

Syntax

THEN SAMPLE

THEN SAMPLE {{ n }}

THEN SAMPLE({{ n }})

Arguments

name	type	description
n(optional)	VARCHAR	—
_table	TABLE	—

About

PIPELINE cascade for random sampling. Uses pure Python/pandas - no LLM calls. Usage: SELECT * FROM big_table THEN SAMPLE -- default 10 rows SELECT * FROM big_table THEN SAMPLE(100) -- 100 rows SELECT * FROM big_table THEN SAMPLE('0.1') -- 10% of rows

Examples

Returns the requested sample size

SELECT
  *
FROM
  (
    VALUES
      (1),
      (2),
      (3),
      (4)
  ) AS t (x) THEN SAMPLE (2) THEN PYTHON ('result = pd.DataFrame({"row_count":[len(df)]})')

Nearby rabbit holes

same domain

pipeline

ADD_STYLES

Apply theme styling to a chart specification

pipelinellmpipeline-composabletext

pipeline

ANALYZE

Analyze query results with LLM based on a prompt

pipelinellmpipeline-composabletext

pipeline

DEDUPE

Remove duplicate rows

pipelinellmpipeline-composabletext

pipeline

ENRICH

Add LLM-computed columns to query results

pipelinellmpipeline-composabletext

pipeline

FILTER

Filter query results using LLM-based semantic matching

pipelinellmpipeline-composabletext

pipeline

GROUP

Group by column and aggregate another

pipelinellmpipeline-composabletext

Climb back to The Looking Glass

surface↓pipeline↓sample

Pipelinepipeline · returns table

SAMPLE

Take a random sample of rows

Table-in, table-out — composes downstream of SELECTs.

pipelinellmpipeline-composabletext

Syntax

THEN SAMPLE

THEN SAMPLE {{ n }}

THEN SAMPLE({{ n }})

Arguments

name	type	description
n(optional)	VARCHAR	—
_table	TABLE	—

About

Examples

Returns the requested sample size

SELECT
  *
FROM
  (
    VALUES
      (1),
      (2),
      (3),
      (4)
  ) AS t (x) THEN SAMPLE (2) THEN PYTHON ('result = pd.DataFrame({"row_count":[len(df)]})')