How get error from Send-RSDStatement?

[dburtsev]

Hello

How can one check if SQL statement fails?
Send-RSDStatement -Sql "INSERT INTO wrong_table_name (text1) VALUES ('qwe')"
This statement will fail because the table name is misspelled. No error was reported to my script.

Thanks,
Dmitriy

[dburtsev]

$QueryId = Send-RSDStatement ...
Start-Sleep -Seconds 1
[Amazon.RedshiftDataAPIService.Model.DescribeStatementResponse]$sqlResp = Get-RSDStatement -Id $QueryId ...
while ($sqlResp.Status.Value -notin ('ABORTED', 'FAILED', 'FINISHED'))
{
$sqlResp.Status.Value
Start-Sleep -Seconds 1
$sqlResp = Get-RSDStatement -Id $QueryId -AccessKey $Env:AWS_ACCESS_KEY_ID -SecretKey $Env:AWS_SECRET_ACCESS_KEY -SessionToken $Env:AWS_SESSION_TOKEN
}

if ($sqlResp.Status.Value -eq 'FINISHED') { "SQL execution OK" | Tee-Object -FilePath $logFile -Append }
else {( "SQL execution status is " + $sqlResp.Status.Value) | Tee-Object -FilePath $logFile -Append
$sqlResp.Error | Tee-Object -FilePath $logFile -Append
Write-Error 'SQL query fail'
}

[github-actions[bot]]

Hello! Reopening this discussion to make it searchable.