This quick tip describes how to get Row Count in Azure Synapse Analytics (formerly Azure Data Warehouse). Azure Data Warehouse doesn’t support @@ROWCOUNT or ROWCOUNT_BIG. The link offers an alternative. This article modified that alternative to return the row count value as an OUTPUT parameter so a variable can be set to the row count value….
How to prepare a file for ingestion into Azure SQL Data Warehouse using Polybase, when there are NULLs in the data? There are only a few web pages that talk about how Polybase handles NULL values… And most of them are misleading. For example: Polybase to treat the NULL string as Null values and not…
To run ETL on Azure Data Warehouse, it’s a good idea to create a user in a higher resource class. There are a number of ways to authenticate to Azure DW. See – Controlling and granting database access to SQL Database and SQL Data Warehouse The easiest (from a development perspective) is to create an…
