'Infer Schema from .csv file appear in azure blob and generaate DDL script automatically using Azure SQL

Every time the .csv file appearing in the blob storage, i have to create DDL from that manually on azure sql. The data type is based on the value specified for that field.

The file have 400 column, and manually it is taking lots of time.

May someone please suggest how to automate this using SP or script, so when we execute the script, it will create TABLE or DDL script, based on the file in the blob storage.

I am not sure if it is possible, or is there any better way to handle such scenario.

enter image description here

Appreciate yours valuable suggestion.

Many Thanks

tsqlazure-sql-databaseazure-blob-storage


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

Return a value if no rows are found in Microsoft tSQL

Return a value if no rows are found in Microsoft tSQL

Return a value if no rows are found in Microsoft tSQL

Getting maximum value of float in SQL programmatically

Getting maximum value of float in SQL programmatically

Getting maximum value of float in SQL programmatically

Getting maximum value of float in SQL programmatically

Conversion failed when converting date from character string

How do I create a SQL Function to return a BIT?

CONCAT_WS() for SQL Server

Export database schema into XML file

SQL - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

Using a SELECT statement to return a row where a DateTime column = variable of type Date?

Is it necessary to test for NULL if also testing for greater than?

SSMS 2012: Convert DATETIME to Excel serial number