Azure Data Factory | Google Big Query | API Limit Execeeded

Question

My requirement is to extract hug volume of daily data(~35GB i.e. ~3million parent rows) from Google Big Query using ADF so I am dividing it into chunk load(~127k records per pipeline run) but I am getting below error message while extracting rows more than 625 count.

I am using below query under Source in Copy Data activity, [Note : I am using below customized logic to convert result set into JSON format to create JSON file]

WITH TestResult AS(
SELECT A.*
FROM
(
SELECT RANK() OVER (ORDER BY {Column X} ASC) AS rownum, *
FROM {Schema}.{Table}
WHERE {Column Y} = '2022-10-27'
) AS A
WHERE A.rownum >= 1
AND A.rownum <= 625
ORDER BY rownum)
SELECT CONCAT ("[", JSON_PATH, "]") FROM (
SELECT STRING_AGG (TO_JSON_STRING(t, true)) AS JSON_PATH
FROM TestResult AS t);

My latest observation on this, since I am converting all rows into a single row which may be causing issue of exceeding row data limit size.