# How to load parquet files from Azure Data Lake Gen2 to dedicated pool using dbt?

**URL:** <https://discourse.getdbt.com/t/how-to-load-parquet-files-from-azure-data-lake-gen2-to-dedicated-pool-using-dbt/4057>\
**Category:** Archive\
**Created:** [March 20, 2022, 1:25pm UTC](https://discourse.getdbt.com/t/how-to-load-parquet-files-from-azure-data-lake-gen2-to-dedicated-pool-using-dbt/4057 "2022-03-20T13:25:22Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dbtheadache](https://avatars.discourse-cdn.com/v4/letter/d/f4b2a3/32.png) [@dbtheadache](https://discourse.getdbt.com/u/dbtheadache)\
**Post date:** [March 20, 2022, 1:25pm UTC](https://discourse.getdbt.com/t/how-to-load-parquet-files-from-azure-data-lake-gen2-to-dedicated-pool-using-dbt/4057/1 "2022-03-20T13:25:22Z")

</div>

Hi,  
I’m using dbt-synapse: [GitHub - dbt-msft/dbt-synapse: dbt adapter for Azure Synapse SQL Dedicated Pools](https://github.com/dbt-msft/dbt-synapse)  
I want to load my parquet file from Azure Data Lake Gen2/Azure Blob Storage to the dedicated pool in Azure Synapse.  
I tried to use

```auto
{{ config(materialized='table') }}
with my_table as (
    SELECT
        TOP 100 *
    FROM
        OPENROWSET(
            BULK 'myparquetfile_url',
            FORMAT = 'PARQUET'
        ) AS [result]
)

select * from my_table

```

but no luck.

It shows this error

```auto
('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Parse error at line: 7, column: 9: Incorrect syntax near 'OPENROWSET'. (103010) (SQLExecDirectW)")

```

So, how can I load parquets file from blob storage to dedicated pool using dbt?