Data Set Options for Amazon Redshift

For more information, see Data Set Options for Relational Databases.

SAS/ACCESS Data Set Options for Amazon Redshift
Option	Default Value
BL_AWS_CONFIG_FILE=	~/.aws/config
BL_AWS_CREDENTIALS_FILE=	~/.aws/credentials
BL_AWS_PROFILE_NAME=	none
BL_BUCKET=	none
BL_COMPRESS=	NO
BL_CONFIG=	none
BL_DEFAULT_DIR=	temporary file directory that is specified by the UTILLOC= system option
BL_DELETE_DATAFILE=	YES
BL_DELIMITER=	comma (‘,’)
BL_ENCKEY=	LIBNAME option value
BL_IAM_ASSUME_ROLE_ARN=	LIBNAME option value
BL_IAM_ASSUME_ROLE_NAME=	LIBNAME option value
BL_IAM_ROLE=	none
BL_KEY=	none
BL_NUM_DATAFILES=	2
BL_NUM_READ_THREADS=	LIBNAME option value
BL_OPTIONS=	none
BL_REGION=	none
BL_SECRET=	none
BL_TOKEN=	none
BL_USE_ESCAPE=	NO
BL_USE_MANIFEST=	YES
BL_USE_SSL=	YES
BULKLOAD=	NO
BULKUNLOAD=	LIBNAME option value
CURSOR_TYPE=	LIBNAME option value
DBCOMMIT=	LIBNAME option value
DBCONDITION=	none
DBCREATE_TABLE_OPTS=	LIBNAME option value
DBFORCE=	NO
DBGEN_NAME=	DBMS
DBLABEL=	NO
DBLARGETABLE=	none
DBMAX_TEXT=	1024
DBNULL=	YES
DBNULLKEYS=	LIBNAME option value
DBPROMPT=	LIBNAME option value
DBSASLABEL=	COMPAT
DBSASTYPE=	See Data Types for Amazon Redshift
DBTYPE=	See Data Types for Amazon Redshift
ERRLIMIT=	1
IGNORE_READ_ONLY_COLUMNS=	NO
INSERT_SQL=	LIBNAME option value
INSERTBUFF=	LIBNAME option value
KEYSET_SIZE=	LIBNAME option value
NULLCHAR=	SAS
NULLCHARVAL=	a blank character
POST_STMT_OPTS=	none
POST_TABLE_OPTS=	none
PRE_STMT_OPTS=	none
PRE_TABLE_OPTS=	none
PRESERVE_COL_NAMES=	LIBNAME option value
QUALIFIER=	LIBNAME option value
QUERY_TIMEOUT=	LIBNAME option value
READBUFF=	LIBNAME option value
READ_LOCK_TYPE=	ROW
SASDATEFMT=	none
SCHEMA=	LIBNAME option value
SUB_CHAR=	none
UPDATE_ISOLATION_LEVEL=	LIBNAME option value
UPDATE_LOCK_TYPE=	LIBNAME option value

Last updated: February 3, 2026