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
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:
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