PG to BQ, CDC messes up format of JSONB columns, whereas initial load doesn't

[saisrirampur]

Setup steps in Postgres for JSONB

CREATE TABLE test_jsonb(id serial primary key, j jsonb);
INSERT INTO test_jsonb(j) VALUES ('{"isDemo":false}');
--Kick off mirror now and after initial load insert another row on Postgres
INSERT INTO test_jsonb(j) VALUES ('{"isDemo":false}');

Data in BQ for JSONB

Setup steps in Postgres for ARRAY

CREATE TABLE test_array(id serial primary key, t text[], i int[]);
INSERT INTO  test_array(t,i) VALUES ('{sai,krishna}'::text[],'{1,2}'::int[]);
--Kick off mirror now and after initial load insert another row on Postgres
INSERT INTO  test_array(t,i) VALUES ('{sai,krishna}'::text[],'{1,2}'::int[]);

Data in BQ for JSONB

[Amogh-Bharadwaj]

Fixed by #830

[iskakaushik]

re-opening this as @heavycrystal mentioned that this is still an issue for SF.