PolyBase export of datetime values does not use DATE_FORMAT

This topic came up on a recent support case I had worked on. The customer had stored the data in an Azure SQL Data Warehouse database, but needed to move it into Azure blob storage for consolidating data from different sources. This also required to write the datetime values in a specific format. The idea…


Azure Data Warehouse Health Check Query

We have been sharing this query with the customers to have a quick health check on their environment. The query covers these items: Checking basic statistics information (actual row count vs row count for control node) Table data skew Small CCI tables (<102400 rows per partition) – This is just for their reference for reviewing…


Lesson Learned #15: Securing our Azure SQL Datawarehouse

Hello Everyone, Nowdays, the security is a key element for all databases, for this reason, in Azure SQL we have several options depending on our needs. In this picture you could see the different available options that we have right now. In this post, I would like to share some points about two important topics…


Lesson Learned #12: What types of temporary tables can I use in Azure SQL Datawarehouse?

In SQL Datawarehouse we are able just to create tables with #, so, that means that this temporal table will be available during the session that create this table. Other calls, for example, ## ( Global Temporal Tables ) or tempdb..name will return an syntax error like this one. URL: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-temporary CREATE TABLE tempdb..Temporal([OrderArticleId] [int]…