most JSON parser would have difficulty decoding an array with 1 million rows. For example in Python you could easily eat up all or RAM and swap and gets OOM'd
https://cloud.google.com/bigquery/docs/loading-data-cloud-st...
So instead of INSERT ... VALUES, you write INSERT ... FORMAT JSONEachRow and stream your data.
https://clickhouse.com/docs/en/sql-reference/statements/inse...