Table Space / user Stage

 1. Table Space : 

• Snowflake provides table stage to every table by default. 
• The files / Objects in this area weil not be accessible outside of this table. Including System admin.
• There is no storage limit on this. 
• Each table has a Snowflake stage allocated to it for storing files. These can't be altered or dropped.
• The stages can be accessed by multiple users but can only load data into the table it is allocated to. Table stages are not suitable if the data needs to be loaded into multiple tables

list  @%<Table Name> ;

remove any file from table stage :

remove @%<Table Name>/<file Name>;

2. User Space : 

• Snowflake provides user stage to every user by default. 
• But it is intended for the specific user. The files / Objects in this area will not be accessible to others. Including System admin.
• There is no storage limit on this. 
• All your work sheets will be in this area.
• Each user has a snowflake stage allocated to them by default for storing files and these can't be altered or dropped.

    Upload file into user stage : 
    put file://<source_path>//<Source file Name>  @~; 
    List all files that are in user space :
    list @~;