Unknown

Description

Identifies a not-yet-resolved type, e.g., of an undecorated string literal.

Click here to navigate to the Postgre docs page for this type.

The cast to an unknown data type is not necessary on snowflake

Grammar Syntax

NULL :: unknown AS type,

Sample Source Patterns

Postgre

input

SELECT
  NULL :: unknown
FROM
  table1;

Snowflake

output

SELECT
  NULL
FROM
  table1;