Specifies the application ID (a GUID string) for accessing the external storage system.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Categories: | Bulk Loading |
| Data Access | |
| Default: | none |
| Data source: | Microsoft SQL Server, Snowflake, Spark |
| Notes: | Support for Microsoft SQL Server was added in SAS 9.4M7. |
| Support for Snowflake and Spark was added in SAS 9.4M9. | |
| See: | BL_APPLICATIONID= data set 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, Bulk Loading to Azure Synapse Analytics.
Snowflake: This option is used to facilitate bulk loading or bulk unloading compressed Parquet files that are stored in an Azure ADLS location. For more information, see Bulk Loading and Bulk Unloading Data Files in Azure ADLS Locations.
Spark: This option is used when the Spark engine bulk loads or bulk unloads data in Databricks. For more information, see Bulk Loading and Bulk Unloading with the Spark Engine.