Staging Data Files from a Local File System¶
Execute PUT using the SnowSQL client or Drivers to upload (stage) local data files into an internal stage.
If you want to load a few small local data files into a named internal stage, you can also use Snowsight. Refer to Staging Files Using Snowsight.
Staging the Data Files¶
- User Stage
The following example uploads a file named
data.csv
in the/data
directory on your local machine to your user stage and prefixes the file with a folder namedstaged
.Note that the
@~
character combination identifies a user stage.Linux or macOS
PUT file:///data/data.csv @~/staged;
Windows
PUT file://C:\data\data.csv @~/staged;
- Table Stage
The following example uploads a file named
data.csv
in the/data
directory on your local machine to the stage for a table namedmytable
.Note that the
@%
character combination identifies a table stage.Linux or macOS
PUT file:///data/data.csv @%mytable;
Windows
PUT file://C:\data\data.csv @%mytable;
- Named Stage
The following example uploads a file named
data.csv
in the/data
directory on your local machine to a named internal stage calledmy_stage
. See Choosing an Internal Stage for Local Files for information on named stages.Note that the
@
character by itself identifies a named stage.Linux or macOS
PUT file:///data/data.csv @my_stage;
Windows
PUT file://C:\data\data.csv @my_stage;