Amazon Redshift ne prendra plus en charge la création de nouveaux Python à UDFs partir du patch 198. UDFs Le Python existant continuera de fonctionner jusqu'au 30 juin 2026. Pour plus d’informations, consultez le [ billet de blog ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). 

Les traductions sont fournies par des outils de traduction automatique. En cas de conflit entre le contenu d'une traduction et celui de la version originale en anglais, la version anglaise prévaudra.

# Journalisation sécurisée
<a name="db-auditing-secure-logging"></a>

Lorsqu'Amazon Redshift enregistre une requête qui fait référence à une ou plusieurs AWS Glue Data Catalog vues, Amazon Redshift masque automatiquement les champs de certaines tables système et colonnes de vue lors de l'enregistrement des métadonnées relatives à cette requête.

Le masquage sécurisé des journaux s’applique à toutes les entrées de table et de vue système générées par Amazon Redshift lors de l’exécution d’une requête répondant aux conditions de masquage. La table suivante répertorie les vues et les colonnes du système auxquelles une journalisation sécurisée est appliquée, masquant le texte avec `******` et les chiffres avec `-1`. Le nombre d’astérisques utilisés pour masquer le texte correspond au nombre de caractères du texte d’origine, jusqu’à 6 caractères. Les chaînes de plus de 6 caractères apparaissent toujours sous la forme de 6 astérisques.


****  

| Table système | Colonnes sensibles | 
| --- | --- | 
| [SYS\_EXTERNAL\_QUERY\_DETAIL](https://docs.aws.amazon.com/redshift/latest/dg/SYS_EXTERNAL_QUERY_DETAIL.html) | **Colonnes :** source\_type, total\_partitions, qualified\_partitions, scanned\_files, returned\_rows, returned\_bytes, file\_format, file\_location, external\_query\_text, warning\_message. | 
| [ERREUR SYS\_EXTERNAL\_QUERY\_ERROR](https://docs.aws.amazon.com/redshift/latest/dg/SYS_EXTERNAL_QUERY_ERROR.html) | **Colonnes :** 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) | **Colonnes :** 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) | **Colonnes :** returned\_rows, returned\_bytes. | 
| [STL\_AGGR](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_AGGR.html) | **Colonnes :** rows, bytes, tbl, type. | 
| [STL\_BCAST](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_BCAST.html) | **Colonnes :** rows, bytes, packets. | 
| [STL\_DDLTEXT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_DDLTEXT.html) | **Colonnes :** label, text. | 
| [STL\_SUPPRIMER](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_DELETE.html) | **Colonnes :** rows, tbl. | 
| [STL\_DIST](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_DIST.html) | **Colonnes :** rows, bytes, packets. | 
| [ERREUR STL](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_ERROR.html) | **Colonnes :** file, linenum, context, error. | 
| [STL\_EXPLAIN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_EXPLAIN.html) | **Colonnes :** plannode, info. | 
| [STL\_FILE\_SCAN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_FILE_SCAN.html) | **Colonnes :** name, line, bytes. | 
| [STL HASH](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_HASH.html) | **Colonnes :** rows, bytes, tbl, est\_rows. | 
| [STL\_HASHJOIN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_HASHJOIN.html) | **Colonnes :** rows, tbl, num\_parts, join\_type. | 
| [STL\_INSERT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_INSERT.html) | **Colonnes :** rows, tbl. | 
| [STL\_LIMIT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_LIMIT.html) | **Colonnes :** rows. | 
| [STL\_MERGE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_MERGE.html) | **Colonnes :** rows. | 
| [STL\_MERGEJOIN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_MERGEJOIN.html) | **Colonnes :** rows, tbl. | 
| [STL NESTLOOP](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_NESTLOOP.html) | **Colonnes :** rows, tbl. | 
| [STL\_PARSE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_PARSE.html) | **Colonnes :** rows. | 
| [INFORMATIONS SUR LE PLAN STL](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_PLAN_INFO.html) | **Colonnes :** startupcost, totalcost, rows, bytes. | 
| [PROJET STL](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_PROJECT.html) | **Colonnes :** rows, tbl. | 
| [REQUÊTE STL](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_QUERY.html) | **Colonnes :** querytxt. | 
| [STL\_QUERY\_METRICS](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_QUERY_METRICS.html) | **Colonnes :** max\_rows, rows, max\_blocks\_read, blocks\_read, max\_blocks\_to\_disk, blocks\_to\_disk, max\_query\_scan\_size, query\_scan\_size. | 
| [TEXTE DE REQUÊTE STL](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_QUERYTEXT.html) | **Colonnes :** text. | 
| [STL\_RETURN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_RETURN.html) | **Colonnes :** rows, bytes. | 
| [CLIENT STL\_S3](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_S3CLIENT.html) | **Colonnes :** bucket, key, transfer\_size, data\_size. | 
| [STL\_S3CLIENT\_ERROR](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_S3CLIENT_ERROR.html) | **Colonnes :** bucket, key, error, transfer\_size. | 
| [STL\_SAVE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_SAVE.html) | **Colonnes :** rows, bytes, tbl. | 
| [STL\_SCAN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_SCAN.html) | **Colonnes :** 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) | **Colonnes :** rows, bytes, tbl. | 
| [ERREUR STL\_SSHCLIENT\_ERROR](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_SSHCLIENT_ERROR) | **Colonnes :** ssh\_username, endpoint, command, error. | 
| [STL\_TR\_CONFLICT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_TR_CONFLICT.html) | **Colonnes :** table\_id. | 
| [STL\_UNDONE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_UNDONE.html) | **Colonnes :** table\_id. | 
| [STL UNIQUE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_UNIQUE.html) | **Colonnes :** rows, type, bytes. | 
| [STL\_UTILITYTEXT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_UTILITYTEXT.html) | **Colonnes :** label, text. | 
| [FENÊTRE STL](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_WINDOW.html) | **Colonnes :** rows. | 
| [STV\_BLOCKLIST](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_BLOCKLIST.html) | **Colonnes :** col, tbl, num\_values, minvalue, maxvalue. | 
| [STV\_EXEC\_STATE](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_EXEC_STATE.html) | **Colonnes :** rows, bytes, label. | 
| [STV\_INFLIGHT](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_INFLIGHT.html) | **Colonnes :** label, text. | 
| [STV LOCKS](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_LOCKS.html) | **Colonnes :** table\_id. | 
| [STV\_QUERY\_METRICS](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_QUERY_METRICS.html) | **Colonnes :** 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) | **Colonnes :** table\_id, table\_name. | 
| [STV\_TBL\_PERM](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_TBL_PERM.html) | **Colonnes :** 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) | **Colonnes :** id, rows, size. | 
| [SVCS\_EXPLAIN](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_EXPLAIN.html) | **Colonnes :** plannode, info. | 
| [INFORMATIONS SUR LE PLAN SVCS](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_PLAN_INFO.html) | **Colonnes :** rows, bytes. | 
| [RÉSUMÉ DE LA REQUÊTE SVCS](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_QUERY_SUMMARY.html) | **Colonnes :** step, rows, bytes, rate\_row, rate\_byte, label, rows\_pre\_filter. | 
| [LISTE SVCS\_S3](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_S3LIST.html) | **Colonnes :** bucket, prefix, retrieved\_files, max\_file\_size, avg\_file\_size. | 
| [SVCS\_S3LOG](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_S3LOG.html) | **Colonnes :** message. | 
| [SVCS\_S3PARTITION\_SUMMARY](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_S3PARTITION_SUMMARY.html) | **Colonnes :** 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) | **Colonnes :** 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) | **Colonnes :** step\_label, scan\_row\_count, join\_row\_count, nested\_loop\_join\_row\_count, return\_row\_count, spectrum\_scan\_row\_count, spectrum\_scan\_size\_mb. | 
| [RÉSUMÉ DES MÉTRIQUES DE LA REQUÊTE SVL](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_QUERY_METRICS_SUMMARY.html) | **Colonnes :** 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\_REPORT](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_QUERY_REPORT.html) | **Colonnes :** rows, bytes, label, rows\_pre\_filter. | 
| [RÉSUMÉ DE LA REQUÊTE SVL](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_QUERY_SUMMARY.html) | **Colonnes :** rows, bytes, rows\_pre\_filter. | 
| [LISTE SVL\_S3](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3LIST.html) | **Colonnes :** bucket, prefix, retrieved\_files, max\_file\_size, avg\_file\_size. | 
| [SVL\_S3LOG](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3LOG.html) | **Colonnes :** message. | 
| [PARTITION SVL\_S3](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3PARTITION.html) | **Colonnes :** rows, bytes, label, rows\_pre\_filter. | 
| [SVL\_S3PARTITION\_SUMMARY](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3PARTITION_SUMMARY.html) | **Colonnes :** total\_partitions, qualified\_partitions, min\_assigned\_partitions, max\_assigned\_partitions, avg\_assigned\_partitions. | 
| [REQUÊTE SVL\_S3](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3QUERY.html) | **Colonnes :** external\_table\_name, file\_format, s3\_scanned\_rows, s3\_scanned\_bytes, s3query\_returned\_rows, s3query\_returned\_bytes, files. | 
| [RÉSUMÉ DE LA REQUÊTE SVL\_S3](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3QUERY_SUMMARY.html) | **Colonnes :** external\_table\_name, file\_format, s3\_scanned\_rows, s3\_scanned\_bytes, s3query\_returned\_rows, s3query\_returned\_bytes. | 
| [SVL\_S3 RÉESSAIE](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3RETRIES.html) | **Colonnes :** file\_size, location, message. | 
| [SVL\_SPECTRUM\_SCAN\_ERROR](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_SPECTRUM_SCAN_ERROR.html) | **Colonnes :** location, rowid, colname, original\_value, modified\_value, trigger, action, action\_value, error\_code. | 
| [SVL\_STATEMENTTEXT](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_STATEMENTTEXT.html) | **Colonnes :** type, text. | 
| [SVL\_STORED\_PROC\_CALL](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_STORED_PROC_CALL.html) | **Colonnes :** querytxt. | 
| [SVL\_STORED\_PROC\_MESSAGES](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_STORED_PROC_MESSAGES.html) | **Colonnes :** message, linenum, querytext. | 
| [SVL\_UDF\_LOG](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_UDF_LOG.html) | **Colonnes :** message, funcname. | 
| [UTILISATION DU DISQUE SVV](https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_DISKUSAGE.html) | **Colonnes :** name, col, tbl, blocknum, num\_values, minvalue, maxvalue. | 
| [SVV\_QUERY\_STATE](https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_QUERY_STATE.html) | **Colonnes :** rows, bytes, label. | 
| [SVV\_TABLE\_INFO](https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_TABLE_INFO.html) | **Colonnes :** table\_id, table. | 
| [SVV\_TRANSACTIONS](https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_TRANSACTIONS.html) | **Colonnes :** relation. | 

Pour plus d’informations sur les vues et les tables système dans, consultez [Informations de référence sur les tables et les vues système](https://docs.aws.amazon.com/redshift/latest/dg/cm_chap_system-tables.html) dans le *Guide du développeur de base de données Amazon Redshift*. Pour plus d’informations sur la capacité d’Amazon Redshift à masquer dynamiquement les résultats des requêtes, consultez la section [Masquage dynamique des données](https://docs.aws.amazon.com/redshift/latest/dg/t_ddm.html) dans le *Guide du développeur de base de données Amazon Redshift* Pour plus d'informations sur la création de vues dans le cadre de AWS Glue Data Catalog l'utilisation d'Amazon Redshift, consultez les [AWS Glue Data Catalog vues](https://docs.aws.amazon.com/redshift/latest/dg/data-catalog-views-overview.html) dans le manuel *Amazon Redshift Database Developer* Guide.