Amazon Redshift tidak akan lagi mendukung pembuatan Python UDFs baru mulai Patch 198. Python yang ada UDFs akan terus berfungsi hingga 30 Juni 2026. Untuk informasi lebih lanjut, lihat [posting blog](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). Terjemahan disediakan oleh mesin penerjemah. Jika konten terjemahan yang diberikan bertentangan dengan versi bahasa Inggris aslinya, utamakan versi bahasa Inggris. # Pencatatan aman Saat Amazon Redshift mencatat kueri yang mereferensikan satu atau beberapa AWS Glue Data Catalog tampilan, Amazon Redshift secara otomatis menutupi bidang dalam tabel sistem tertentu dan kolom tampilan saat mencatat metadata tentang kueri tersebut. Masking log aman berlaku untuk semua tabel sistem dan entri tampilan yang dihasilkan Amazon Redshift saat menjalankan kueri yang sesuai dengan kondisi masking. Tabel berikut mencantumkan tampilan sistem dan kolom yang memiliki logging aman diterapkan, menutupi teks dengan `******` dan angka dengan`-1`. Jumlah tanda bintang yang digunakan untuk menutupi teks cocok dengan jumlah karakter dalam teks asli, hingga 6 karakter. String yang lebih panjang dari 6 karakter masih muncul sebagai 6 tanda bintang. **** | Tabel sistem | Kolom sensitif | | --- | --- | | [SYS\_EXTERNAL\_QUERY\_DETAIL](https://docs.aws.amazon.com/redshift/latest/dg/SYS_EXTERNAL_QUERY_DETAIL.html) | **Kolom:** 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) | **Kolom:** 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) | **Kolom:** step\_id, step\_name, table\_id, table\_name, input\_bytes, input\_rows, output\_byte, 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) | **Kolom:** returned\_rows, returned\_bytes. | | [STL\_AGGR](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_AGGR.html) | **Kolom:** baris, byte, tbl, jenis. | | [STL\_BCAST](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_BCAST.html) | **Kolom:** baris, byte, paket. | | [STL\_DDLTEXT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_DDLTEXT.html) | **Kolom:** label, teks. | | [STL\_DELETE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_DELETE.html) | **Kolom:** baris, tbl. | | [STL\_DIST](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_DIST.html) | **Kolom:** baris, byte, paket. | | [STL\_ERROR](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_ERROR.html) | **Kolom:** file, linenum, konteks, kesalahan. | | [STL\_JELASKAN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_EXPLAIN.html) | **Kolom:** plannode, info. | | [STL\_FILE\_SCAN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_FILE_SCAN.html) | **Kolom:** nama, baris, byte. | | [STL\_HASH](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_HASH.html) | **Kolom:** baris, byte, tbl, est\_rows. | | [STL\_HASHJOIN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_HASHJOIN.html) | **Kolom:** baris, tbl, num\_parts, join\_type. | | [STL\_INSERT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_INSERT.html) | **Kolom:** baris, tbl. | | [STL\_LIMIT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_LIMIT.html) | **Kolom:** baris. | | [STL\_MERGE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_MERGE.html) | **Kolom:** baris. | | [STL\_MERGEJOIN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_MERGEJOIN.html) | **Kolom:** baris, tbl. | | [STL\_NESTLOOP](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_NESTLOOP.html) | **Kolom:** baris, tbl. | | [STL\_PARSE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_PARSE.html) | **Kolom:** baris. | | [STL\_PLAN\_INFO](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_PLAN_INFO.html) | **Kolom:** startupcost, totalcost, baris, byte. | | [STL\_PROJECT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_PROJECT.html) | **Kolom:** baris, tbl. | | [STL\_QUERY](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_QUERY.html) | **Kolom:** querytxt. | | [STL\_QUERY\_METRICS](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_QUERY_METRICS.html) | **Kolom:** max\_rows, baris, max\_blocks\_read, max\_blocks\_to\_disk, blocks\_to\_disk, max\_query\_scan\_size, query\_scan\_size. | | [STL\_QUERYTEXT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_QUERYTEXT.html) | **Kolom:** teks. | | [STL\_KEMBALI](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_RETURN.html) | **Kolom:** baris, byte. | | [STL\_S3KLIEN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_S3CLIENT.html) | **Kolom:** ember, kunci, transfer\_size, data\_size. | | [STL\_S3CLIENT\_ERROR](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_S3CLIENT_ERROR.html) | **Kolom:** ember, kunci, kesalahan, transfer\_size. | | [STL\_SIMPAN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_SAVE.html) | **Kolom:** baris, byte, tbl. | | [STL\_SCAN](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_SCAN.html) | **Kolom:** baris, byte, pengambilan, jenis, 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) | **Kolom:** baris, byte, tbl. | | [STL\_SSHCLIENT\_ERROR](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_SSHCLIENT_ERROR) | **Kolom:** ssh\_username, titik akhir, perintah, kesalahan. | | [STL\_TR\_CONFLICT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_TR_CONFLICT.html) | **Kolom:** table\_id. | | [STL\_UNDONE](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_UNDONE.html) | **Kolom:** table\_id. | | [STL\_UNIK](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_UNIQUE.html) | **Kolom:** baris, jenis, byte. | | [STL\_UTILITYTEXT](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_UTILITYTEXT.html) | **Kolom:** label, teks. | | [STL\_WINDOW](https://docs.aws.amazon.com/redshift/latest/dg/r_STL_WINDOW.html) | **Kolom:** baris. | | [STV\_BLOCKLIST](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_BLOCKLIST.html) | **Kolom:** col, tbl, num\_values, minvalue, maxvalue. | | [STV\_EXEC\_STATE](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_EXEC_STATE.html) | **Kolom:** baris, byte, label. | | [STV\_DALAM PESAWAT](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_INFLIGHT.html) | **Kolom:** label, teks. | | [STV\_LOCKS](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_LOCKS.html) | **Kolom:** table\_id. | | [STV\_QUERY\_METRICS](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_QUERY_METRICS.html) | **Kolom:** baris, 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) | **Kolom:** table\_id, table\_name. | | [STV\_TBL\_PERM](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_TBL_PERM.html) | **Kolom:** id, nama, baris, sorted\_rows, temp, block\_count, query\_scan\_size. | | [STV\_TBL\_TRANS](https://docs.aws.amazon.com/redshift/latest/dg/r_STV_TBL_TRANS.html) | **Kolom:** id, baris, ukuran. | | [SVCS\_JELASKAN](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_EXPLAIN.html) | **Kolom:** plannode, info. | | [SVCS\_PLAN\_INFO](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_PLAN_INFO.html) | **Kolom:** baris, byte. | | [SVCS\_QUERY\_RINGKASAN](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_QUERY_SUMMARY.html) | **Kolom:** langkah, baris, byte, rate\_row, rate\_byte, label, rows\_pre\_filter. | | [SVCS\_S3LIST](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_S3LIST.html) | **Kolom:** ember, awalan, retrieved\_files, max\_file\_size, avg\_file\_size. | | [SVCS\_S3LOG](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_S3LOG.html) | **Kolom:** pesan. | | [SVCS\_S3PARTITION\_RINGKASAN](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_S3PARTITION_SUMMARY.html) | **Kolom:** total\_partitions, qualified\_partitions, min\_assigned\_partitions, max\_assigned\_partitions, avg\_assigned\_partitions. | | [SVCS\_S3QUERY\_RINGKASAN](https://docs.aws.amazon.com/redshift/latest/dg/r_SVCS_S3QUERY_SUMMARY.html) | **Kolom:** 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) | **Kolom:** 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) | **Kolom:** 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\_LAPORAN](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_QUERY_REPORT.html) | **Kolom:** baris, byte, label, rows\_pre\_filter. | | [SVL\_QUERY\_RINGKASAN](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_QUERY_SUMMARY.html) | **Kolom:** baris, byte, rows\_pre\_filter. | | [SVL\_S3LIST](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3LIST.html) | **Kolom:** ember, awalan, retrieved\_files, max\_file\_size, avg\_file\_size. | | [SVL\_S3LOG](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3LOG.html) | **Kolom:** pesan. | | [SVL\_S3PARTISI](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3PARTITION.html) | **Kolom:** baris, byte, label, rows\_pre\_filter. | | [SVL\_S3PARTITION\_RINGKASAN](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3PARTITION_SUMMARY.html) | **Kolom:** total\_partitions, qualified\_partitions, min\_assigned\_partitions, max\_assigned\_partitions, avg\_assigned\_partitions. | | [SVL\_S3QUERY](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3QUERY.html) | **Kolom:** external\_table\_name, file\_format, s3\_scanned\_rows, s3\_scanned\_bytes, s3query\_returned\_rows, s3query\_returned\_bytes, file. | | [SVL\_S3QUERY\_RINGKASAN](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3QUERY_SUMMARY.html) | **Kolom:** external\_table\_name, file\_format, s3\_scanned\_rows, s3\_scanned\_bytes, s3query\_returned\_rows, s3query\_returned\_bytes. | | [SVL\_S3REMENCOBA](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_S3RETRIES.html) | **Kolom:** file\_size, lokasi, pesan. | | [SVL\_SPECTRUM\_SCAN\_ERROR](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_SPECTRUM_SCAN_ERROR.html) | **Kolom:** lokasi, 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) | **Kolom:** jenis, teks. | | [SVL\_STORED\_PROC\_PANGGILAN](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_STORED_PROC_CALL.html) | **Kolom:** querytxt. | | [SVL\_STORED\_PROC\_MESSAGES](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_STORED_PROC_MESSAGES.html) | **Kolom:** pesan, linenum, querytext. | | [SVL\_UDF\_LOG](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_UDF_LOG.html) | **Kolom:** pesan, funcname. | | [SVV\_DISKUSAGE](https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_DISKUSAGE.html) | **Kolom:** nama, col, tbl, blocknum, num\_values, minvalue, maxvalue. | | [SVV\_QUERY\_STATE](https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_QUERY_STATE.html) | **Kolom:** baris, byte, label. | | [SVV\_TABLE\_INFO](https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_TABLE_INFO.html) | **Kolom:** table\_id, tabel. | | [SVV\_TRANSAKSI](https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_TRANSACTIONS.html) | **Kolom:** relasi. | Untuk informasi selengkapnya tentang tabel dan tampilan sistem, lihat [Referensi tabel dan tampilan sistem](https://docs.aws.amazon.com/redshift/latest/dg/cm_chap_system-tables.html) di Panduan *Pengembang Database Amazon Redshift*. *Untuk informasi tentang kemampuan Amazon Redshift untuk secara dinamis menutupi hasil kueri, lihat Penyembunyian [data dinamis](https://docs.aws.amazon.com/redshift/latest/dg/t_ddm.html) di Panduan Pengembang Database Amazon Redshift.* Untuk informasi tentang cara membuat tampilan dalam AWS Glue Data Catalog menggunakan Amazon Redshift, lihat [AWS Glue Data Catalog tampilan](https://docs.aws.amazon.com/redshift/latest/dg/data-catalog-views-overview.html) di Panduan Pengembang *Database Amazon Redshift*.