Create table as subquery with no data is not supported in Snowflake
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
TABLE02 WITH NO DATA;
CREATE TABLE PUBLIC.TABLE01 AS
-- ** 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.