Error while creating external table using parquet file from blob storage

Question

CREATE EXTERNAL FILE FORMAT irisprodgold_PARQUETformat
  WITH (
    FORMAT_TYPE = PARQUET
  );

Upto creating external data source query didn't throw error but while creating the file format it is throwing error as below :
Could anyone help what can be the solution for this do we need to do any configuration in blob storage.

Answer 1

This is how you should create a parquet ext file format., i dont see anywhere location should be mentioned in the microsoft documentation. Can you correct your syntax and try once?

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-file-format-transact-sql?view=sql-server-ver16&tabs=parquet

--Create an external file format for PARQUET files.
CREATE EXTERNAL FILE FORMAT file_format_name
WITH (
         FORMAT_TYPE = PARQUET
     [ , DATA_COMPRESSION = {
        'org.apache.hadoop.io.compress.SnappyCodec'
      | 'org.apache.hadoop.io.compress.GzipCodec' }
    ]);