Neil Palmer
My feedback
-
196 votesunder review · 9 comments · Azure Synapse Analytics » SQL/Table Structure · Flag idea as inappropriate… · Admin →
Neil Palmer supported this idea ·
-
65 votes
Neil Palmer supported this idea ·
-
49 votes
Neil Palmer supported this idea ·
-
126 votes
Neil Palmer supported this idea ·
-
38 votes
-
254 votes
Neil Palmer supported this idea ·
-
9 votesstarted · 0 comments · Azure Synapse Analytics » SQL/Management · Flag idea as inappropriate… · Admin →
Neil Palmer shared this idea ·
-
204 votes
An error occurred while saving the comment Neil Palmer supported this idea ·
-
189 votes
An error occurred while saving the comment Neil Palmer commented
I would love to be able to have a Tableau or Power BI model over the ADLA catalog. Whilst it may not be super speedy, it would suddenly open up ADLA as a warehouse solution that the business can easily use.
This would be especially useful for scenarios where reports are only viewed rarely, but may take lots of resource to run - this would save huge amounts of money on not having to run overnights, but run queries on demand. This would also allow us to get some of the features offered by rival solutions that can charge per query in an ansi sql environment.
Neil Palmer supported this idea ·
-
19 votes
Upvotes: 3
<=-=Jun 20 2017 11:49AM=-=>Greetings.
As it happens, I’m in the initial stages of designing just such a feature.
I would very much like to work with you to understand your needs, and see what options would or wouldn’t be helpful to you.
Thanks
Kevin Farlee kfarlee@microsoft.comNeil Palmer supported this idea ·
-
30 votes
Upvotes: 47
<=-=Jul 3 2014 10:03AM=-=>This would definitely be a good build. I walked through an initial investigation of clustered columnstore on one of our data sets, and the number of reads was reduced by about 80% for some queries in the workload once I started paying careful attention to segments and loading data in a single-threaded manner to optimize segment elimination. However, this results in slower loading of data, and it would be great to be able to create columnstore indexes in order for segment elimination.
Having an optional ORDER BY clause for the columnstore initial creation, removing the need to first create a clustered index in order to control order and allowing parallelism without breaking order, would be particularly powerful.
<=-=Jul 3 2014 10:30AM=-=>Neugebauer: thanks. you identified the issue correctly. This is something we are actively looking. One question
(1) once the index is build, the…Neil Palmer supported this idea ·
-
7 votes
Thank you for your request. This item is on our backlog. We will update the thread when the status changes.
Neil Palmer shared this idea ·
-
6,349 votes
Thank you for the strong feedback on this request. We are working on this and will share our plans for this offering soon. Thank you for your patience!
Aishwarya Manoharan
Program Manager, Azure storageNeil Palmer supported this idea ·
-
6 votes
Neil Palmer shared this idea ·
-
18 votesunder review · 1 comment · Azure Synapse Analytics » SQL/Performance · Flag idea as inappropriate… · Admin →
Neil Palmer supported this idea ·
-
98 votes
Just making sure folks have seen the recent Polybase work for loading data from ADL to SQL DW. https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure-data-lake-store and https://azure.microsoft.com/en-us/blog/sql-data-warehouse-now-supports-seamless-integration-with-azure-data-lake-store/
Thank you,
GuyAn error occurred while saving the comment Neil Palmer commented
Support for SQL DB would be great, as it would make it easier to use SQL DB as an interactive cache for job results.
being able to read directly from the catelog database, rather than having to output to a file would improve the process even more (some sort of elastic query connection from the SQL engines to ADLA??)
-
1,490 votesunplanned ·
AdminSQL Database feature voting forum admins (Product Owner, Microsoft Azure) responded
Not planned at this time. Will keep this item open for future review.
Neil Palmer supported this idea ·
-
2 votes
Neil Palmer shared this idea ·
-
25 votes
Neil Palmer shared this idea ·
-
5 votes
Neil Palmer shared this idea ·
Shouldn't this be updated to in progress / done?
I'm loving the support for ADLS in the latest version of azure storage explorer.
👍👍👍👍👍👍👍👍👍👍👍🎉🎉🎉