Data Set Options for Google BigQuery

All SAS/ACCESS data set options in this table are supported for Google BigQuery. Default values are provided where applicable. For details, see Data Set Options for Relational Databases.

SAS/ACCESS Data Set Options for Google BigQuery
Option	Default Value
BL_BUCKET=	none
BL_DEFAULT_DIR=	temporary file directory that is specified by the UTILLOC= system option
BL_DELETE_DATAFILE=	YES
BL_DELIMITER=	the bell character (ASCII 0x07)
BL_NUM_READ_THREADS=	LIBNAME option value
BULKLOAD=	LIBNAME option value
BULKUNLOAD=	LIBNAME option value
DBCONDITION=	none
DBCREATE_TABLE_OPTS=	LIBNAME option value
DBFORCE=	NO
DBGEN_NAME=	DBMS
DBLABEL=	NO
DBLARGETABLE=	NO
DBNULL=	none
DBSASTYPE=	see Data Types and Conversions for Google BigQuery
DBSLICE=	none
DBSLICEPARM=	none
DBTYPE=	see Data Types and Conversions for Google BigQuery
ERRLIMIT=	1
FETCH_NUMERIC_TYPE=	LIBNAME option value
IGNORE_FEDSQL_OBJECTS=	LIBNAME option value
INSERTBUFF=	LIBNAME option value
MODE=	LIBNAME option value
NULLCHAR=	SAS
NULLCHARVAL=	a blank character
QUALIFIER=	LIBNAME option value
READ_MODE=	LIBNAME option value
READBUFF=	LIBNAME option value
SASDATEFMT=	see Data Types and Conversions for Google BigQuery
SCANSTRINGCOLUMNS=	LIBNAME option value
SCHEMA=	LIBNAME option value

Last updated: February 3, 2026