Introducing Flights: agent-native data pipelines in MotherDuckJoin the livestream

Skip to main content

JSON

JSON is a common format for semi-structured data. DuckDB can read JSON files and load the results into MotherDuck for SQL analytics.

How it works with MotherDuck​

  1. Connect to MotherDuck from a DuckDB client.
  2. Use read_json for JSON files, newline-delimited JSON, or JSON arrays.
  3. Create a MotherDuck table once you have the schema and options you want.

Example​

CREATE TABLE my_table AS
SELECT *
FROM read_json('events.json');

Related content​