Data Connector Options Listed Alphabetically
|
Name
|
Syntax and Description
|
|---|---|
|
ccountName="string"
specifies the account for accessing an external
storage system.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
aggregatePushdown=true | false
specifies whether to push down aggregation requests to the
database.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
allow_unquoted_names=TRUE | FALSE
specifies whether table and column names are passed to your data source
without enclosing them in quotation marks.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
allowLargeResults=ALWAYS | MUST | OFF
specifies whether to allow query results larger
than the Google BigQuery maximum response size.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
allowSelfSignedCerts="NO | YES"
enables or disables wire encryption using self-signed
certificates.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
alter="password"
specifies the password to access and delete a password-protected
data set.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
alterPW="password"
specifies the password to access, modify, or delete
a password-protected data set.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
append=TRUE | FALSE
specifies whether to append data from CAS to an existing database
table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
applicationId="string"
specifies the application ID (a GUID string) for
accessing the external storage system.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
auth=AUTO | KERBEROS | LDAP | OAUTH2 | PASSWORD
specifies the authorization method that is used
to authenticate to an external data source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
authEndpoint="value"
specifies the authorization endpoint to use.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
authenticationDomain="domain"
specifies the name of the authentication domain
that contains credentials (userName= and password=) that are used
to access a data source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
authenticationScope="scope"
specifies the Microsoft Azure resource and permissions
that are required for authorizing access.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
authScope="scope"
specifies the Microsoft Azure resource and permissions that are required for
authorizing access.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
authType=LDAP
authenticationType=AUTO | OAUTH2 | PASSWORD
specifies the authentication method to use when connecting to your data
source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
awsConfig="path-and-AWS-configuration-file-name"
specifies the location of the Amazon Web Services
(AWS) configuration file.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
azureSAS="value"
specifies the Azure shared access signature token.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
backingStore="CASDISKCACHE" | "INPLACEPREFERRED"
specifies to load the data into CAS or to keep the table in
SingleStore.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
baseDir="path-to-installation-directory"
specifies the path to the MySQL installation directory.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blAllowReadAccess=TRUE | FALSE
specifies whether the original table data is still visible to readers during bulk
loading.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blCopyLocation=<'>path<'>
specifies the directory in which SAS saves a copy of the loaded
data.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blCpuParallelism=value
specifies the number of processes or threads to use when building table
objects.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blDataBufferSize="value"
specifies the amount of memory to allocate as a buffer for the bulk-load
utility.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blDbaccessPath='path'
specifies the full path to the bulk-loading utility.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blDefaultDir='path'
specifies the location where temporary data files are
stored.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blDelDatFile=TRUE | FALSE
specifies whether to delete only the data file or all files that the data
connector creates for the bulk-loading or bulk-unloading facility.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blDelimiter='single-character'
specifies an override for the default delimiter character during bulk loading or
bulk data retrieval (unloading).
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blDiskParallelism=processes
specifies the number of processes or threads to use when writing data to a data
source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blEnableLog=TRUE | FALSE
specifies whether to generate a log file for the bulk-load
utility.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blEscape='single-character' | 'OFF'
specifies the single-byte character to use for escape
sequences for CSV files.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blExceptionTable="table-name"
specifies the exception table into which rows in error are
copied.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blFormat="DELIMITED" | "PARQUET"
blFormat="DELIMITED"
blFormat="TEXT" | "CSV"
specifies the format of the external table data:
plain text (TEXT) or comma-separated values (CSV).
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blIndexingMode=AUTOSELECT | REBUILD | INCREMENTAL | DEFERRED
specifies the indexing scheme that the bulk-loading utility uses for index
maintenance.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blLoadReplace=TRUE | FALSE
specifies whether the bulk-loading process replaces all rows in a table during
bulk loading.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blLog="path-and-log-file-name"
specifies the name and location of a log file that contains information for bulk
loading.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blLogDir='path'
specifies the location of the log file for the bulk-loading
utility.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blNfxSdkPath="value"
specifies the installation path of the Informix client SDK.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blNull='\N' | empty-value
specifies the string that represents a null value.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blNumDataFiles=value
specifies the number of data files to create to contain the source
data.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blNumReadThreads=value
specifies the number of threads to use for bulk loading data from the data
source into the SAS Viya platform.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blobThreshold=value
specifies whether to allocate memory for large-object (LOB) columns based on the
maximum length of those columns.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blOptions="option-1<, option-2<, ...>>"
specifies options to pass to the bulk-load or bulk-unload
facility.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blPortMax=integer
specifies the highest available port number for concurrent
uploads.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blPortMin=integer
specifies the lowest available port number for concurrent
uploads.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blPSQLpath=<'>path-name<'>
specifies the full path to the PSQL executable file.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blQuote='single-character'
specifies the quotation character for CSV files.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blRecoverable=TRUE | FALSE
specifies whether a bulk-loading process is recoverable.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blRemoteFile=<'>path<'>
specifies the location of temporary files that are created by the bulk-loading
utility.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blWarningCount=value
specifies the maximum number of row warnings to allow before a load
fails.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
blWriteBuff=value
specifies the number of rows to buffer in memory before writing to your data
source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
branded_driver="driver-name"
specifies the type of driver that you are using
with the Greenplum data connector.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
bucket="bucket-name"
specifies the name of the cloud platform bucket to use when transferring data in
bulk.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
bufferSize=bytes | "nB" | "nK" | "nM" | "nG" | "nT"
specifies the buffer size that is used to send data
to or receive data from SAS embedded processes.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
bulk_api=YES | NO
specifies whether to use bulk loading to insert
a large number of rows from CAS into an external table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
bulk_refresh=value
specifies how often, in milliseconds, bulk load
requests are checked for completion.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
bulk_timout=value
specifies the timeout period for bulk-load operations
in milliseconds.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
bulkLoad=TRUE | FALSE
specifies whether to use bulk loading to insert
a large number of rows from CAS into an external table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
bulkUnload=TRUE | FALSE
specifies whether to retrieve (fetch) a large number
of rows from an external table into CAS.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
catalog="catalog-name"
catalog="*"
specifies a logical catalog name.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
charMultiplier=value
specifies the number of bytes per character of fixed-byte-width
character columns.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
class="class-name"
specifies the JDBC driver class name.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
classPath="directory-path"
specifies additional resources, including JDBC drivers or XML files, to add to
the JDBC class path.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
client_encoding="encoding"
specifies the encoding that the data source client
uses to transmit CHAR and VARCHAR data.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
client_id="ID-value"
specifies the client ID value for the OAuth client that is used to connect to
Google BigQuery.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
client_secret=authentication-secret
specifies the client secret value for the OAuth client that is used to connect to
Google BigQuery.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
clientDir="directory"
specifies the location that contains the data files for bulk
loading.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
clusterId="cluster-ID"
specifies the cluster ID for a connection.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
compress=TRUE | FALSE
compress="YES" | "NO" | "ZLIB"
compress="YES" | "NO" | "BINARY" | "CHAR"
specifies whether to compress data or specifies the compression method to use
when you save an in-memory table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
connectionTypeForCreate="fedsql" | "native"
specifies whether to use data types from PROC FEDSQL or from those that are
native to your data source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
conOpts="connection-options"
specifies optional connection options that you pass to the
DBMS.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
createMultipassColumn="onDemand" | "onLoad"
specifies when to create the multipass column for
multipass processing.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
createViewSnapshot="onLoad" | "never"
specifies whether to stream a view or create a
snapshot copy of a view result set.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
credentialsFile="path-and-filename"
specifies the path and name of the AWS credentials
file to use for bulk loading data.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
credentialsProfile="profile-name"
specifies the profile name to use when there is
more than one profile in the AWS credentials file.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
credFile='path-and-file-name'
specifies the path and name of the Google Cloud
Platform credentials file.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
database="database-name"
specifies the name of the database.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
dataPath="DPF-file-path"
specifies the location in which to store the DPF
files for the SPD Engine table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
dataSource_dsn="datasource-name"
specifies the data source name that you are accessing with the SAS Viya platform.
The name of this option is specific to your data source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
specifies the mode of data transfer.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
dbCreateTableOpts="text"
specifies any table options that should be appended
to a CREATE TABLE statement that is passed to the data source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
dbMaxText=maximum-string-column-length
specifies the maximum length for all string data
types.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
dbType="column1=<'>data-type1<'>
<column2=<'>data-type2<'>...>"
specifies alternative data types for specified columns.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
default_auth_plugin="caching_sha2_password" | "mysql_native_password"
specifies the authentication plugin to use when
you connect to a MySQL compatible data source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
defaultDir="directory-path"
specifies where all temporary files are created
during bulk loading or bulk unloading.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
deleteDataFiles=TRUE | FALSE
specifies whether to delete only the data file or all files that are created
during bulk loading or bulk unloading.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
delimiter="character"
specifies a character that separates columns of
data during bulk loading to or bulk unloading from your data source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
dispatchMethod=STANDARD | OOZIE
specifies how to submit a SAS Embedded Process job.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
dm_unicode="Unicode-setting"
specifies the Unicode encoding for the driver manager.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
dnsSuffix="network-storage-host-name"
specifies the network host name where the storage
system resides.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
driver_vendor="SAS" | "DATADIRECT" | "AMAZON"
specifies the name of the third-party vendor that
supports the Amazon Redshift driver.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
driverClass='driver'
specifies the fully-qualified class name of a JDBC driver.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
dsn="data-source-name"
specifies an ODBC data source name (DSN) that is defined by the SAS Federation
Server administrator.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
enable_cleartextPlugin=TRUE | FALSE
specifies whether to enable the Cleartext plugin
for authentication.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
encoding="encoding"
specifies the encoding for a data set.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
encrypt="YES" | "NO" | "AES" | "AES2"
specifies the form of encryption to use to access
a table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
encryptionPassword="passphrase"
specifies a passphrase to use for a data set or
SPD Engine table that is encrypted using Advanced Encryption Standard
(AES).
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
epDatabase="database-name"
specifies the name of the metadata database for SAS Embedded
Process.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
epProperties={properties}
passes properties to the SAS Embedded Process for
SingleStore.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
escape=TRUE | FALSE
specifies whether to escape a predefined set of
special characters when you bulk load data to your cloud data source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
fileSystem="file-system-name"
specifies the name of the file system within the external storage system that
files are written to.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
fileType="ORC"
fileType="DTA" | "EXCEL" | "JMP" | "SPSS" | "XLS"
fileType="BASESAS"
specifies the file type.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
folder="file-path-and-folder"
specifies the folder or file path for the data in
the external storage system.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
getNames=TRUE | FALSE
specifies whether to retrieve variable names from
the first line of an input file.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
getSheetNames=TRUE | FALSE
specifies whether to create a CAS table with a list
of all sheet names in an Excel workbook.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
hadoopConfigDir="configuration-files-directory"
specifies a location for Hadoop configuration files.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
hadoopJarPath="JAR-files-path"
specifies one or more paths to the JAR files.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
hdfs=TRUE | FALSE
specifies whether SPD Engine file data is in HDFS.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
hdfsTempDir="Hadoop-HDFS-temporary-directory"
specifies the Hadoop HDFS directory to use to store
temporary data.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
host="host-name"
specifies the host name.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
httpPath="http-path"
specifies the HTTP or HTTPS endpoint for a connection.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
iamAssumeRoleARN="ARN-value"
specifies an Amazon Resource Name (ARN) that identifies
an IAM role.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
iamAssumeRoleName="IAM-role-name"
specifies an AWS IAM role name that enables you
to get access credentials for S3 via the AssumeRole IAM operation.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
identity="identity-value"
specifies the authentication method for the COPY
INTO command.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
ignoreFedSQLObjects=TRUE | FALSE
specifies whether to ignore FedSQL objects in a library
query.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
insertBuff=number-of-rows
specifies the number of rows per block of data to
save to a table in the data source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
insertSQL=TRUE | FALSE
specifies whether to use a parameterized INSERT SQL statement to write
data.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
instance="number"
specifies the SAP HANA port instance.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
invalidDate="ERROR" | "SILENT" | "WARN"
specifies how to treat invalid date values when
loading DATE or DATETIME values.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
jobManagementURL="rest-URL"
specifies the URL to use to submit execution requests
over a REST interface.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
key="value"
specifies the Amazon Web Services access key that
is used with key-based access control.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
krbAuthType=integer
Specifies how to obtain the subject for Kerberos
authentication.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
krbHostFQDN="domain-name"
Specifies the fully qualified domain name of the Hive server for Kerberos
authentication.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
krbRealm="realm-name"
Specifies the Kerberos realm for authentication.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
krbServiceName="service-name"
Specifies the service principal name of the Hive server for Kerberos
authentication.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
label="label-name"
specifies a label name for the created SPD Engine
table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
largeResultsDataSet=BigQuery-data-set-ID
specifies a data set ID that stores query results.
If the specified data set ID does not exist, then it is created.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
largeResultsExpirationTime=value
specifies the time, in milliseconds, until a temporary
table is deleted.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
largeResultsProject=project-ID
specifies a project ID that stores query results.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
ldPath=<'>LD-library-path<'>
specifies a full path to append to the existing
LD_LIBRARY_PATH value for your system.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
login_timeout=seconds
specifies the login time limit, in seconds, for
connecting to and accessing data sources.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
mapReduceJobName="name"
specifies the MapReduce job name.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
mapReduceJobQueueName="name"
specifies the MapReduce queue name.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
masterPW="password"
specifies the password to access, delete, modify,
read, or save a password-protected SPD Engine table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
max_char_len=value
specifies the maximum column width.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
max_string_size=NONE | EXTENDED | STANDARD
specifies whether to override string limits that are returned via
Oracle.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
maxErrors=number
specifies the maximum number of rows that can be
rejected before the bulk-loading process ends.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
maxLoadThreads=maximum-number-of-threads
specifies the maximum number of threads to use per
worker node.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
maxSaveThreads=maximum-number-of-threads
specifies the maximum number of threads to use per
worker node when you write data to the data source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
mdfPath="MDF-file-directory"
specifies the HDFS or local disk directory that
contains the SPD Engine MDF file.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
mode="STANDARD" | "PERFORMANCE"
specifies whether to enable multiple performance-related
options.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
multipassMemory="cache" | "stream"
specifies whether to use a temporary memory cache for multipass
processing.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
mutual_auth=YES | NO
specifies whether to enforce mutual authentication.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
numReadBuffers=number
specifies the number of buffers that the data connector
is to read and convert from the data source to CAS.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
numReadNodes=number
specifies the number of CAS worker nodes to use
for a multinode load of data into CAS.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
numWriteBuffers=number
specifies the number of buffers that the data connector
uses to write and convert data from CAS to the data source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
numWriteNodes=number
specifies the number of CAS worker nodes to use
for a multinode save of data from CAS into a data source table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
ora_encoding="encoding-name"
specifies the encoding of the data in the Oracle
database.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
padCompress=number
specifies the amount of padding to add when you
use the compress= option.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
partSize=number
specifies the size of partitions to use for a SPD
Engine table when it is created by using the SAVE statement in PROC
CASUTIL.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
password="password"
specifies the data source password for a user.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
path="input-data-specifics"
specifies a SAS data set name, a PC files source
table, or an Oracle driver, node, and database.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
platform="spark"
platform="atlas"
platform=databricks | hdinsightsparkllap | spark | synapse
specifies the platform that applies to a data source
connection.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
pointObs="YES" | "NO"
specifies whether to locate a data set by returning
an observation (Obs) number from a subset of observations.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
port=port-value
specifies the port value to use to connect to a
data source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
post_table_opts="option-string"
specifies additional database-specific options to
be placed after the table name when creating a table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
pre_table_opts="option-string"
specifies additional database-specific options to
be placed before the table name when creating a table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
profile="profile-name"
specifies the profile to use when there is more
than one profile in the AWS configuration file.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
project="project-ID"
specifies the project ID for a Google BigQuery project.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
properties="JDBC-properties-value"
specifies additional driver-specific JDBC connection properties that will be added
to the generated JDBC URL.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
proxy="proxy-server"
specifies the URL of a proxy server that is used
to connect to Google BigQuery.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
proxy_host="host-name"
specifies the host name or IP address of a proxy
server.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
proxy_pass="value"
specifies the password that is associated with proxy_user=.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
proxy_port="port-number"
specifies the port number of the proxy server.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
proxy_user="user-id"
specifies the user ID that is used to access the
proxy server.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
query_tag="string"
specifies an optional string that you can use to tag queries to your data
source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
query_timeout=seconds
specifies the amount of time in seconds to wait
for a query response.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
range="cell-range"
specifies the range of data (a subset of cells)
within a worksheet to import.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
read="password"
specifies the password to access and read a password-protected
data set.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
readBuff=number
specifies the number of rows to fetch per block
of data retrieved.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
readMode=STANDARD | STORAGE
specifies the method to use when moving data from
Google BigQuery into CAS.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
readPW="password"
specifies the password to access and read a password-protected
SPD Engine table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
refresh_token="token-value"
specifies the refresh token value for the OAuth
client that is used to connect to Google BigQuery using the OAuth
authentication method.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
region="region"
specifies the AWS region for Amazon S3 data.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
remoteDriverOptions="options"
specifies the driver options for the REMFS driver,
which is used to connect to SAS Federation Server.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
replace=TRUE | FALSE
specifies that a new file with a given name replaces
an existing file with the same name.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
reuse="YES" | "NO"
specifies whether to write new rows to freed space
in a compressed data set.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
role=<">name<">
specifies a the role name to use when connecting to a data
source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
s3Config="path-and-configuration-file-name"
specifies the location of a local configuration
file for Amazon S3.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
saveMultipassColumn=TRUE | FALSE
specifies to create a multipass column when a table is
saved.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
scanStringColumns=TRUE | FALSE
specifies whether to scan all VARCHAR or long type columns in a table to determine
the actual maximum length of the columns.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
schema="schema-name"
specifies the schema name to use for the connection
to a data source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
schema_auth=AUTO | KERBEROS | LDAP | PASSWORD
specifies the authorization method that is used
to access a MongoDB schema.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
schema_collection='collection-name'
specifies that a connection to a MongoDB schema
should reference the stored schema file for the specified collection.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
schema_db="database-name"
specifies the MongoDB database where a schema is
stored.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
schema_password='string'
specifies the password to use to access a schema.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
schema_platform="atlas"
specifies the platform that applies to a connection
to a MongoDB schema.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
schema_port=value
specifies the port to use to access a schema.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
schema_server=<'>server-name<'>
specifies the server name or IP address of the server
that stores the schema mapping.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
schema_ssl_ca="path-and-file-name"
specifies the full path name to the certificate
authority file for the MongoDB schema location.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
schema_ssl_cert="path-and-file-name"
specifies the full path name to the certificate
file for the MongoDB schema location.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
schema_uid='user-ID'
specifies the user ID to use to access a schema.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
scratchDb="Hive-schema-name"
specifies the Hive database to use when creating
temporary tables and views.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
secret="secret-access-key"
specifies the secret access key or temporary secret
access key that is used to transfer data in bulk.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
server="server-identifier"
server="server-identifier:port"
specifies the server identifier for the data source
server.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
serverDir="location"
specifies the location that contains the data files for bulk loading or bulk
unloading.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
sheet="worksheet-name"
specifies the name of a worksheet within an Excel
file to import.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
show_metadata=YES | NO
specifies whether to display metadata tables and
columns.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
show_recycled=YES | NO
specifies whether to display deleted table rows
in the recycle bin.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
sliceColumn="column-name"
specifies the column to use when partitioning data
for a multinode data Read.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
sliceExpressions=("expression-1",
"expression-2", ...)
specifies expressions that partition your data for
multinode loading into CAS.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
socket="file-name"
specifies the path and file name of the socket file
that listens for connections to MySQL.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
srcType="data-source-type"
specifies the type of data source that you are connecting
to.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
ssl_ca="path-and-file-name"
specifies the full path to the certificate authority
file to use to access an external data source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
ssl_cert="path-and-file-name"
specifies the full path to the client public key certificate
file.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
ssl_cipher="cipher-list"
specifies a list of ciphers that are permitted to
be used for encryption.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
ssl_key="key-file-path"
specifies the path to the client private key file.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
sslKeyStore="file-path"
Specifies the path to the keystore file.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
sslKeyStorePwd="password-value"
Specifies the password for accessing the keystore file.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
sslMode=allow | disable | prefer | require | verify-ca | verify-full
specifies the support mode for a TLS encrypted connection
to your data source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
sslTrustStore="path"
specifies the path to a Transport Layer Security trust
store.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
statusInterval=number
specifies whether to print a message to the client
when a node adds n buffers
to the table by a node, where n is
the value of this option.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
table_qualifier="qualifier"
specifies a table qualifier when you require a value
other than the default project qualifier.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
tableType="ROW" | "COLUMN"
specifies the format type of the SAP HANA table
to return.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
tezQueueName="name"
specifies an Apache Tez queue name in which to execute client
requests.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
threadedLoad=TRUE | FALSE
specifies whether to use multiple threads to load data into
CAS.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
timeout=seconds
specifies the maximum completion time in seconds
for a storage task.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
token="temporary-token"
specifies a temporary token that is associated with
the temporary credentials that you specify with the key= and secret=
options.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
trustStorePassword="password"
specifies the password for the Transport Layer Security
truststore.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
udfDatabase="database-name"
specifies the location of user-defined aggregate functions for statistics
pushdown.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
uri='JDBC-URL'
specifies a free-form JDBC URL to use as the Hive or Spark JDBC connection
URI.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
url="jdbc:driver-name://driver-connection-options"
specifies the JDBC connection string.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
use_information_schema=TRUE | FALSE
specifies whether to use INFORMATION_SCHEMA in Google BigQuery to retrieve a list
of schemas and tables or views.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
use_native_names=YES | NO
specifies whether to restore native naming conventions
for custom tables and columns.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
useLog=TRUE | FALSE
specifies whether to receive a report of rejected
rows and corresponding error messages.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
useNarrowCharacterTypes=TRUE | FALSE
specifies whether to use narrow character types,
such as CHAR or VARCHAR, for all character variables when writing
data to the data source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
usePipe=TRUE | FALSE
specifies whether to use a pipe file to facilitate bulk
loading.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
userName="user-name"
specifies the data source user name.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
useSSL=TRUE | FALSE
specifies whether to use Transport Layer Security (TLS) to provide encryption for
connections.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
varcharConversion=column-length
specifies the column length at which to begin converting
CHAR to VARCHAR.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
warehouse="name"
specifies the Snowflake warehouse to use for connections to your data
source.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
webHdfsUrl="web-HDFS-URL"
specifies the URL to use to access the Hadoop distributed
file system (HDFS) through a REST API.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
write="password"
specifies the password to access and save a password-protected
data set.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
writePW="password"
specifies the password to access and save a password-protected
SPD Engine table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
zooKeeperNamespace="namespace"
specifies the ZooKeeper namespace.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
zooKeeperPort="port-number"
specifies the ZooKeeper port number.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
zooKeeperQuorum="nodes"
specifies the server nodes that are available to run client
requests.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
|
Last updated: July 17, 2025