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
SYS_EXTERNAL_QUERY_ERROR
You can query the system view SYS_EXTERNAL_QUERY_ERROR to get information about Redshift Spectrum scan errors. SYS_EXTERNAL_QUERY_ERROR displays a sample of logged errors. The default is 10 entries per query.
SYS_EXTERNAL_QUERY_ERROR 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 |
---|---|---|
user_id | integer | The identifier of the user that generated this row. |
query_id | bigint | The query identifier of the query that generated this row. |
file_location | char(256) | The location of the data being queried. |
rowid | char(2100) | The location of the error within the file. The
rowid parts are separated with a :
(colon) and additional parts might be added in the future.
A row_offset is the offset (in bytes) of the row within the file and is set to -1 for unsupported file formats. A table is
divided into row_groups, and each group has rows with distinct
row_ids. |
column_name | char(127) | The name of the column returned by the query. |
original_value | char(1024) | Original value queried. |
modified_value | char(1024) | Modified value returned based on the data handling configuration option specified in the query. |
trigger | char(128) | Data handling option specified in the query. |
action | char(128) | Action associated with the data handling option specified in the query. |
action_value | char(128) | Value of action parameter associated with the data handling option specified in the query. |
error_code | integer | Result code of the data handling option specified in the query. |
Sample query
The following query returns the list of rows for which data handling operations were performed.
SELECT * FROM sys_external_query_error;
The query returns results similar to the following.
user_id query_id file_location rowid column_name original_value modified_value trigger action action_value error_code
100 1574007 s3://spectrum-uddh/league/spi_global_rankings.0:0 league_name Barclays Premier League Barclays Premier Lea UNSPECIFIED TRUNCATE 156
100 1574007 s3://spectrum-uddh/league/spi_global_rankings.0:0 league_nspi 34595 32767 UNSPECIFIED OVERFLOW_VALUE 199
100 1574007 s3://spectrum-uddh/league/spi_global_rankings.0:1 league_nspi 34151 32767 UNSPECIFIED OVERFLOW_VALUE 199
100 1574007 s3://spectrum-uddh/league/spi_global_rankings.0:2 league_name Barclays Premier League Barclays Premier Lea UNSPECIFIED TRUNCATE 156
100 1574007 s3://spectrum-uddh/league/spi_global_rankings.0:2 league_nspi 33223 32767 UNSPECIFIED OVERFLOW_VALUE 199
100 1574007 s3://spectrum-uddh/league/spi_global_rankings.0:3 league_name Barclays Premier League Barclays Premier Lea UNSPECIFIED TRUNCATE 156
100 1574007 s3://spectrum-uddh/league/spi_global_rankings.0:3 league_nspi 32808 32767 UNSPECIFIED OVERFLOW_VALUE 199
100 1574007 s3://spectrum-uddh/league/spi_global_rankings.0:4 league_nspi 32790 32767 UNSPECIFIED OVERFLOW_VALUE 199
100 1574007 s3://spectrum-uddh/league/spi_global_rankings.0:5 league_name Spanish Primera Division Spanish Primera Divi UNSPECIFIED TRUNCATE 156
100 1574007 s3://spectrum-uddh/league/spi_global_rankings.0:6 league_name Spanish Primera Division Spanish Primera Divi UNSPECIFIED TRUNCATE 156