SSC-EWI-BQ0012

Unable to generate correct OBJECT_CONSTRUCT parameter

Severity

High

Description

SnowConvert is not enable to generatedthe correct object construct due to symbol not being loaded correctly.

Code Example

Input Code:

BigQuery

IN -> BigQuery_01.sql

INSERT INTO test.tuple_sample
VALUES
  ((12, 34)),
  ((56, 78)),
  ((9, 99)),
  ((12, 35));

Output Code:

Snowflake

OUT -> BigQuery_01.sql

INSERT INTO test.tuple_sample
!!!RESOLVE EWI!!! /*** SSC-EWI-BQ0012 - UNABLE TO GENERATE CORRECT OBJECT_CONSTRUCT PARAMETER. SYMBOL INFORMATION COULD NOT BE COLLECTED. ***/!!!
VALUES
  ((12, 34)),
  ((56, 78)),
  ((9, 99)),
  ((12, 35));

Recommendations

• If you need more support, you can email us at [email protected]