I noticed when I was creating a long struct today that the type arguments are automatically wrapped, but do not have some form of indentation to make it clear that they are a nested field. Example below.
Language: BigQuery
Input text:
CREATE TEMP TABLE blah
(
date DATE NOT NULL,
nested STRUCT<hey STRING, there STRING, friend STRING, how STRING, are STRING, you STRING, this STRING, iss STRING, getting STRING, long STRING>
) AS
(
SELECT
bleep
FROM bloop
);
Expected output:
CREATE TEMP TABLE blah (
date DATE NOT NULL,
nested STRUCT<
hey STRING,
there STRING,
friend STRING,
how STRING,
are STRING,
you STRING,
this STRING,
iss STRING,
getting STRING,
long STRING
>
) AS
(
SELECT
bleep
FROM bloop
);
Actual output:
CREATE TEMP TABLE blah (
date DATE NOT NULL,
nested STRUCT<hey STRING,
there STRING,
friend STRING,
how STRING,
are STRING,
you STRING,
this STRING,
iss STRING,
getting STRING,
long STRING>
) AS
(
SELECT
bleep
FROM bloop
);
I noticed when I was creating a long struct today that the type arguments are automatically wrapped, but do not have some form of indentation to make it clear that they are a nested field. Example below.
Language: BigQuery
Input text:
Expected output:
Actual output: