I'd like for you to consider hybrid tables as a potential solution. They are designed for higher concurrent DML workloads than standard tables, potentially resolving queuing or abortion issues.
Important Considerations:
Higher Cost: Hybrid tables are generally more expensive.
Best For: High-concurrency DML, low-latency ingestion where standard table limits are a bottleneck.
Refer to official Snowflake documentation for detailed information on hybrid tables.