SSC-FDM-TS0007

FOR REPLICATION clause does not exist in Snowflake.

Description

This message is shown when SnowConvert finds a procedure with a FOR REPLICATION clause. This is not supported in Snowflake, so it is removed.

This clause specifies that the procedure is created for replication. Consequently, it can't be executed on the Subscriber.

For more details see the documentation about the clause functionality.

Code Example

Input Code:

IN -> SqlServer_01.sql

CREATE PROCEDURE SelectAllCustomers
WITH FOR REPLICATION
AS
BEGIN
      SELECT * FROM Customers;
END;

Output Code:

OUT -> SqlServer_01.sql

--** SSC-FDM-0007 - MISSING DEPENDENT OBJECT "Customers" **
CREATE OR REPLACE PROCEDURE SelectAllCustomers ()
RETURNS TABLE()
LANGUAGE SQL
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"transact"}}'
EXECUTE AS CALLER
--** SSC-FDM-TS0007 - FOR REPLICATION CLAUSE DOES NOT EXIST IN SNOWFLAKE **
AS
$$
      DECLARE
            ProcedureResultSet RESULTSET;
      BEGIN
            ProcedureResultSet := (
            SELECT
                  *
            FROM
                  Customers);
            RETURN TABLE(ProcedureResultSet);
      END;
$$;

Recommendations

• No additional user actions are required.

• If you need more support, you can email us at [e-mail]