FUNCTION OPTIONS OR DATA ACCESS

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Some parts in the output code are omitted for clarity reasons.

Non-relevant statement.

Notice that this statement is removed from the migration because it is a non-relevant syntax. It means that it is not required in Snowflake.

Description

Functions options or data access options are statements used in functions on the declaration part to specify certain characteristics. These can be:

• CONTAINS SQL

• SQL SECURITY DEFINER

• COLLATION INVOKER

• SPECIFIC FUNCTION_NAME

Sample Source Patterns

Function Options

Notice that in this example the function options have been removed because they are not required in Snowflake.

Teradata

IN -> Teradata_01.sql

CREATE FUNCTION sumValues(A INTEGER, B INTEGER)
   RETURNS INTEGER
   LANGUAGE SQL
   CONTAINS SQL
   SQL SECURITY DEFINER
   SPECIFIC sumTwoValues
   COLLATION INVOKER
   INLINE TYPE 1
   RETURN A + B;

Snowflake

OUT -> Teradata_01.sql

CREATE OR REPLACE FUNCTION sumValues (A INTEGER, B INTEGER)
   RETURNS INTEGER
   LANGUAGE SQL
   COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"teradata"}}'
   AS
   $$
      A + B
   $$;

Known Issues

No issues were found.

Related EWIs

No related EWIs.