Amazon Redshift dejará de admitir la creación de nuevas UDF de Python a partir del parche 198. Las UDF de Python existentes seguirán funcionando hasta el 30 de junio de 2026. Para obtener más información, consulte la [publicación del blog](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). # Registro seguro Cuando Amazon Redshift registra una consulta que hace referencia a una o más vistas de AWS Glue Data Catalog, Amazon Redshift enmascara automáticamente los campos de determinadas columnas de tablas y vistas del sistema al registrar los metadatos sobre esa consulta. El enmascaramiento seguro de registros se aplica a todas las entradas de tablas y vistas del sistema que Amazon Redshift genera al ejecutar una consulta que se ajusta a las condiciones de enmascaramiento. En la siguiente tabla se muestran las vistas del sistema y las columnas que han aplicado el registro seguro, mediante el enmascaramiento del texto con `******` y los números con `-1`. El número de asteriscos que se utiliza para enmascarar el texto coincide con el número de caracteres del texto original, hasta un máximo de 6 caracteres. Las cadenas de más de 6 caracteres siguen apareciendo como 6 asteriscos. **** | Tabla del sistema | Columnas confidenciales | | --- | --- | | [SYS\_EXTERNAL\_QUERY\_DETAIL](https://docs.aws.amazon.com/redshift/latest/dg/SYS_EXTERNAL_QUERY_DETAIL.html) | **Columnas:** source\_type, total\_partitions, qualified\_partitions, scanned\_files, returned\_rows, returned\_bytes, file\_format, file\_location, external\_query\_text y warning\_message. | | [SYS\_EXTERNAL\_QUERY\_ERROR](https://docs.aws.amazon.com/redshift/latest/dg/SYS_EXTERNAL_QUERY_ERROR.html) | **Columnas:** file\_location, rowid, column\_name, original\_value, modified\_value, trigger, action, action\_value y error\_code. | | [SYS\_QUERY\_DETAIL](https://docs.aws.amazon.com/redshift/latest/dg/SYS_QUERY_DETAIL.html) | **Columnas:** step\_id, step\_name, table\_id, table\_name, input\_bytes, input\_rows, output\_bytes, output\_rows, blocks\_read, blocks\_write, local\_read\_IO, remote\_read\_IO, spilled\_block\_local\_disk, spilled\_block\_remote\_disk, step\_attribute. | | [SYS\_QUERY\_HISTORY](https://docs.aws.amazon.com/redshift/latest/dg/SYS_QUERY_HISTORY.html) | **Columnas:** returned\_rows y returned\_bytes. | | [STL\_AGGR](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_AGGR.html) | **Columnas:** rows, bytes, tbl y type. | | [STL\_BCAST](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_BCAST.html) | **Columnas:** rows, bytes y packets. | | [STL\_DDLTEXT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_DDLTEXT.html) | **Columnas:** etiqueta, texto. | | [STL\_DELETE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_DELETE.html) | **Columnas:** rows y tbl. | | [STL\_DIST](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_DIST.html) | **Columnas:** rows, bytes y packets. | | [STL\_ERROR](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_ERROR.html) | **Columnas:** archivo, linenum, contexto, error. | | [STL\_EXPLAIN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_EXPLAIN.html) | **Columnas:** plannode e info. | | [STL\_FILE\_SCAN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_FILE_SCAN.html) | **Columnas:** nombre, línea, bytes. | | [STL\_HASH](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_HASH.html) | **Columnas:** rows, bytes, tbl y est\_rows. | | [STL\_HASHJOIN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_HASHJOIN.html) | **Columnas:** rows, tbl, num\_parts y join\_type. | | [STL\_INSERT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_INSERT.html) | **Columnas:** rows y tbl. | | [STL\_LIMIT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_LIMIT.html) | **Columnas:** rows. | | [STL\_MERGE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_MERGE.html) | **Columnas:** rows. | | [STL\_MERGEJOIN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_MERGEJOIN.html) | **Columnas:** rows y tbl. | | [STL\_NESTLOOP](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_NESTLOOP.html) | **Columnas:** rows y tbl. | | [STL\_PARSE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_PARSE.html) | **Columnas:** rows. | | [STL\_PLAN\_INFO](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_PLAN_INFO.html) | **Columnas:** costo inicial, costo total, filas, bytes. | | [STL\_PROJECT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_PROJECT.html) | **Columnas:** rows y tbl. | | [STL\_QUERY](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_QUERY.html) | **Columnas:** querytxt. | | [STL\_QUERY\_METRICS](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_QUERY_METRICS.html) | **Columnas:** max\_rows, rows, max\_blocks\_read, blocks\_read, max\_blocks\_to\_disk, blocks\_to\_disk, max\_query\_scan\_size y query\_scan\_size. | | [STL\_QUERYTEXT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_QUERYTEXT.html) | **Columnas:** text. | | [STL\_RETURN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_RETURN.html) | **Columnas:** rows y bytes. | | [STL\_S3CLIENT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_S3CLIENT.html) | **Columnas:** bucket, clave, transfer\_size, data\_size. | | [STL\_S3CLIENT\_ERROR](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_S3CLIENT_ERROR.html) | **Columnas:** bucket, clave, error, transfer\_size. | | [STL\_SAVE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_SAVE.html) | **Columnas:** rows, bytes y tbl. | | [STL\_SCAN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_SCAN.html) | **Columnas:** filas, bytes, búsquedas, tipo, tbl, rows\_pre\_filter, rows\_pre\_user\_filter, perm\_table\_name, scanned\_mega\_value. | | [STL\_SORT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_SORT.html) | **Columnas:** rows, bytes y tbl. | | [STL\_SSHCLIENT\_ERROR](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_SSHCLIENT_ERROR) | **Columnas:** ssh\_username, punto de conexión, comando, error. | | [STL\_TR\_CONFLICT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_TR_CONFLICT.html) | **Columnas:** table\_id. | | [STL\_UNDONE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_UNDONE.html) | **Columnas:** table\_id. | | [STL\_UNIQUE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_UNIQUE.html) | **Columnas:** rows, type y bytes. | | [STL\_UTILITYTEXT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_UTILITYTEXT.html) | **Columnas:** etiqueta, texto. | | [STL\_WINDOW](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_WINDOW.html) | **Columnas:** rows. | | [STV\_BLOCKLIST](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_BLOCKLIST.html) | **Columnas:** col, tbl, num\_values, minvalue y maxvalue. | | [STV\_EXEC\_STATE](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_EXEC_STATE.html) | **Columnas:** rows, bytes y label. | | [STV\_INFLIGHT](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_INFLIGHT.html) | **Columnas:** etiqueta, texto. | | [STV\_LOCKS](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_LOCKS.html) | **Columnas:** table\_id. | | [STV\_QUERY\_METRICS](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_QUERY_METRICS.html) | **Columnas:** rows, max\_rows, blocks\_read, max\_blocks\_read, max\_blocks\_to\_disk, blocks\_to\_disk, max\_query\_scan\_size y query\_scan\_size. | | [STV\_STARTUP\_RECOVERY\_STATE](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_STARTUP_RECOVERY_STATE.html) | **Columnas:** table\_id y table\_name. | | [STV\_TBL\_PERM](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_TBL_PERM.html) | **Columnas:** id, nombre, filas, sorted\_rows, temporal, block\_count, query\_scan\_size. | | [STV\_TBL\_TRANS](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_TBL_TRANS.html) | **Columnas:** id, rows y size. | | [SVCS\_EXPLAIN](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_EXPLAIN.html) | **Columnas:** plannode e info. | | [SVCS\_PLAN\_INFO](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_PLAN_INFO.html) | **Columnas:** rows y bytes. | | [SVCS\_QUERY\_SUMMARY](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_QUERY_SUMMARY.html) | **Columnas:** step, rows, bytes, rate\_row, rate\_byte, label y rows\_pre\_filter. | | [SVCS\_S3LIST](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_S3LIST.html) | **Columnas:** bucket, prefijo, retrieved\_files, max\_file\_size, avg\_file\_size. | | [SVCS\_S3LOG](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_S3LOG.html) | **Columnas:** message. | | [SVCS\_S3PARTITION\_SUMMARY](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_S3PARTITION_SUMMARY.html) | **Columnas:** total\_partitions, qualified\_partitions, min\_assigned\_partitions, max\_assigned\_partitions y avg\_assigned\_partitions. | | [SVCS\_S3QUERY\_SUMMARY](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_S3QUERY_SUMMARY.html) | **Columnas:** external\_table\_name, file\_format, s3\_scanned\_rows, s3\_scanned\_bytes, s3query\_returned\_rows y s3query\_returned\_bytes. | | [SVL\_QUERY\_METRICS](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_QUERY_METRICS.html) | **Columnas:** step\_label, scan\_row\_count, join\_row\_count, nested\_loop\_join\_row\_count, return\_row\_count, spectrum\_scan\_row\_count y spectrum\_scan\_size\_mb. | | [SVL\_QUERY\_METRICS\_SUMMARY](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_QUERY_METRICS_SUMMARY.html) | **Columnas:** step\_label, scan\_row\_count, join\_row\_count, nested\_loop\_join\_row\_count, return\_row\_count, spectrum\_scan\_row\_count y spectrum\_scan\_size\_mb. | | [SVL\_QUERY\_REPORT](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_QUERY_REPORT.html) | **Columnas:** rows, bytes, label y rows\_pre\_filter. | | [SVL\_QUERY\_SUMMARY](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_QUERY_SUMMARY.html) | **Columnas:** rows, bytes y rows\_pre\_filter. | | [SVL\_S3LIST](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3LIST.html) | **Columnas:** bucket, prefijo, retrieved\_files, max\_file\_size, avg\_file\_size. | | [SVL\_S3LOG](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3LOG.html) | **Columnas:** message. | | [SVL\_S3PARTITION](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3PARTITION.html) | **Columnas:** rows, bytes, label y rows\_pre\_filter. | | [SVL\_S3PARTITION\_SUMMARY](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3PARTITION_SUMMARY.html) | **Columnas:** total\_partitions, qualified\_partitions, min\_assigned\_partitions, max\_assigned\_partitions y avg\_assigned\_partitions. | | [SVL\_S3QUERY](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3QUERY.html) | **Columnas:** external\_table\_name, file\_format, s3\_scanned\_rows, s3\_scanned\_bytes, s3query\_returned\_rows, s3query\_returned\_bytes, archivos. | | [SVL\_S3QUERY\_SUMMARY](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3QUERY_SUMMARY.html) | **Columnas:** external\_table\_name, file\_format, s3\_scanned\_rows, s3\_scanned\_bytes, s3query\_returned\_rows y s3query\_returned\_bytes. | | [SVL\_S3RETRIES](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3RETRIES.html) | **Columnas:** file\_size, location y message. | | [SVL\_SPECTRUM\_SCAN\_ERROR](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_SPECTRUM_SCAN_ERROR.html) | **Columnas:** ubicación, rowid, colname, original\_value, modified\_value, desencadenar, acción, action\_value, error\_code. | | [SVL\_STATEMENTTEXT](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_STATEMENTTEXT.html) | **Columnas:** type y text. | | [SVL\_STORED\_PROC\_CALL](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_STORED_PROC_CALL.html) | **Columnas:** querytxt. | | [SVL\_STORED\_PROC\_MESSAGES](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_STORED_PROC_MESSAGES.html) | **Columnas:** mensaje, linenum, querytext. | | [SVL\_UDF\_LOG](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_UDF_LOG.html) | **Columnas:** mensaje, funcname. | | [SVV\_DISKUSAGE](https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_DISKUSAGE.html) | **Columnas:** name, col, tbl, blocknum, num\_values, minvalue y maxvalue. | | [SVV\_QUERY\_STATE](https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_QUERY_STATE.html) | **Columnas:** rows, bytes y label. | | [SVV\_TABLE\_INFO](https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_TABLE_INFO.html) | **Columnas:** table\_id y table. | | [SVV\_TRANSACTIONS](https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_TRANSACTIONS.html) | **Columnas:** relation. | Para obtener más información acerca de las vistas y tablas del sistema, consulte la [Referencia de las tablas y vistas de sistema](https://docs.aws.amazon.com/redshift/latest/dg/cm_chap_system-tables.html) en la *Guía para desarrolladores de bases de datos de Amazon Redshift*. Para obtener información sobre la capacidad de Amazon Redshift para enmascarar dinámicamente los resultados de las consultas, consulte [Enmascaramiento de datos dinámico](https://docs.aws.amazon.com/redshift/latest/dg/t_ddm.html) en la *Guía para desarrolladores de bases de datos de Amazon Redshift*. Para obtener información sobre cómo crear vistas en AWS Glue Data Catalog con Amazon Redshift, consulte [Vistas de AWS Glue Data Catalog](https://docs.aws.amazon.com/redshift/latest/dg/data-catalog-views-overview.html) en la *Guía para desarrolladores de bases de datos de Amazon Redshift*.