# store model output in external location

**URL:** https://discourse.getdbt.com/t/store-model-output-in-external-location/10406
**Category:** Help
**Tags:** external-tables, dbt-core
**Created:** [October 18, 2023, 5:54pm UTC](https://discourse.getdbt.com/t/store-model-output-in-external-location/10406 "2023-10-18T17:54:41Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![david.backx](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/david.backx/32/2529_2.png) [@david.backx](https://discourse.getdbt.com/u/david.backx)
#### Post date: [October 18, 2023, 5:54pm UTC](https://discourse.getdbt.com/t/store-model-output-in-external-location/10406/1 "2023-10-18T17:54:41Z")

</div>

## The problem I’m having

I want the output of my model to be stored in my azure blob storage. I can now store it in a local folder but I want the output of my model to go straight to the azure blob storage as a csv file.

## Some example code or error messages

This is from my dbt\_project.yml

```auto
models:
  rcsc_dbt:
    # Config indicated by + and applies to all files under models/example/
    example:
      +materialized: view
    staging:
      +materialized: external
      +schema: bronze
      +location: 'azure://sarcscdataplatform/bronze-container/local_access.csv'
      +format: csv
    intermediate:
      +materialized: view
      +schema: silver
    marts:
      +materialized: table

```

But mainly I receive this as an error:

```auto
Invalid Input Error: Attempting to execute an unsuccessful or closed pending query result
  Error: Serialization Error: LogicalCopyToFile not implemented yet

```

Is it not implemented yet to store it directly in the azure blob storage? I’m looking forward to anyone’s answers! Thanks in advance