Tulsa TechFest 2018
Tulsa TechFest 2018

Querying Semistructured Data in Azure Data Lake with USQL

Start Time: Friday, July 20, 2018 10:45 AM
Querying csv files is easy using the ANSI standard USQL language on Azure Data Lakes.

Data is exploding across enterprises. Much of it is semi-structured junk. Or is it junk? What are you going to do with it until you can find out? Microsoft’s Azure Data Lake is a cloud storage and analytical service for parking a variety of data. When you are ready, you can query that semi-structured data using an ANSI SQL language called U-SQL. In this session I will demonstrate the similarities and differences between U-SQL and T-SQL. I will demonstrate how easy it is to build a query against 21 GB of CSV files. Such queries can help you determine whether you have a gold mine

Russ Loski, Microsoft Business Intelligence Developer, Baylor

RussLoski, Russ Loski

Russ Loski is a database and application developer working with Microsoft products. He has developed custom applications for a variety of businesses from the Dallas Cowboys to an alarm monitoring company. His specialty is developing ETL applications to move data into SQL Server as well as developing applications to communicate between legacy programs.

Currently Russ is contracting with Baylor, Scott and White, working with an external partner to populate their data warehouse.

Specialties: Database developer, technical trainer, web application developer, ETL developer