Staging data files from a local file system¶

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 named staged.

Note that the @~ character combination identifies a user stage.

• Linux or macOS

  PUT file:///data/data.csv @~/staged;
  

  Copy

• Windows

  PUT file://C:\data\data.csv @~/staged;
  

  Copy

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 named mytable.

Note that the @% character combination identifies a table stage.

• Linux or macOS

  PUT file:///data/data.csv @%mytable;
  

  Copy

• Windows

  PUT file://C:\data\data.csv @%mytable;
  

  Copy

Named Stage

The following example uploads a file named data.csv in the /data directory on your local machine to a named internal stage called my_stage. See Choosing an internal stage for local files for information on named stages.

In SQL, note that the @ character by itself identifies a named stage.

• Linux or macOS

  SQLPython

  PUT file:///data/data.csv @my_stage;
  

  Copy

• Windows

  SQLPython

  PUT file://C:\data\data.csv @my_stage;
  

  Copy

Listing staged data files¶

To see files that have been uploaded to a Snowflake stage, use the LIST command:

User stage:

LIST @~;

Table stage:

LIST @%mytable;

Named stage:

LIST @my_stage;

stage_files = root.databases["<database>"].schemas["<schema>"].stages["my_stage"].list_files()
for stage_file in stage_files:
  print(stage_file)

Next: Copying data from an internal stage