Azure Synapse Analytics query data lake

DROP EXTERNAL TABLE tests_external_table
DROP EXTERNAL FILE FORMAT file_format_name
DROP EXTERNAL DATA SOURCE extdatasource;
DROP DATABASE SCOPED CREDENTIAL ADLSCredential;

CREATE DATABASE SCOPED CREDENTIAL ADLSCredential
WITH IDENTITY = 'User Identity',
SECRET = '...............=='


CREATE EXTERNAL DATA SOURCE extdatasource
WITH
(    LOCATION = 'abfss://data-lake-name@storageaccountname.dfs.core.windows.net/path/to/data/dir'
     , CREDENTIAL = ADLSCredential
     , TYPE = HADOOP
);

CREATE EXTERNAL FILE FORMAT file_format_name
WITH (  
    FORMAT_TYPE = DELIMITEDTEXT 
    --[ , DATA_COMPRESSION = 'org.apache.hadoop.io.compress.GzipCodec' ]
    , FORMAT_OPTIONS ( 
            FIELD_TERMINATOR = '|'
            , STRING_DELIMITER = ''
            , First_Row = 1
            , USE_TYPE_DEFAULT = TRUE
            , Encoding = 'UTF8'
     )
    );  

CREATE EXTERNAL TABLE tests_external_table
(
    Test varchar(1000)
)  
WITH (
    LOCATION = '/path/in/subfolders/filename.csv',
    DATA_SOURCE = extdatasource,
    FILE_FORMAT = file_format_name
)
GO

SELECT * FROM tests_external_table