Specifies the application ID (a GUID string) for accessing the external storage system.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Access | |
| Default: | LIBNAME option value |
| Restriction: | The user ID that is used to authenticate must be assigned Contributor and Storage Blob Data Contributor roles in the ADLS account configuration. |
| Data source: | Microsoft SQL Server, Snowflake, Spark |
| Notes: | Support for this data set option was added in SAS 9.4M7. |
| Support for Snowflake and Spark was added in SAS 9.4M9. | |
| See: | BL_APPLICATIONID= LIBNAME option |
| Example: | bl_applicationid="b1fc955d5c-e0e2-45b3-a3cc-a1cf54120f" |
Table of Contents
specifies the application ID (a GUID string) for accessing the external storage system.
Microsoft SQL Server: This option is used when Microsoft SQL Server loads data to Azure Synapse Analytics (SQL DW) with a Microsoft Azure Data Lake Storage Gen2 storage account. For more information, see Bulk Loading to Azure Synapse Analytics.
Snowflake: This option is used to bulk load or bulk unload compressed Parquet files that are stored in an Azure ADLS location. For more information, see data set.
Spark: This option is used when the Spark engine bulk loads or bulk unloads data in Databricks on Azure with an Azure Data Lake Storage Gen2 storage account. For more information, see Bulk Loading and Unloading to Databricks in Azure.