Creating date partitioned external tables in snowflake

Question

I am able to create external table on Azure blob storage in snowflake. But, when I try the partition it on a date column, it throws an error SQL execution internal error: Processing aborted due to error 300002:3633262218; incident 2144018.

This is my code

 create or replace external table exttable_part(
 record_captured_at date as to_date(substr(metadata$filename, 150,4) || '-' || right('0' || to_char(substr(metadata$filename, 157,2)),2) || '-' || right('0'||to_char(substr(metadata$filename, 162,2)),2) , 'yyyy-mm-dd')
 )
 partition by (record_captured_at)   ### the error goes when I remove this line
 location= @external_stage
 file_format = (type = json)
 ;

This is external table output without the partition by code

Does anybody know the reason for this error???

I think this is something you should raise with Snowflake support due to it being an incident. Probably can't be solved by anyone in the community as it appears to be an internal error, from what I can see everything you are doing appears right. — Simon D

Anshul Thakur Anshul Thakur · Accepted Answer · 2020-04-15T01:58:09

Please open a case with Support to look into this incident if not done already. Please check that the below doc has been followed for creating partitions on External Tables; https://docs.snowflake.com/en/user-guide/tables-external-intro.html#partitioned-external-tables

Creating date partitioned external tables in snowflake

1 Answers