Convert Teradata to Snowflake

Paste code here or Copy

xxxxxxxxxx
 
--Paste your source SQL here
CREATE MULTISET TABLE EMPLOYEE ,FALLBACK , 
   NO BEFORE JOURNAL, 
   NO AFTER JOURNAL, 
   CHECKSUM = DEFAULT, 
   DEFAULT MERGEBLOCKRATIO,
   BLOCKCOMPRESSION = ALWAYS
   (
      EmployeeNo INTEGER TITLE 'Employee Number' NOT NULL,
      FirstName VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'First Name' COMPRESS ('John',''), 
      LastName VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Last Name' COMPRESS ('Boilerplate_content',''), 
      DOB DATE FORMAT 'YYYY-MM-DD' TITLE 'Date of Birth' COMPRESS , 
      JoinedDate DATE FORMAT 'YYYY-MM-DD' TITLE 'Join Date' COMPRESS , 
      DepartmentNo BYTEINT,
CONSTRAINT FK12 FOREIGN KEY (EmployeeNo) REFERENCES SALARY(EmployeeNo)) 
PRIMARY INDEX UPI_EMPLOYEE(EmployeeNo);
⇜
⇝
​x
 
​

Convert to Snowflake Error? Regenerate

Error?

Paste the error message to interactively regenerate

Regenerate

FAQs

User Privacy & Security

All user interactions are 100% private, secure and encrypted. Customer confidence is critical to everything we do at Roboquery

Does this tool convert Teradata SQL, Tables, Views to equivalent Snowflake Syntax ?

Yes, Roboquery helps you with Teradata to Snowflake code migration by taking the Teradata SQL and converting the code to Snowflake equivalent

Are there limits to how much code I can convert?

Yes. Daily usage quota aplies. Refer to Plans and Pricing

Does this require access to my database ?

No, The Roboquery code conversion utility is fully disconnected and a standalone application. You only share the database structures and we do not need any access to your data