ALTER STREAMING TABLE
This feature is in Public Preview.
Applies to: Databricks SQL
Allows you to either:
- Add a schedule for refreshing an existing streaming table.
- Alter an existing refresh schedule for a streaming table.
- Drop the refresh schedule for a streaming table. If the schedule is dropped, the object needs to be refreshed manually to reflect the latest data.
To add or alter a comment on a table or its columns, use COMMENT ON.
Syntax
ALTER STREAMING TABLE table_name
{
{ ADD | ALTER } SCHEDULE [ REFRESH ] schedule_clause |
DROP SCHEDULE |
ALTER COLUMN clause |
SET ROW FILTER clause |
DROP ROW FILTER |
SET TAGS clause |
UNSET TAGS clause |
}
schedule_clause
{ EVERY number { HOUR | HOURS | DAY | DAYS | WEEK | WEEKS } |
CRON cron_string [ AT TIME ZONE timezone_id ] }
Parameters
-
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. IfEVERY
syntax is specified, the streaming table or materialized view is refreshed periodically at the specified interval based on the provided value, such asHOUR
,HOURS
,DAY
,DAYS
,WEEK
, orWEEKS
. The following table lists accepted integer values fornumber
.Time unit
Integer value
HOUR or HOURS
1 <= H <= 72
DAY or DAYS
1 <= D <= 31
WEEK or WEEKS
1 <= W <= 8
注記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. IfAT TIME ZONE
is absent and the session time zone is not set, an error is thrown.SCHEDULE
is semantically equivalent toSCHEDULE REFRESH
.
-
-
Preview
This feature is in Public Preview.
Changes a property of a column.
-
Preview
This feature is in Public Preview.
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
PreviewThis feature is in Public Preview.
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 } [, ...] )
PreviewThis feature is in Public Preview.
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
. Thetag_name
must be unique within the streaming table or column. -
tag_value
A literal
STRING
.
-
-
UNSET TAGS ( tag_name [, ...] )
PreviewThis feature is in Public Preview.
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
. Thetag_name
must be unique within the streaming table or column.
-
Examples
-- Adds a schedule to refresh the streaming table once a day
-- at midnight in Los Angeles
> ALTER STREAMING TABLE my_st
ADD SCHEDULE CRON '0 0 0 * * ? *' AT TIME ZONE 'America/Los_Angeles';
-- Alters the schedule to run every 15 minutes for a streaming table
> ALTER STREAMING TABLE my_st
ALTER SCHEDULE EVERY 15 MINUTES;
-- Drops the schedule for a streaming table
> ALTER STREAMING TABLE my_st
DROP SCHEDULE;