How to set a field to NULL using the Redshift Data API?

[JoseAngel1196]

Describe the issue

AWS indicates that you cannot set a value to NULL nor can you set a zero-length value. Is there a way to handle this using the Redshift Data API?

My code:

if value == "" {
				paramValue = "null"
			} else {
				paramValue = fmt.Sprintf("%v", value)
			}
			parameters = append(parameters, types.SqlParameter{
				Name:  aws.String(paramName),
				Value: aws.String(paramValue),
			})

As you can see, if the value is empty, we're using a literal string 'null' and would prefer to store it as NULL. How can I achieve this?

Links

https://docs.aws.amazon.com/redshift/latest/mgmt/data-api.html

AWS Go SDK V2 Module Versions Used

No response

[lucix-aws]

#2619

[github-actions]

This issue is now closed. Comments on closed issues are hard for our team to see.
If you need more assistance, please open a new issue that references this one.