-- Create table--> load file into stage --> copy data from stage to table

Example 1:
=========

create or replace table CLASS.public.emp_user (
         EMP_ID   INTEGER ,
         EMP_NAME  string ,
         EMP_SAL  string ,
         EMP_AGE  string ,
         EMP_LOCATION  string 
         );

 put file:///C:\Users\ereddin\Desktop\Snowflake\Class\6_CLI_Stages\Employes\employ1.csv @~;
list @~;

select * from class.public.emp_user;

copy into CLASS.public.emp_user
from @~
file_format = (type = csv field_optionally_enclosed_by='"' skip_header = 1)
pattern = '.*employ1.csv.gz'
on_error = 'skip_file';

select * from class.public.emp_user;

==============
login with another user account and check these files available in user stage or not ?

-- > Files will not be available (one user stage restricted to another user )
-----------------------
rm @~;