Data Lake

You can use this set to communicate with the Azure Data Lake team. We are eager to hear your ideas, suggestions, or any other feedback that would help us improve the service to bet fit your needs.

If you have technical questions, please visit our forums.
If you are looking for tutorials and documentation, please visit http://aka.ms/AzureDataLake.

How can we improve Microsoft Azure Data Lake?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Data Explorer should allow to adjust the horizontal bar between the query and the result

    In the Query tab, there's a horizontal bar separating the script and the result. Currently, it's not possible to move the bar up or down. The ability to do that will offer a better user experience and having the same consistency with SSMS for instance.

    1 vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • add Azure Data Lake diagnostic log support to Azure log integrator

      We need to collect and forward Azure Data Lake diagnostic logs to our SIEM, which is not currently supported by Azure log integrator.

      1 vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • Add support for logging from USQL UDO code

        Add support for USQL UDO code to call logging API endpoints (e.g. API Insights).

        1 vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • 1 vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • delete source file once processed

            Once an input file has been processed, have a function that can delete the file if it sits on an ADLS source.

            1 vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • Provide Machine Learning Libraries (e.g. MicrosoftML) for Data Lake Analytics

              Provide Machine Learning Libraries (e.g. MicrosoftML) for Data Lake Analytics such as MLlib is available for Spark.

              5 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • Support SNAPPY compression and decompression

                SNAPPY is a fast compressor/decompressor from Google. See GitHub - google/snappy: A fast compressor/decompressor. SNAPPY is widely used for all Hadoop based big data projects. My customers need it. Please add ability for ADLA (U-SQL) to extract/read SNAPPY compressed files (Parquet/ORC) and ability to write/output SNAPPY compressed files (Parquet/ORC). Thanks in advance.

                1 vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • Add Data Lake and Data Lake Analytics to either Australia or Asia Pacific.

                  As of October 2017, the closest region is still US. There needs to something better serving the Asia Pacific regions - either one of the AU or AP regions.

                  3 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                  • Data Explorer should shows the number of children

                    And possibly, the breakdown by Files and Folder with an option "Show number of children recursively".
                    Thanks!

                    1 vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • Allow rowset variables to be converted to scalar values in USQL

                      I'm looking to make an output path string out of dates that are in an event-level table, so that the aggregate results can be saved and partitioned into paths according to their date.

                      It appears that when I'm selecting a date from a rowset, it cannot be converted into a scalar string and used as an output path..

                      2 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                      • large byte counts should be rendered in GB, TB and PB by default to improve readability/reduce errors

                        in viewing this vid i noticed that the byte counts are difficult to read (you end up counting all the decimal places to figure out what order magnitude you are looking at. Way too easy to mis-read your processing output.

                        For example:

                        23546789521 => 23.54TB | 2354GB

                        1 vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • pre-compilation for usql query with parameter pass

                          I've scenario that an usql query file is taking 10 min time in compilation. and that query I'm using again and again. so is there any way to precompile the query and just by a passing parameter I can use precompiled query again.

                          4 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • Allow C# UDF Function, pre-defined function and constant in JOIN Condition

                            select TableA.id FROM TableA LEFT JOIN TableB ON CustomUDF(TableA.id) == CustomUDF(TableB.id) ;

                            6 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • Add Local Run support for U-SQL Catalog Views

                              Now that U-SQL provides catalog views, please add them to the local run experience as well.

                              3 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • Increase timeout for "EXTERNAL DATA SOURCE"

                                Increase timeout for "EXTERNAL DATA SOURCE" as USQL queries fails sometime due to timeout or connectivity issue, we should be able to change this timeout value while creating the external data source in ADLA with a higher value then 30 seconds it is right now.

                                1 vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                • Support EXTRACTion of scientific notation to decimal type with built-in extractors

                                  Scientific notation can be extracted to float type with no extra effort, but decimal requires additional arguments to parse it. It would be nice to have this be less strict, and have the build-in extractors automatically extract scientific notation directly to decimal.

                                  1 vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • 3 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • USQL catalog - support IDENTITY or SEQUENCE

                                      In USQL managed table, we need column IDENTITY property similar to T-SQL or USQL catalog level SEQUENCE object.

                                      CREATE TABLE X
                                      (
                                      ID Int64 IDENTITY(1,1)
                                      )

                                      As a workaround we can use ROW_NUMBER(). But something like IDENTITY or SEQUENCE would mean we don't have to work out the next value.

                                      7 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Ability to compare Managed Tables between Environments

                                        As part of our deployment process, we would like to compare the schema of Azure Data Lake Analytics Managed Tables between two environments (e.g. DEV vs QA services). We would like to have something similar to what we use for SQL Database version comparison (we use Redgate SQL Compare or Visual Studio for that purpose). Visual Studio also provides the ability to compare database projects. We have the DDL for our Managed Tables in a USQL project and would also like to be able to compare USQL projects in the same way.

                                        1 vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Support for Soft/Sym- and Hard Links

                                          The support of Soft/Sym- and/or Hard Links would be great as it would help a lot to deal with scenarios where the same data has to be referenced multiple times in different locations without having to copy it. Especially for Big Data processing this is very valuable

                                          5 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 13 14
                                          • Don't see your idea?

                                          Feedback and Knowledge Base