BL_IDENTITY= Data Set Option

Specifies the authentication method for the COPY command.

Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Categories: Bulk Loading
Data Access
Default: LIBNAME option value
Interaction: The value for this option and the BL_SECRET= value are used for the CREDENTIAL argument with the COPY command with Azure Synapse Analytics (SQL DW).
Data source: Microsoft SQL Server
Note: Support for this data set option was added in SAS 9.4M7.
See: BL_IDENTITY= LIBNAME option, BL_SECRET= data set option
Example: bl_identity='Shared Access Signature'

Table of Contents

Syntax

BL_IDENTITY="identity-value"

Required Argument

identity-value

specifies the authentication method for the COPY command in Azure Synapse Analytics (SQL DW).

Details

The BL_IDENTITY= value is used as part of the CREDENTIAL argument that you specify for the COPY command in Azure Synapse Analytics (SQL DW). This functionality is supported when you are using an Azure Data Lake Gen2 account.

Last updated: February 3, 2026