table_name

The name of the streaming table to alter the definition of. The name must not include a temporal specification.

SCHEDULE [ REFRESH ] schedule_clause

Allows you to add a schedule to or alter the schedule of a streaming table.

• EVERY number { HOUR | HOURS | DAY | DAYS | WEEK | WEEKS }

  To schedule a refresh that occurs periodically, use EVERY syntax. If EVERY syntax is specified, the streaming table or materialized view is refreshed periodically at the specified interval based on the provided value, such as HOUR, HOURS, DAY, DAYS, WEEK, or WEEKS. The following table lists accepted integer values for number.

  note

  The singular and plural forms of the included time unit are semantically equivalent.

• CRON cron_string [ AT TIME ZONE timezone_id ]

  To schedule a refresh using a quartz cron value. Valid time_zone_values are accepted. AT TIME ZONE LOCAL is not supported.

  If AT TIME ZONE is absent, the session time zone is used. If AT TIME ZONE is absent and the session time zone is not set, an error is thrown. SCHEDULE is semantically equivalent to SCHEDULE REFRESH.

ALTER COLUMN

Changes a property of a column.

SET ROW FILTER clause

Adds a row filter function to the streaming table. All subsequent queries to the streaming table receive a subset of the rows where the function evaluates to boolean TRUE. This can be useful for fine-grained access control purposes where the function can inspect the identity or group memberships of the invoking user to determine whether to filter certain rows.

DROP ROW FILTER

Drops the row filter from the streaming table, if any. Future queries return all rows from the table without any automatic filtering.

SET TAGS ( { tag_name = tag_value } [, ...] )

Apply tags to the streaming table. You need to have APPLY TAG permission to add tags to the streaming table.

• tag_name

  A literal STRING. The tag_name must be unique within the streaming table or column.

• tag_value

  A literal STRING.

UNSET TAGS ( tag_name [, ...] )

Remove tags from the streaming table. You need to have APPLY TAG permission to remove tags from the streaming table.

• tag_name

  A literal STRING. The tag_name must be unique within the streaming table or column.