alter_export_task_timeout()

relationalai.api

alter_export_task_timeout(object_fq_name STRING, timeout_ms FLOAT)

Sets the timeout, in milliseconds, for a data stream’s export task. Each data stream uses a Snowflake serverless task to export the changes it has processed. Use this procedure in exceptional cases where the default timeout is too short and the export task times out on a large or expensive export. Requires the rai_user application role.

Parameters

Name	Type	Description
`object_fq_name`	`STRING`	The fully-qualified name of the data stream’s source table or view in Snowflake, e.g. `'<db>.<schema>.<table_or_view>'`. Snowflake converts unquoted names to uppercase, so double-quote a lowercase or mixed-case name to reference it exactly, for example `'<db>.<schema>."My_Table"'`.
`timeout_ms`	`FLOAT`	The export task timeout in milliseconds. Must be between `0` and `604800000` (7 days). Use `0` to apply the maximum timeout of 7 days.

Returns

STRING — Returns a confirmation message such as Export task timeout set to 3600000 ms.

Example

Use api.alter_export_task_timeout() to increase the timeout for a data stream’s export task when it times out on a large export:

-- Set the export task timeout to 1 hour (3,600,000 ms).
-- Replace the placeholder with your database, schema, and table or view name.
CALL relationalai.api.alter_export_task_timeout('<db>.<schema>.<table_or_view>', 3600000);
/*+---------------------------------------+
  | Export task timeout set to 3600000 ms |
  +---------------------------------------+ */

See Manage data streams for more information about data streams.

See Also