I want to know if there is a way to achieve the same, but with unloading Operation. In other words, I want to know if there is a way to find out the current stage of the uninstall process.
For example, if the select statement must connect multiple tables and scan a large number of Table to generate the output, so even if the actual uninstallation part may not be the long part, it may take a long time.
So, I usually check the query execution steps in the AWS console to get a rough idea of where the uninstallation is. .
I also checked the S3 folder I want to uninstall to see if the files are still coming in. They are usually done in batches, so it can also give you an idea.
When loading data into an Amazon Redshift table, you can use the table STV_LOAD_STATE to check the loading status.
I want to know if there is a way to achieve the same, but with an unload operation. In other words, I want to know if there is a way to find out the current stage of the unloading process.
Unlike loading data into Redshift, unloading actually has to run a select statement Therefore, it cannot tell us the state at load time.
For example, if the select statement has to join multiple tables and scan a large number of tables to generate output, then even the actual unloading part may not be the long part , It may also take a long time.
Therefore, I usually check the query execution steps in the AWS console to get a rough idea of where to uninstall.
I also checked that I want to uninstall S3 folder to see if the files are still coming in. They are usually done in batches, so it can also give you an idea.