snowflake.snowpark.functions.fl_get_file_type¶

snowflake.snowpark.functions.fl_get_file_type(e: Union[Column, str]) → Column[source]¶

Returns the file type (modality) of a FILE. One of following values are returned:

  • document

  • video

  • audio

  • image

  • compressed

  • unknown

Example:

>>> import json
>>> # Create a temp stage.
>>> _ = session.sql("create or replace temp stage mystage").collect()
>>> # Upload a file to a stage.
>>> r = session.file.put("tests/resources/testCSV.csv", "@mystage", auto_compress=False, overwrite=True)
>>> df = session.range(1).select(fl_get_file_type(to_file("@mystage/testCSV.csv")).alias("file"))
>>> df.collect()[0][0]
'document'


This function or method is in private preview since 1.29.0.
Copy
Language: English