U-SQL Packages
Summary
A U-SQL package allows the bundling of commonly used constant declarations, assembly references and resource deployments in a single meta data object to make sharing and referencing easier.
U-SQL packages can be nested, and can encapsulate references to use or export to the caller/importer of the package.
Packages can be parameterized (e.g. for context or versioning).
The identifiers referenced inside a package definition will be resolved in the static context of the package definition, similarly to table-valued functions and procedures.
If conflicting assemblies or references are being referenced, imported or deployed, errors are raised once a package gets imported in the main U-SQL script.
Since packages are a meta data object they are subject to the database-level access control.
Note
No DDL is allowed inside a package (e.g. CREATE/ALTER/DROP .. etc).
Syntax
Package_DDL_Statement :=
Create_Package_Statement
| Drop_Package_Statement.
Import_Package_Statement :=
Import_Package_Statement.