Currently there is a bug in snowflake with zero-byte (0b) and one-byte (1b) files. This blog gives you the details and how to fix it.

This comparison of Spark pools in Microsoft Synapse and Microsoft Fabric helps you choose the right platform for your compute needs.