io_config.yaml
.default
(you can
have multiple profiles, add it under whichever is relevant to you)When connecting to Redshift Serverless, you can use workgroup-name.account-number.aws-region.redshift-serverless.amazonaws.com
as the REDSHIFT_HOST
value.
SQL
.Data provider
dropdown, select Redshift
.Profile
dropdown, select default
(or the profile you added
credentials underneath).Save to schema
label, enter the schema name you want this block
to save data to.Write policy
dropdown, select Replace
or Append
(please see
SQL blocks guide
for more information on write policies).SELECT 1
.Generic (no template)
.config_profile
from default
if
you have a different profile):To overwrite a column type when running a python export block, simply specify the column name and type in the overwrite_types
dict in data exporter config
Here is an example code snippet: