Schema

Translation reference to convert Teradata Create Schema to Snowflake Create Schema

Description

The translation of the CREATE SCHEMA statement from Teradata to Snowflake is simple, as the basic syntax remains the same.

Sample Source Patterns

Teradata

Join Index

IN -> Teradata_01.sql

CREATE SCHEMA IF EXISTS schema_name;

Snowflake

Dynamic Table

OUT -> Teradata_01.sql

CREATE SCHEMA IF EXISTS schema_name
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "teradata",  "convertedOn": "07/23/2024" }}'
;

Known Issues

WITH Properties of CREATE SCHEMA

The WITH properties associated with the CREATE SCHEMA statement in Teradata are not supported in Snowflake, as there is no equivalent functionality available.

Teradata

Join Index

IN -> Teradata_01.sql

CREATE SCHEMA IF EXISTS schema_name
WITH ( PROPERTY1 = PROPERTYNAME, PROPERTY2 = PROPERTTYNAME, PROPERTY3 = PROPERTTYNAME);

Snowflake

Dynamic Table

OUT -> Teradata_01.sql

CREATE SCHEMA IF EXISTS schema_name
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "teradata",  "convertedOn": "07/23/2024" }}'
!!!RESOLVE EWI!!! /*** SSC-EWI-0073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'SCHEMA WITH' NODE ***/!!!
WITH ( PROPERTY1 = PROPERTYNAME, PROPERTY2 = PROPERTTYNAME, PROPERTY3 = PROPERTTYNAME);

Related EWIs

1. SSC-EWI-0073: Pending Functional Equivalence Review.