col_montium

·

A

Solved

JSON Transform Schema makes query fail

https://duckdb.org/docs/stable/data/json/json_functions.html#json-scalar-functions

Plain Text

CREATE TABLE example (j JSON);
INSERT INTO example VALUES
    ('{ "family": "anatidae", "species": [ "duck", "goose", "swan", null ] }');

This example straight from the docs fails with

Plain Text

ValueError
This cell raised an exception: ValueError('Invalid format specifier ' "anatidae", "species": [ "duck", "goose", "swan", null ] ' for object of type 'str'')

See the console area for a traceback.

2 comments

A

c

Get help from the marimo community

JSON Transform Schema makes query fail