Revert "NO-SNOW Enable single buffering in Snowpipe Streaming by default (#924)"

[sfc-gh-mbobowski]

This reverts commit f0e5f230ff710e809671f5f0a27b23302c8cb3ba.

Overview

We decided to not enable this setting by default in 2.5.0 release because we are not sure what is the impact on the first read performance.

Pre-review checklist

• [ ] This change should be part of a Behavior Change Release. See go/behavior-change.
• [ ] This change has passed Merge gate tests
• [ ] Snowpipe Changes
• [ ] Snowpipe Streaming Changes
• [ ] This change is TEST-ONLY
• [ ] This change is README/Javadocs only
• [ ] This change is protected by a config parameter eg snowflake.ingestion.method.
  • [ ] Yes - Added end to end and Unit Tests.
  • [ ] No - Suggest why it is not param protected
• [ ] Is his change protected by parameter on the server side?
  • [ ] The parameter/feature is not yet active in production (partial rollout or PrPr, see Changes for Unreleased Features and Fixes).
  • [ ] If there is an issue, it can be safely mitigated by turning the parameter off. This is also verified by a test (See go/ppp).