Issues Report

What is an "Issue"?

An issue is a message that provides relevant information about the transformations done by SnowConvert.

Where can I find it?

The issues report can be found in a folder named "Reports", in the output folder of your conversion. The name of the file itself starts with "Issues" so it can easily be located.

The format of the file is .CSV.

What information does it contain?

The issues report contains the following information about all the issues added during the conversion:

Report Example

Given the following Oracle SQL input code, SnowConvert will add the SSC-FDM-OR0035 conversion issue.

Oracle Input

IN -> Oracle_01.sql

CREATE OR REPLACE PROCEDURE schema1.procedure1
AS
BEGIN
  DBMS_OUTPUT.PUT_LINE('hello world');
END;

Snowflake Output

OUT -> Oracle_01.sql

CREATE OR REPLACE PROCEDURE schema1.procedure1 ()
RETURNS VARCHAR
LANGUAGE SQL
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"oracle"}}'
EXECUTE AS CALLER
AS
$$
  BEGIN
    --** SSC-FDM-OR0035 - CHECK UDF IMPLEMENTATION FOR DBMS_OUTPUT.PUT_LINE_UDF. **
    CALL DBMS_OUTPUT.PUT_LINE_UDF('hello world');
  END;
$$;

The row in the issues report for the SSC-FDM-OR0035 conversion issue will have the following information: