"I want to access my own files underneath the table."

Why? Explain this to me. This is 100% unnecessary, (and may even introduce a possible attack vector for malicious actors.) Snowflake doesn't force you to access your data at the physical file level. Your access is through the logical relational model, using the ultimate OPEN standard, ANSI-standard SQL. Don't care for SQL? Stay in Python and use a Dataframe API with Snowpark!

You want your data as Parquet files in an S3 bucket?

COPY INTO @myS3bucket FROM myTable partition by (expression) format=(Parquet); -- done. "Vendor lock in" is FUD created by a marketing department.

Snowflake manages all the physical aspects of secure data storage - partitioning, clustering, encryption, compression, vacuuming, time-travel - so YOU DON'T HAVE TO! Your data is also 3x-redundant across all three AZ's in a region, FOR FREE.

Need to replicate your data into Azure or GCP, and have silent client failover in case of disaster? Takes about 4 mouse clicks to set this up in Snowflake.

Want access to a public Data Marketplace, or setup secure 1:1 data sharing with ecosystem partners and have instant access to live real-time relational database tables - without creating additional copies of data or providing access from outside the security boundary? Welcome to The Data Cloud.