CODEWITHSUNDEEP
snowflake-cloud-data-platform
Kumar
Kumar

Reputation: 21

How to check storage path for a Snowflake Table

We know show create table in hive gives storage path. Checking how to find a storage path for a snowflake table. I don’t see show create or desc table giving a storage path for a table.

Upvotes: 1

Views: 342

Answers (1)

Lukasz Szozda
Lukasz Szozda

Reputation: 176114

One of the main advantages of Snowflake Data Platform is automatic storage handling:

Key Concepts & Architecture

Database Storage

When data is loaded into Snowflake, Snowflake reorganizes that data into its internal optimized, compressed, columnar format. Snowflake stores this optimized data in cloud storage.

Snowflake manages all aspects of how this data is stored — the organization, file size, structure, compression, metadata, statistics, and other aspects of data storage are handled by Snowflake. The data objects stored by Snowflake are not directly visible nor accessible by customers; they are only accessible through SQL query operations run using Snowflake

Upvotes: 1

Related Questions