File functions¶
File functions enable you to access files staged in cloud storage.
List of functions¶
| Function Name | Notes |
|---|---|
| Stages | |
| GET_STAGE_LOCATION | Returns the URL for an external or internal named stage using the stage name as the input. |
| GET_RELATIVE_PATH | Extracts the path of a staged file relative to its location in the stage using the stage name and absolute file path in cloud storage as inputs. |
| GET_ABSOLUTE_PATH | Returns the absolute path of a staged file using the stage name and path of the file relative to its location in the stage as inputs. |
| GET_PRESIGNED_URL | Generates the pre-signed URL to a staged file using the stage name and relative file path as inputs. Access files in an external stage using the function. |
| BUILD_SCOPED_FILE_URL | Generates a scoped Snowflake file URL to a staged file using the stage name and relative file path as inputs. |
| BUILD_STAGE_FILE_URL | Generates a Snowflake file URL to a staged file using the stage name and relative file path as inputs. |
| AI Functions | |
| AI_COMPLETE | Generates a response (completion) from text or an image using a supported language model. |
| AI_PARSE_DOCUMENT | Returns the extracted content from a document on a Snowflake stage as a JSON-formatted string. |
| AI_TRANSCRIBE | Transcribes text from an audio file with optional timestamps and speaker labels. |
The following functions are for use with the FILE data type. For more information, see Unstructured data types.
Usage notes¶
- GET_PRESIGNED_URL and BUILD_SCOPED_FILE_URL are non-deterministic functions; the others are deterministic.