COPY/STAGE UI/UX Improvement

[Xuanwo]

This issue is used to track the ui/u improvement of COPY and STAGE.

We expect users to use COPY and STAGE as happily as possible.

Most issues listed are just ideas, please leaving comments under specific issue to request more information

User Experience

• Support other stage storage types #6103
  • Also address Support copy from azblob #4739
  • Depends on Migrate COPY INTO statement to new planner #5781
• Add endpoint_url so we can copy from external s3 services #6104
  • Should take serectry issue into consideration, for example, don't allow load from HTTP by default.
• Check if protocol is supported during parsing #6105
• COPY INTO size_limit=10 is not correct in parallel #6091

Developer Experience

• Strong typed credentials and encryption based on protocol #6106
• Refactor CREATE STAGE with the new common-storage parse_uri_location #6580
• Implement unit tests for stage and copy #6107
• Refactor stateful tests #6003
• performance: Improve COPY INTO speed #6020
• COPY INTO ontime OOM in an 1Gi memory limit #6092
• bug: Failed to upload file with spaces #6139

[Xuanwo]

Most work addressed, let's close.