none
Use of internal database in ADLA

    Question

  • What is the use of the database in ADLA? Is it for internal use only or can I query it with for example Power BI or SSMS?

    Saturday, November 11, 2017 11:39 AM

All replies

  • Any one? Any use?
    Thursday, November 16, 2017 7:35 PM
  • The U-SQL Catalog is a container for reusing USQL objects and federated data sources and is queried using USQL from Data Lake Analytics jobs.

    SSMS is for SQL Server and SQL Data Warehouse and does not support Data Lake Analytics.
    Power BI can download ADLS files or query using HDI and Spark, however ADLA Catalog queries are not yet available.

    https://feedback.azure.com/forums/327234-data-lake/suggestions/11266677-support-interactive-workloads-within-adl-analytics

    cheers,

    Andrew


    Andrew Sears

    • Proposed as answer by Jorg KleinMVP Tuesday, November 28, 2017 8:08 AM
    Tuesday, November 28, 2017 3:31 AM