Skip to content

Instantly share code, notes, and snippets.

@fithisux

fithisux/null_json.sql

Last active January 21, 2026 15:15
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save fithisux/748e4e09f9a98d7969086c753d6028b9 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save fithisux/748e4e09f9a98d7969086c753d6028b9 to your computer and use it in GitHub Desktop.
Download ZIP
Null json
Raw
null_json.sql
%sql
SELECT
*,
to_json(struct(* except (object_id, sample_id))) as xxx
FROM
VALUES ('A1', 2, null, null), ('A2', 3, null, null) tab(object_id, sample_id, feature_1, feature_2)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment