dbt-labs/dbt-core · error

column_without_nulls

Error message

column_without_nulls

What it means

Unimplemented agate Table method: column_without_nulls should return a single-column table with null values removed, but the body is a todo!() stub (it already extracts the single column via single_column_table). Any Jinja/Python-parity code calling table.column_without_nulls() aborts here.

Solutions

1. Filter the flat column data to drop null entries, preserving order, and rebuild a TableRepr
2. Mirror Python agate's column_without_nulls semantics exactly
3. Until implemented, return a clear unsupported error instead of panicking

When it happens

Trigger: Thrown at crates/dbt-agate/src/table.rs:230 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of dbt-labs/dbt-core@0267ce9170 (2026-09-07). Data as JSON: /api/errors/17eb8597c2dc18cf. Report an issue: GitHub.

Appendix: source

Thrown at crates/dbt-agate/src/table.rs:230

    }

    pub fn single_column_table(&self, idx: isize) -> Option<Arc<TableRepr>> {
        let idx = self.adjusted_column_index(idx)?;
        let flat_with_single_column = self.flat.with_single_column(idx);
        let row_names = self.row_names.as_ref().map(Arc::clone);
        let repr = TableRepr::new(flat_with_single_column, None, row_names);
        Some(Arc::new(repr))
    }

    /// Return a single-column table with the distinct values in this column.
    pub fn column_distinct(&self, col_idx: isize) -> Arc<Self> {
        let _col = self.single_column_table(col_idx).unwrap();
        todo!("column_distinct")
    }

    pub fn column_without_nulls(&self, col_idx: isize) -> Arc<Self> {
        let _col = self.single_column_table(col_idx).unwrap();
        todo!("column_without_nulls")
    }

    pub fn column_sorted(&self, col_idx: isize) -> Arc<Self> {
        let _col = self.single_column_table(col_idx).unwrap();
        todo!("column_sorted")
    }

    pub fn column_without_nulls_sorted(&self, col_idx: isize) -> Arc<Self> {
        let _col = self.single_column_table(col_idx).unwrap();
        todo!("column_without_nulls_sorted")
    }

    pub fn count_occurrences_of_value_in_column(&self, _needle: &Value, col_idx: isize) -> usize {
        let _col = self.single_column_table(col_idx).unwrap();
        todo!("count_occurrences_of_value_in_column")
    }

    pub fn index_of_value_in_column(&self, _needle: &Value, col_idx: isize) -> Option<usize> {

View on GitHub (pinned to 0267ce9170)