0

Not able to add ARRAY/STRUCT columns AS IS from Big Query in model

anunagraju 6 months ago 0

I have below SQL in Big Query. I wanted to show in Verabelo for ER diagram, but it's populated in a single line. 

CREATE TABLE `acn-gcp-fsi.POC.RECORD_POC2`
(
ADDRESS STRUCT<CITY STRING NOT NULL, COUNTRY STRUCT<STATE STRING NOT NULL, HOUSE_NUMBER STRING NOT NULL> NOT NULL> NOT NULL
);