Amazon Redshift non supporterà più la creazione di nuove UDF Python a partire dalla Patch 198. Le UDF Python esistenti continueranno a funzionare fino al 30 giugno 2026. Per ulteriori informazioni, consulta il [post del blog](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). 

Le traduzioni sono generate tramite traduzione automatica. In caso di conflitto tra il contenuto di una traduzione e la versione originale in Inglese, quest'ultima prevarrà.

# Registrazione di log sicura
<a name="db-auditing-secure-logging"></a>

Quando Amazon Redshift registra una query che fa riferimento a una o più AWS Glue Data Catalog viste, Amazon Redshift maschera automaticamente i campi in determinate tabelle di sistema e colonne di visualizzazione durante la registrazione dei metadati relativi a tale query.

Il mascheramento sicuro dei log si applica a tutte le voci delle tabelle e delle viste di sistema generate da Amazon Redshift durante l’esecuzione di una query che soddisfa le condizioni di mascheramento. La tabella seguente elenca le viste di sistema e le colonne a cui è applicata la registrazione di log sicura, che maschera il testo con `******` e i numeri con `-1`. Il numero di asterischi utilizzati per mascherare il testo corrisponde al numero di caratteri del testo originale, per un massimo di sei caratteri. Le stringhe più lunghe di sei caratteri continuano a essere visualizzate con sei asterischi.


****  

| Tabelle di sistema | Colonne sensibili | 
| --- | --- | 
| [SYS\_EXTERNAL\_QUERY\_DETAIL](https://docs.aws.amazon.com/redshift/latest/dg/SYS_EXTERNAL_QUERY_DETAIL.html) | **Colonne:** source\_type, total\_partitions, qualified\_partitions, scanned\_files, returned\_rows, returned\_bytes, file\_format, file\_location, external\_query\_text, warning\_message. | 
| [SYS\_EXTERNAL\_QUERY\_ERROR](https://docs.aws.amazon.com/redshift/latest/dg/SYS_EXTERNAL_QUERY_ERROR.html) | **Colonne:** file\_location, rowid, column\_name, original\_value, modified\_value, trigger, action, action\_value, error\_code. | 
| [SYS\_QUERY\_DETAIL](https://docs.aws.amazon.com/redshift/latest/dg/SYS_QUERY_DETAIL.html) | **Colonne:** 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) | **Colonne:** returned\_rows, returned\_bytes. | 
| [STL\_AGGR](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_AGGR.html) | **Colonne:** rows, bytes, tbl, type. | 
| [STL\_BCAST](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_BCAST.html) | **Colonne:** rows, bytes, packets. | 
| [TESTO STL\_DDL](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_DDLTEXT.html) | **Colonne:** label, text. | 
| [STL\_DELETE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_DELETE.html) | **Colonne:** rows, tbl. | 
| [STL\_DIST](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_DIST.html) | **Colonne:** rows, bytes, packets. | 
| [ERRORE\_STL](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_ERROR.html) | **Colonne:** file, linenum, context, error. | 
| [STL\_EXPLAIN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_EXPLAIN.html) | **Colonne:** plannode, info. | 
| [STL\_FILE\_SCAN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_FILE_SCAN.html) | **Colonne:** name, line, bytes. | 
| [STL\_HASH](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_HASH.html) | **Colonne:** rows, bytes, tbl, est\_rows. | 
| [STL\_HASHJOIN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_HASHJOIN.html) | **Colonne:** rows, tbl, num\_parts, join\_type. | 
| [STL\_INSERT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_INSERT.html) | **Colonne:** rows, tbl. | 
| [STL\_LIMIT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_LIMIT.html) | **Colonne:** rows. | 
| [STL\_MERGE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_MERGE.html) | **Colonne:** rows. | 
| [STL\_MERGEJOIN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_MERGEJOIN.html) | **Colonne:** rows, tbl. | 
| [STL\_NESTLOOP](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_NESTLOOP.html) | **Colonne:** rows, tbl. | 
| [STL\_PARSE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_PARSE.html) | **Colonne:** rows. | 
| [STL\_PLAN\_INFO](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_PLAN_INFO.html) | **Colonne:** startupcost, totalcost, rows, bytes. | 
| [PROGETTO STL](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_PROJECT.html) | **Colonne:** rows, tbl. | 
| [STL\_QUERY](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_QUERY.html) | **Colonne:** querytxt. | 
| [STL\_QUERY\_METRICS](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_QUERY_METRICS.html) | **Colonne:** max\_rows, rows, max\_blocks\_read, blocks\_read, max\_blocks\_to\_disk, blocks\_to\_disk, max\_query\_scan\_size, query\_scan\_size. | 
| [TESTO STL\_QUERY](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_QUERYTEXT.html) | **Colonne:** text. | 
| [STL\_RETURN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_RETURN.html) | **Colonne:** rows, bytes. | 
| [CLIENT STL\_S3](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_S3CLIENT.html) | **Colonne:** bucket, key, transfer\_size, data\_size. | 
| [ERRORE\_CLIENT STL\_S3](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_S3CLIENT_ERROR.html) | **Colonne:** bucket, key, error, transfer\_size. | 
| [STL\_SAVE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_SAVE.html) | **Colonne:** rows, bytes, tbl. | 
| [STL\_SCAN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_SCAN.html) | **Colonne:** rows, bytes, fetches, type, 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) | **Colonne:** rows, bytes, tbl. | 
| [ERRORE STL\_SSHCLIENT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_SSHCLIENT_ERROR) | **Colonne:** ssh\_username, endpoint, command, error. | 
| [STL\_TR\_CONFLICT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_TR_CONFLICT.html) | **Colonne**: table\_id. | 
| [STL\_UNDONE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_UNDONE.html) | **Colonne**: table\_id. | 
| [STL\_UNIQUE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_UNIQUE.html) | **Colonne:** rows, type, bytes. | 
| [TESTO STL\_UTILITYTEXT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_UTILITYTEXT.html) | **Colonne:** label, text. | 
| [FINESTRA\_STL](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_WINDOW.html) | **Colonne:** rows. | 
| [STV\_BLOCKLIST](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_BLOCKLIST.html) | **Colonne:** col, tbl, num\_values, minvalue, maxvalue. | 
| [STV\_EXEC\_STATE](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_EXEC_STATE.html) | **Colonne:** rows, bytes, label. | 
| [STV\_INFLIGHT](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_INFLIGHT.html) | **Colonne:** label, text. | 
| [STV\_LOCKS](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_LOCKS.html) | **Colonne**: table\_id. | 
| [STV\_QUERY\_METRICS](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_QUERY_METRICS.html) | **Colonne:** rows, max\_rows, blocks\_read, max\_blocks\_read, max\_blocks\_to\_disk, blocks\_to\_disk, max\_query\_scan\_size, query\_scan\_size. | 
| [STV\_STARTUP\_RECOVERY\_STATE](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_STARTUP_RECOVERY_STATE.html) | **Colonne:** table\_id, table\_name. | 
| [STV\_TBL\_PERM](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_TBL_PERM.html) | **Colonne:** id, name, rows, sorted\_rows, temp, block\_count, query\_scan\_size. | 
| [STV\_TBL\_TRANS](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_TBL_TRANS.html) | **Colonne:** id, rows, size. | 
| [SVCS\_EXPLAIN](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_EXPLAIN.html) | **Colonne:** plannode, info. | 
| [SVCS\_PLAN\_INFO](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_PLAN_INFO.html) | **Colonne:** rows, bytes. | 
| [SVCS\_QUERY\_SUMMARY](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_QUERY_SUMMARY.html) | **Colonne:** step, rows, bytes, rate\_row, rate\_byte, label, rows\_pre\_filter. | 
| [ELENCO SVCS\_S3](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_S3LIST.html) | **Colonne:** bucket, prefix, retrieved\_files, max\_file\_size, avg\_file\_size. | 
| [SVCS\_S3LOG](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_S3LOG.html) | **Colonne:** message. | 
| [RIEPILOGO DELLA PARTIZIONE SVCS\_S3](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_S3PARTITION_SUMMARY.html) | **Colonne:** total\_partitions, qualified\_partitions, min\_assigned\_partitions, max\_assigned\_partitions, avg\_assigned\_partitions. | 
| [SVCS\_S3QUERY\_SUMMARY](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_S3QUERY_SUMMARY.html) | **Colonne:** external\_table\_name, file\_format, s3\_scanned\_rows, s3\_scanned\_bytes, s3query\_returned\_rows, s3query\_returned\_bytes. | 
| [SVL\_QUERY\_METRICS](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_QUERY_METRICS.html) | **Colonne:** step\_label, scan\_row\_count, join\_row\_count, nested\_loop\_join\_row\_count, return\_row\_count, spectrum\_scan\_row\_count, spectrum\_scan\_size\_mb. | 
| [SVL\_QUERY\_METRICS\_SUMMARY](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_QUERY_METRICS_SUMMARY.html) | **Colonne:** step\_label, scan\_row\_count, join\_row\_count, nested\_loop\_join\_row\_count, return\_row\_count, spectrum\_scan\_row\_count, spectrum\_scan\_size\_mb. | 
| [RAPPORTO SVL\_QUERY](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_QUERY_REPORT.html) | **Colonne:** rows, bytes, label, rows\_pre\_filter. | 
| [SVL\_QUERY\_SUMMARY](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_QUERY_SUMMARY.html) | **Colonne:** rows, bytes, rows\_pre\_filter. | 
| [ELENCO SVL\_S3](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3LIST.html) | **Colonne:** bucket, prefix, retrieved\_files, max\_file\_size, avg\_file\_size. | 
| [SVL\_S3LOG](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3LOG.html) | **Colonne:** message. | 
| [PARTIZIONE SVL\_S3](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3PARTITION.html) | **Colonne:** rows, bytes, label, rows\_pre\_filter. | 
| [RIEPILOGO DELLA PARTIZIONE SVL\_S3](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3PARTITION_SUMMARY.html) | **Colonne:** total\_partitions, qualified\_partitions, min\_assigned\_partitions, max\_assigned\_partitions, avg\_assigned\_partitions. | 
| [INTERROGAZIONE SVL\_S3](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3QUERY.html) | **Colonne:** external\_table\_name, file\_format, s3\_scanned\_rows, s3\_scanned\_bytes, s3query\_returned\_rows, s3query\_returned\_bytes, files. | 
| [SVL\_S3QUERY\_RIEPILOGO](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3QUERY_SUMMARY.html) | **Colonne:** external\_table\_name, file\_format, s3\_scanned\_rows, s3\_scanned\_bytes, s3query\_returned\_rows, s3query\_returned\_bytes. | 
| [TENTATIVI SVL\_S3R](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3RETRIES.html) | **Colonne:** file\_size, location, message. | 
| [ERRORE SVL\_SPECTRUM\_SCAN\_](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_SPECTRUM_SCAN_ERROR.html) | **Colonne:** location, rowid, colname, original\_value, modified\_value, trigger, action, action\_value, error\_code. | 
| [TESTO SVL\_STATEMENT](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_STATEMENTTEXT.html) | **Colonne:** type, text. | 
| [SVL\_STORED\_PROC\_CALL](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_STORED_PROC_CALL.html) | **Colonne:** querytxt. | 
| [MESSAGGI\_SVL\_STORED\_PROC](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_STORED_PROC_MESSAGES.html) | **Colonne:** message, linenum, querytext. | 
| [SVL\_UDF\_LOG](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_UDF_LOG.html) | **Colonne:** message, funcname. | 
| [SVV\_DISKUSAGE](https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_DISKUSAGE.html) | **Colonne:** name, col, tbl, blocknum, num\_values, minvalue, maxvalue. | 
| [SVV\_QUERY\_STATE](https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_QUERY_STATE.html) | **Colonne:** rows, bytes, label. | 
| [SVV\_TABLE\_INFO](https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_TABLE_INFO.html) | **Colonne:** table\_id, table. | 
| [SVV\_TRANSACTIONS](https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_TRANSACTIONS.html) | **Colonne**: relation. | 

Per ulteriori informazioni sulle tabelle e sulle viste di sistema, consulta la [documentazione di riferimento delle tabelle e delle viste di sistema](https://docs.aws.amazon.com/redshift/latest/dg/cm_chap_system-tables.html) nella *Guida per sviluppatori di database di Amazon Redshift*. Per informazioni sulla capacità di Amazon Redshift di mascherare dinamicamente i risultati delle query, consulta [Mascheramento dinamico dei dati](https://docs.aws.amazon.com/redshift/latest/dg/t_ddm.html) nella *Guida per sviluppatori di database di Amazon Redshift*. Per informazioni sulla creazione di viste nell' AWS Glue Data Catalog utilizzo di Amazon Redshift, consulta le [AWS Glue Data Catalog viste](https://docs.aws.amazon.com/redshift/latest/dg/data-catalog-views-overview.html) nella Amazon Redshift Database *Developer Guide*.