Built-in U-SQL System Objects and Extensions

Summary

U-SQL offers a set of built-in system objects and allows customers to install some extension libraries that provide additional capabilities to U-SQL.

Built-in U-SQL System Objects

U-SQL provides a set of built-in catalog views that describe the content of the U-SQL Catalog for a specific Account and database. The catalog views are modelled after the SQL Server catalog views, but contain U-SQL specific information and live in the system-owned usql schema.

See Catalog Views (U-SQL) for a list of catalog views.

U-SQL Extensions

The Azure Data Lake Analytics service offers the ability to install a set of extension libraries that enables customers to perform additional processing beyond the core U-SQL language.

The extensions are installed from the Azure Data Lake Analytics Portal, and include the following capabilities:

• Scaling out Python scripts with U-SQL
• Scaling out R scripts with U-SQL
• Cognitive Capabilities in U-SQL

See Also

• Catalog Views (U-SQL)
• usql.objects (U-SQL)
• Data Definition Language (DDL) Statements (U-SQL)
• Registering Cognitive Extensions in U-SQL
• Extending U-SQL Expressions with User-Code
• Enabling U-SQL Advanced Analytics for Local Execution