SSC-FDM-0004

External table translated to regular table

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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 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.

Code Example

Input Code:

IN -> Greenplum_01.sql

CREATE EXTERNAL TABLE ext_csv_file (
    id INT,
    name TEXT,
    age INT,
    city TEXT
)
LOCATION (
    'gpfdist://192.168.1.100:8080/data/my_data.csv'
)
FORMAT 'CSV' (DELIMITER ',' HEADER);

Output Code:

OUT -> Greenplum_01.sql

--** SSC-FDM-0004 - EXTERNAL TABLE TRANSLATED TO REGULAR TABLE **
CREATE TABLE ext_csv_file (
       id INT,
       name TEXT,
       age INT,
       city TEXT
   )
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "greenplum",  "convertedOn": "07/09/2025",  "domain": "no-domain-provided" }}'
;

Recommendations

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

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