Using a COPY statement to import data
There are various ways in which to bring data from various sources to Azure Synapse SQL. However, it is recommended that you use a COPY statement if your data is residing in an Azure Storage account. The best part of following this technique is that you can copy the data just by running a single T-SQL statement. The syntax for the COPY statement is very simple, with a set of arguments to choose from. You can decide which argument you want to use with your COPY statement.
The following is the syntax that can be customized as per your business requirements to bring the data from an external source to the Azure Synapse SQL pool:
COPY INTO [schema.]table_name
[(Column_list)]
FROM '<external_location>' [,...n]
WITHÂ Â
(
[FILE_TYPE = {'CSV' | 'PARQUET' | 'ORC'} ]
[,FILE_FORMAT = EXTERNAL FILE FORMAT OBJECT ]
[,CREDENTIAL = (AZURE CREDENTIAL) ]
[,ERRORFILE = '[http(s)://storageaccount...
