CODEWITHSUNDEEP
teradatasnowflake-cloud-data-platform
Ankit Srivastava
Ankit Srivastava

Reputation: 195

Table Types in Snowflake vs Teradata

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

Upvotes: 1

Views: 654

Answers (1)

NickW
NickW

Reputation: 9798

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

Upvotes: 0

Related Questions