Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025.
If you would like to use Python UDFs, create the UDFs prior to that date.
Existing Python UDFs will continue to function as normal. For more information, see the
blog post
STV_SLICES
Use the STV_SLICES table to view the current mapping of a slice to a node.
The information in STV_SLICES is used mainly for investigation purposes.
STV_SLICES is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of data in system tables and views.
Table columns
Column name | Data type | Description |
---|---|---|
node | integer | Cluster node where the slice is located. |
slice | integer | Node slice. |
localslice | integer | This information is for internal use only. |
type | character(1) | This information is for internal use only. |
Sample query
To view which cluster nodes are managing which slices, type the following query:
select node, slice from stv_slices;
This query returns the following sample output:
node | slice ------+------- 0 | 2 0 | 3 0 | 1 0 | 0 (4 rows)