MSC-GP0001

External table translated to regular table

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

This warning is added to clauses related to external handling, this is because in Snowflake the data storage is not a concern and does not need for external tables. Instead, all data should be managed inside the Snowflake data storage. For more information on this subject, you can consult here for snowflake considerations on data storage and here for the translation specs.

Code Example

Input Code:

Create External Table

CREATE TABLE TABLE1 (
CREATE WRITABLE EXTERNAL WEB TABLE TABLE01 (
  COL1 INT
)

Alter External Table

ALTER EXTERNAL TABLE Table1 
ADD COLUMN column1 VARCHAR(20),
DROP COLUMN column2 RESTRICT,
ALTER COLUMN column4 TYPE VARCHAR(10);

Output Code:

Create External Table

/*** MSC-WARNING - MSC-GP0001 - EXTERNAL TABLE TRANSLATED TO REGULAR TABLE ***/ 
CREATE TABLE PUBLIC.TABLE01 (
   COL1 INT
 )

Alter External Table

--** MSC-WARNING - MSC-GP0001 - EXTERNAL TABLE TRANSLATED TO REGULAR TABLE **
ALTER TABLE Table1
ADD COLUMN column1 VARCHAR(20);
ALTER TABLE Table1
DROP COLUMN column2 RESTRICT;
ALTER TABLE Table1
ALTER COLUMN column4 TYPE VARCHAR(10);

Recommendations

• The data stored in files of the external tables in Greenplum must be somehow moved into the Snowflake database.

• If you need more support, you can email us at [email protected]