Common Parameter: dataSourceOptions

Azure storage account name

Application ID for Azure storage

DNS Suffix for Azure storage

Azure storage file system

Azure storage operation timeout value in seconds

specifies the authentication domain that is used to retrieve database credentials.

specifies the Google Cloud Storage bucket to write data files

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies the default directory on the local node where data files are written. Defaults to SAS utility directory.

when set to TRUE (the default), all local data files as well as S3 objects are deleted after the COPY command completes.

specifies the path to a key file resource within a project

specifies the location to use in queries

specifies the maximum length for BINARY data types.

specifies the maximum length for CHAR and VARCHAR data types.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies an alternate project ID to be used in table references in SQL queries

specifies the number of rows to read in one read block.

specifies the read mode to use for loadTable

when set to TRUE, the data connector issues a query to scan all VARCHAR and VARBINARY columns for their max length.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the column to use for slicing the result set when using numReadNodes.

specifies the authentication domain that is used to retrieve database credentials.

specifies how data types are converted between the data source and data types for SAS Cloud Analytic Services.

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies a database SQL WHERE clause that is used for row filtering.

specifies to sort columns in ascending/descending order with a list of {0, 1, ...}

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies to sort the loaded table by orderby variable list

specifies to partition the loaded table

specifies the password.

specifies the number of rows to read in one read block.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies a name for the trace file.

specifies flags to use for tracing the database connection.

specifies the user name.

specifies the authentication domain that is used to retrieve database credentials.

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies the behavior when the data connector reads date values that are outside the valid SAS date range.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies the number of rows to read in one read block.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the column to use for slicing the result set when using numReadNodes.

specifies the name for a collection of data that is stored with a common encryption password.

specifies a password for encrypting or decrypting stored data.

specifies the OAuth authentication token.

specifies the password.

specifies the network port number that the server listens on.

specifies the host name of the SAS Event Stream Processing (ESP) server.

specifies the Kerberos service name.

specifies the user name to use for authenticating to the server.

specifies the authentication domain that is used to retrieve database credentials.

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies the number of rows to read in one read block.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the column to use for slicing the result set when using numReadNodes.

specifies the authentication domain that is used to retrieve database credentials.

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies the number of rows to read in one read block.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the column to use for slicing the result set when using numReadNodes.

specifies the authentication domain that is used to retrieve database credentials.

specifies the incoming data buffer size, in bytes.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies how data is transferred between the database and SAS Cloud Analytic Services.

specifies the maximum length for STRING data type columns. For Hive, this parameter does not apply to CHAR or VARCHAR columns.

specifies the path to an HDFS directory that contains XML-based table definitions, called SASHDMD descriptors.

specifies the Hadoop HDFS directory to use to store temporary data.

Specifies the login time-out in seconds for connecting to the data source.

specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

Specifies which hadoop platform to run on.

specifies the password.

specifies the number of rows to read in one read block.

specifies the name of the Hive schema.

specifies the Hive Schema/Database to use when creating temporary tables and views.

specifies the column to use for slicing the result set when using numReadNodes.

specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.

specifies the user name.

specifies the authentication domain that is used to retrieve database credentials.

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies the number of rows to read in one read block.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the column to use for slicing the result set when using numReadNodes.

specifies the name for a collection of data that is stored with a common encryption password.

specifies a password for encrypting or decrypting stored data.

specifies the authentication domain that is used to retrieve database credentials.

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies the client encoding type to use when connecting to the data source.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies the number of rows to read in one read block.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the column to use for slicing the result set when using numReadNodes.

specifies the authentication domain that is used to retrieve database credentials.

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies the maximum length for character data type columns.

specifies the number of seconds to wait for a connection attempt before returning an error.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies the number of seconds to wait for a query to finish executing before returning an error.

specifies the number of rows to read in one read block.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the column to use for slicing the result set when using numReadNodes.

specifies the authentication domain that is used to retrieve database credentials.

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies the maximum length for CHAR and VARCHAR data types.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies the number of rows to read in one read block.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the column to use for slicing the result set when using numReadNodes.

specifies the authentication domain that is used to retrieve database credentials.

specifies the scope to acquire a token for authorizing requests to the database

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies the number of rows to read in one read block.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the column to use for slicing the result set when using numReadNodes.

specifies the authentication domain that is used to retrieve database credentials.

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies the number of rows to read in one read block.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the column to use for slicing the result set when using numReadNodes.

specifies the authentication domain that is used to retrieve database credentials.

specifies the scope to acquire a token for authorizing requests to the database

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies the client encoding type to use when connecting to the data source.

specifies to override the default driver manager Unicode setting. DataDirect defaults to UTF-8 on UNIX. UnixODBC based drivers use UCS-2. Specify UCS2 for unixODBC based drivers.

specifies the behavior when the data connector reads date values that are outside the valid SAS date range.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies the number of rows to read in one read block.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the column to use for slicing the result set when using numReadNodes.

specifies the authentication domain that is used to retrieve database credentials.

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies the Oracle encoding type. Specify UNICODE if you use non-latin1 data.

specifies the number of rows to read in one read block.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the column to use for slicing the result set when using numReadNodes.

specifies the name for a collection of data that is stored with a common encryption password.

specifies a password for encrypting or decrypting stored data.

specifies the authentication domain that is used to retrieve database credentials.

specifies the scope to acquire a token for authorizing requests to the database

when set to TRUE, remove data and ctl files from disk after bulk unloading operation exits.

specifies a column delimiter for the data file. Either a single ASCII character or an octal sequence.

specifies the character that should appear before a data character that matches the QUOTE value for the data file Or turn it off

specifies the format for data file, CSV or TEXT. Default format is CSV.

specifies a column delimiter for the data file. Either a single ASCII character or an octal sequence.

specifies the full-path for the psql utility.

specifies the quoting character in data file.

when set to TRUE, use PostgreSQL utility to load data into CAS. Default to FALSE.

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies the client encoding type to use when connecting to the data source.

specifies the shared library searching path in LD_LIBRARY_PATH.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies the number of rows to read in one read block.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the column to use for slicing the result set when using numReadNodes.

specifies the authentication domain that is used to retrieve database credentials.

specifies the AWS configuration file if different from the default.

specifies the format for the data file, Delimited or Parquet. Default is Delimited.

specifies any additional COPY options that are added to the end of the COPY command.

specifies the S3 bucket name (and subdirectory, if applicable) to write data files.

when set to TRUE, data is read from Redshift from S3 data files created using the UNLOAD command.

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

when set to TRUE, use GZIP compression on data files.

specifies the AWS credentials file to use.

specifies the AWS profile name in the AWS credentials file to use if using an account with multiple profiles.

specifies the default directory on the local node where data files are written. Defaults to SAS utility directory.

when set to TRUE (the default), all local data files as well as S3 objects are deleted after the COPY command completes.

specifies a column delimiter for the data file. Either a single ASCII character or an octal sequence.

when set to TRUE, any restricted characters in string data are escaped to allow processing with COPY.

specifies an optional Amazon Resource Name (ARN) that identifies an IAM role. The associated IAM role enables you to get access credentials to S3 via the AssumeRole IAM operation.

specifies an optional AWS IAM role name that enables you to get access credentials to S3 via the AssumeRole IAM operation.

specifies an optional AWS IAM role to use for the COPY command instead of key/secret.

specifies the Amazon Web Services access key that is used with key-based access control.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies the AWS profile to use if using an account with multiple profiles.

specifies the number of rows to read in one read block.

specifies the Amazon Web Services region that the Redshift server resides for bulk-load.

specifies an optional S3 configuration file

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the Amazon Web Services secret access key that is used with key-based access control.

specifies the column to use for slicing the result set when using numReadNodes.

specifies a temporary token that is associated with the temporary credentials that you specify with the secret and key options.

when set to TRUE, create an SSL connection to S3 when transmitting data files.

specifies the name for a collection of data that is stored with a common encryption password.

specifies a password for encrypting or decrypting stored data.

specifies the AWS Key Management Services encryption context for the cryptographic operation.

specifies the AWS Key Management Services ID.

specifies an encryption key in the form of a 64-digit hexadecimal value.

specifies a plain-text version of the key to use with server-side encryption.

specifies the authentication domain that is used to retrieve database credentials.

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies the number of read buffers to use for the pipeline read.

specifies the number of rows to read in one read block.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the authentication domain that is used to retrieve database credentials.

specifies the scope to acquire a token for authorizing requests to the database

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies the client encoding type to use when connecting to the data source.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies the number of rows to read in one read block.

when set to TRUE, the data connector issues a query to scan all VARCHAR columns for their max length.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the column to use for slicing the result set when using numReadNodes.

specifies the authentication domain that is used to retrieve database credentials.

specifies the incoming data buffer size, in bytes.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies how data is transferred between the database and SAS Cloud Analytic Services.

specifies the maximum length for STRING data type columns. For Hive, this parameter does not apply to CHAR or VARCHAR columns.

specifies the path to an HDFS directory that contains XML-based table definitions, called SASHDMD descriptors.

specifies the Hadoop HDFS directory to use to store temporary data.

Specifies the login time-out in seconds for connecting to the data source.

specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies the password.

specifies the number of rows to read in one read block.

specifies the name of the Hive schema.

specifies the Hive Schema/Database to use when creating temporary tables and views.

specifies the column to use for slicing the result set when using numReadNodes.

specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.

specifies the user name.

specifies the password to use for Alter access.

specifies the authentication domain that is used to retrieve database credentials.

specifies the incoming data buffer size, in bytes.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies how data is transferred between the database and SAS Cloud Analytic Services.

specifies the type of encryption to be used on created SPDE tables.

specifies the passphrase used for an AES encrypted data set.

specifies the Hadoop HDFS directory to use to store temporary data.

specifies the master password to use for Read/Write/Alter access.

specifies the path where SPDE MDF are located.

specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

Specifies which hadoop platform to run on.

specifies the password.

specifies the password to use for Read access.

specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.

specifies the desired behavior when transcoding issues occur.

specifies the user name.

specifies the password to use for Write access.

specifies the authentication domain that is used to retrieve database credentials.

specifies the scope to acquire a token for authorizing requests to the database

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies the client encoding type to use when connecting to the data source.

specifies the behavior when the data connector reads date values that are outside the valid SAS date range.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies the number of rows to read in one read block.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the column to use for slicing the result set when using numReadNodes.

'INPLACEPREFERRED' to keep table in SingleStore, 'CASDISKCACHE' to load into CAS, 'INHERIT' to get from caslib

specifies the authentication domain that is used to retrieve database credentials.

specifies the incoming data buffer size, in bytes.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies connection options to use for connecting to the Teradata database.

specifies the Teradata database to connect to.

specifies how data is transferred between the database and SAS Cloud Analytic Services.

specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

Unused

specifies the number of rows to read in one read block.

Unused

specifies the column to use for slicing the result set when using numReadNodes.

specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.

specifies the user name.

specifies the authentication domain that is used to retrieve database credentials.

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies the client encoding type to use when connecting to the data source.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies the number of rows to read in one read block.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the column to use for slicing the result set when using numReadNodes.

specifies the authentication domain that is used to retrieve database credentials.

specifies the database catalog name.

specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.

specifies the client encoding type to use when connecting to the data source.

specifies the number of read buffers to use for the pipeline read.

specifies the number of grid nodes that will connect to and read data from the DBMS during a LoadTable action.

specifies the number of rows to read in one read block.

specifies the schema so that you can use to fully qualify objects in another database for SQL processing.

specifies the column to use for slicing the result set when using numReadNodes.