module pixeltable.functions.net

Pixeltable UDF for converting media file URIs to presigned HTTP URLs.

udf presigned_url()

Signature

@pxt.udf
presigned_url(uri: pxt.String, expiration_seconds: pxt.Int) -> pxt.String

Convert a blob storage URI to a presigned HTTP URL for direct access. Generates a time-limited, publicly accessible URL from cloud storage URIs (S3, GCS, Azure, etc.) that can be used to serve media files over HTTP. Note: This function uses presigned URLs from storage providers. Provider-specific limitations apply:

Google Cloud Storage: maximum 7-day expiration
AWS S3: requires proper region configuration
Azure: subject to storage account access policies

Parameters:

uri (pxt.String): The media file URI (e.g., s3://bucket/path, gs://bucket/path, azure://container/path)
expiration_seconds (pxt.Int): How long the URL remains valid

Returns:

pxt.String: A presigned HTTP URL for accessing the file

Examples: Generate a presigned URL for a video column with 1-hour expiration:

tbl.select(
    original_url=tbl.video.fileurl,
    presigned_url=pxtf.net.presigned_url(tbl.video.fileurl, 3600),
).collect()

​module pixeltable.functions.net

​udf presigned_url()

module pixeltable.functions.net

udf presigned_url()