Error while creating external table using parquet file from blob storage

Ratn Priya 0 Reputation points
2023-10-12T17:00:14.6333333+00:00
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.
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,497 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Vinodh247-1375 11,481 Reputation points
    2023-10-19T06:34:39.9766667+00:00

    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' }
        ]);
    
    1 person found this answer helpful.
    0 comments No comments