Add code formatting feature to the editor, similar to VS Code or Azure Data Studio.1 vote
SQL DW and SQL DB should have password expiry option.
As of now password never expires. Please implement password expiry.
It is one of the compliance requirement in Philips.1 vote
SQL Server Management Studio shows a folder for Database Scoped Credentials in case of an SQL Database but not in case of SQL Data Warehouse.1 vote
I would like to be able to do full back ups more frequently than once a day.1 vote
We should have report on Azure portal which shows performance level of ADW or Azure Database with respect to time stamp and Cost incurred for that period.
With this report we should get cost incurred for a particular instance and duration the instance was in different performance level for a period.
This helps in financial planning for future depending upon the trend of cost incurred for that instance.1 vote
We should need a exception of fire wall rule that allows accessing from trusted Azure Service same as Storage Account.1 vote
How to extend the backup retention period to 35 days from 7 days for our SQL DW / MS product group team could you please help on this1 vote
Full and simple integration between azure Datalake and azure DW with the notebooks running in any VM machine, Linux or Windows.
Full and simple integration between azure Datalake and azure DW with the notebooks. Support for commom database connection drivers like pyodbc. And the most import, simple way to use Azure Active Directory log in to DW and Data Lake using Windows or Linux VM !1 vote
We would like to synapse to support also unloading data using copy into statement. This is supported in Snowflake and Redshift.
Can you add Azure SQL Data Warehouse as one target and Azure SQL Database as one source in Microsoft Database Migration Assistant software?1 vote
It would be nice to be able to use T- SQL syntax such as OPENROWSET etc. in SSMS or Azure Data Studio to query Azure Data Lake Storage files.1 vote
External file formats with UTF-16 encoding are not obeying the USETYPEDEFAULT= FALSE logic and are converting NULL marks in flat files to USETYPEDEFAULT = TRUE logic. There appears to be some kind of implicit conversion to UTF-8 causing NULL marks to no longer correctly appear.1 vote
can you please included dynamic folder names(.I.E wild cards)1 vote
This has been now renamed to Azure Synapse Analytics. I see a surprising change in pricing. Compute cost of all Gen 2 services is same irrespective of the configuration. e.g. - DW100c costs same as DW30000c
Either someone messed up with the site while pushing updates or there is some reasoning behind it which I cannot comprehend. Can some one advise why is that happening? Screenshot attached for reference1 vote
label query not working in sqldw
SELECT * FROM sys.dmexecrequests r WHERE r.[label] = 'My Query Label' ; (is it correct sql documented in label)1 vote
Polybase does not evaluate datatypes for queries at table level like "select count()". When a numeric field contains alpha numeric data the record is not rejected when you use "select count()", but it is when you use "select *". It will be great when this is consistent.1 vote
There is no counter part to the system function sys.fngetaudit_file (Azure and on premise SQL Server) in ADW. Please enable it to read audit files in ADW.1 vote
Provide ActiveQueryCount as a result output under .properties for the REST API database state parameter.
Currently in order to use the error file functionality CSV format must be used.
The main issue is that using other formats like parquet, ORC, etc. no detailed information about load errors can be captured (row #, column #, exact values). In most of these scenarios the error message returned is also too generic to even guess the row/column causing issues.
The standard suggestions to convert to CSV makes debugging data load issues complex because changing the file format actually can eliminate the underlying issues, or in some cases introduce new issues, because the formats are treated differently.1 vote
It will be nice if we can access ADLA catalogs using Polybase , we can theoretically eliminate the process of ELT . Please share your thoughts .1 vote
- Don't see your idea?