HARVEST_FILES

File metadata available through SORACOM Harvest Files.

Public Contract

• Rows are limited to the current SORACOM Query request context.

Data Freshness

Updated near real time.

Columns

Column	Type	Description
FILENAME	TEXT	Name of the file.
DIRECTORY	TEXT	Directory path.
FILE_PATH	TEXT	Full path to the file.
CONTENT_TYPE	TEXT	MIME type of the file.
CONTENT_LENGTH	NUMBER	Size of the file in bytes.
DIR	NUMBER	Directory identifier.
FILE_ID	TEXT	Unique file identifier.
ETAG	TEXT	Entity tag for cache validation.
CREATED_TIME	TIMESTAMP_NTZ	When the file was created.
LAST_MODIFIED_TIME	TIMESTAMP_NTZ	When the file was last modified.

Common Queries

Largest files:

SELECT
  FILE_PATH,
  CONTENT_TYPE,
  CONTENT_LENGTH,
  LAST_MODIFIED_TIME
FROM HARVEST_FILES
WHERE DIR = 0
ORDER BY CONTENT_LENGTH DESC
LIMIT 100;

Recently modified files:

SELECT
  FILE_PATH,
  CONTENT_TYPE,
  CONTENT_LENGTH,
  LAST_MODIFIED_TIME
FROM HARVEST_FILES
ORDER BY LAST_MODIFIED_TIME DESC
LIMIT 100;