SSC-FDM-PG0005
UNLOGGED Table is not supported in Snowflake; data written may have different performance.
Description
PostgreSQL's UNLOGGED
tables offer a significant speed advantage by skipping write-ahead logging (WAL). However, their data isn't replicated to mirror instances. Snowflake doesn't support this functionality, so the UNLOGGED
clause will be commented out.
Code Example
Input Code:
CREATE UNLOGGED TABLE TABLE1 (
COL1 integer
);
Output Code:
CREATE
-- --** SSC-FDM-PG0005 - UNLOGGED TABLE IS NOT SUPPORTED IN SNOWFLAKE, DATA WRITTEN MAY HAVE DIFFERENT PERFORMANCE. **
-- UNLOGGED
TABLE TABLE1 (
COL1 integer
)
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": { "major": 0, "minor": 0, "patch": "0" }, "attributes": { "component": "greenplum", "convertedOn": "04/21/2025", "domain": "test" }}';
Recommendations
If you need more support, you can email us at [email protected]
Last updated