This is a Blob Storage (ADLS Gen2) to Azure Synapse SQL Server data import script that works in conjunction with the SharePoint CSV Conversion Power Automate process. The script automatically detects the columns and data types and creates a suitable table to match.

Download: CSV_Import_v0.2.5.zip

Sample CSV data template for import script

@odata.etagTypeCategorySub-categoryAmount

WidgetWidgetWidget10

WidgetWidgetWidget2

WidgetWidgetWidget15

Change Log:

v0.2.5
Added print statements to allow for diagnostics on load process

v0.2.4
Added a statement to drop the ItemInternalId column generated by the Power Automate process

v0.2.3
Updated real data type to float for large number support
Include SET DATEFORMAT to correct for formats on import and the detection of date fields
Removed ColumnCount setting, the script will now autodetect the number of columns

v0.2.1
Fixed Create Table Bug when the count went above column count in header table
Added SchemaName
Removed ColumnCount setting, the script will now autodetect the number of columns

v0.1.0
First release of script