or run

npx @tessl/cli init
Log in

Version

Tile

Overview

Evals

Files

docs

authorization.mdcharts.mdcompiler.mdconditional-formatting.mddashboards.mddbt.mdee-features.mdexplore-fields.mdfilters.mdformatting.mdindex.mdmetric-queries.mdparameters.mdpivot.mdprojects-spaces.mdsql-runner.mdtemplating.mdtypes.mdutilities.mdvisualizations.mdwarehouse.md
tile.json

sql-runner.mddocs/

SQL Runner

Custom SQL query execution with full visualization support.

Types

interface SqlRunnerQuery {
  dimensions: Pick<SqlRunnerField, 'name'>[];
  timeDimensions: Pick<SqlRunnerTimeDimension, 'name' | 'granularity'>[];
  metrics: Pick<SqlRunnerField, 'name'>[];
  sortBy: SqlRunnerSortBy[];
  limit?: number;
  pivot?: SqlRunnerPivot;
  filters: SqlRunnerFilter[];
  sql?: string;
}

enum SqlRunnerFieldType {
  TIME = 'time',
  NUMBER = 'number',
  STRING = 'string',
  BOOLEAN = 'boolean'
}

interface SqlChart {
  savedSqlUuid: string;
  name: string;
  sql: string;
  config: VizBaseConfig & (VizCartesianChartConfig | VizPieChartConfig | VizTableConfig);
  chartKind: ChartKind;
}

Constants

const MAX_SAFE_INTEGER: number;  // 2_147_483_647 for "all results" queries