alter_export_task_wh_size()

relationalai.api

alter_export_task_wh_size(object_fq_name STRING, size STRING)

Sets the warehouse size 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 warehouse size is too small 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"'`.
`size`	`STRING`	The warehouse size for the export task. Must be one of `XSMALL`, `SMALL`, `MEDIUM`, `LARGE`, `XLARGE`, or `XXLARGE` (case-insensitive).

Returns

STRING — Returns a confirmation message such as Export task warehouse size set to MEDIUM.

Example

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

-- Set the export task warehouse size to MEDIUM.
-- Replace the placeholder with your database, schema, and table or view name.
CALL relationalai.api.alter_export_task_wh_size('<db>.<schema>.<table_or_view>', 'MEDIUM');
/*+------------------------------------------+
  | Export task warehouse size set to MEDIUM |
  +------------------------------------------+ */

See Manage data streams for more information about data streams.

See Also