title: What is the best approach in Snowflake for delete operations on a really large table?
body: <p>We're thinking of moving our ODS from S3 into Snowflake but have some concerns on performance.  Deleting 39 million rows from a 1.5 Billion (this would be on the smaller side) row table took 15 minutes on an x-small warehouse, 8 on a small, and 5 on a medium.  We could throw money at larger instances, but really don't want to do that until all other measures were explored.</p>
  
  <p>We were also thinking about implementing a manual partition system, to chunk up the table, but there would be a dev cost to create the supporting functionality.</p>
  
  <p>Does Snowflake have a partitioning system that I'm not aware about that's equivalent to SQL Server?  I know that's a reach, but swapping partitions was great.</p>
  
  <p>Thanks for any feedback!  </p>