Table Types in Snowflake vs Teradata

Question

I was trying to look at the alternative's to different table types in Teradata compared to SnowFlake.

From Snowflake documentation,

VOLATILE TABLE alternative are TEMPORARY TABLE GLOBAL TEMPORARY TABLE alternative are TRANSIENT TABLE

But in Snowflake, I am able to create both Volatile Table and Global Temp Tables. Not sure how it is allowing or if these also exists. If yes then what are the differences

Answer 1

Snowflake only has permanent (the default), temporary and transient table types.

However, Snowflake has implemented a number of synonyms for temporary in order to make migration for other DBMSs: CREATE TABLE optional parameters