MSCEWI1099
Create table as subquery with no data is not supported in Snowflake
Low
Snowflake does not support the CTAS option without data, the same output is obtained by adding the Limit 0 clause at the end of the Select Query
CREATE TABLE TABLE01 AS
SELECT
*
FROM
TABLE02 WITH NO DATA;
CREATE TABLE PUBLIC.TABLE01 AS
SELECT
*
FROM
PUBLIC.TABLE02
LIMIT 0
-- ** MSC-WARNING - MSCEWI1099 - CREATE TABLE AS SUBQUERY WITH NO DATA IS NOT SUPPORTED IN SNOWFLAKE, TRANSLATED TO LIMIT 0 **
-- WITH NO DATA
- No end-user action is required.
- For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.
Last modified 2mo ago