STAGE FILE

Stage files are used primarily to maintain packages (e.g. JAR files) for Snowpark functions.

You may put any directories or files in /<database>/<schema>/stage/<stage_name>/*

SnowDDL will synchronise files with internal stage automatically.

Example: GitHub link (test_internal_stage).

Usage notes

  1. Pre-compiled JAR files for popular libraries can be downloaded directly from MVN repository.

  2. Directory structure is maintained.

  3. It is recommended to have multiple small files VS. one large file. Each file is uploaded individually in a separate thread.

  4. For each stage file SnowDDL puts an additional empty technical file. It is used to compare current version of file on disk with remote version of file. Technical file is named <original_name>.<md5_hash>.md5. Unfortunately, it is not possible to use md5 provided by Snowflake LIST command, since files in internal stages are encrypted automatically, while local files are not encrypted.

Last updated