I am ingesting data from two different source (source A and source B). Although data may be coming from two different sources, there is a possibility that an ID for a record may exist in both sources. The problem is, there are cases when one source is more complete than the other. In the example below, Source A has a
Tag: azure-sqldw
Retrieve text between two periods in a value
I’ve been spinning around a bit on how to accomplish this in SQL DW. I need to extract the text between two periods in a returned value. So my value returned for Result is: I’m trying to extract the values between period 1 and 2, so the red portion above: The values will be a wide variety of lengths. I’ve
Rename Column in Azure Data Warehouse
I know I can accomplish my objective with this process: Create new column Update new from old Drop old I am looking for a way to do this with one command. I know that remane object works at the table level. For example, I can do this: But these all fail with various error messages: Plus, according to this, sp_rename