Since approximately 18. 8. 2025 22:00 we're seeing sporadic errors of Snowflake transformation ending with Internal error. These issues appear to be linked to a recent underlying change in the Snowflake database, specifically affecting queries that use CREATE VIEW statements with computed columns. The error may occur across any stack.
If your transformation is using a query similar to this:
CREATE OR REPLACE VIEW TEST_W AS SELECT concat("id", 'TEST','TEST') AS id FROM TEST;
and fails with an Internal error, the following workarounds may resolve the issue:
Use a table instead of a view:
CREATE OR REPLACE TABLE TEST_T AS SELECT concat("id", 'TEST','TEST') AS id FROM TEST;
Explicitly cast the computed column to a valid VARCHAR length:
CREATE OR REPLACE VIEW TEST_W AS SELECT concat("id", 'TEST','TEST')::VARCHAR(16777216) AS id FROM TEST;
Additional Notes:
Transformations already using CREATE (OR REPLACE) TABLE statements are not affected.
Transformations that do not use computed columns, or that cast computed columns explicitly, are also unaffected.
If you're uncertain whether your transformation is affected (we fully acknowledge that the error message is not informative), please don’t hesitate to reach out to our Support team. They’ll help confirm whether this issue applies to your case.
We’re actively collaborating with Snowflake to resolve the problem. In parallel, we’re investigating potential fixes on our platform to mitigate the impact.
We sincerely apologize for the inconvenience and appreciate your patience. Next update will be provided in 4 hours.