'Issue wile loading data from Azure to snowflake
I am in the process of loading csv files from Azure blob into Snowflake staging tables.
However, While receiving files into Azure blob sometimes we receive different patterns in the file like(comma separator, pipe separator, some columns missing, some added, some removed) due to this while loading to target table, data placed to different columns(like column A) which should be placed to another column (Like B). Order of the headers could change at any time in Azure and issue happens to snowflake staging while loading.
So Does Snowflake support anything with the COPY command to automatically map the CSV headers to column names on a target table?
Any tips or suggestions would be greatly appreciated! Thank you.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|