Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

When the above wrapper function is applied, the data is imported normally and validated and published as expected.

Running job on an empty Snowflake dataset fails

If you run a job on an 0-row dataset that is sourced from Snowflake, the job execution fails.

Solution:

The solution is to union the empty dataset row with an empty row. Example:

Code Block
SELECT col1, col2 FROM empty_table
UNION ALL
SELECT '' AS col1, '' AS col2 FROM empty_table;

The insert row values prevent the job from failing.

...