Projects with operations only will output an error when starting a new run

dataform-co / dataform

Dataform is a framework for managing SQL based data operations in BigQuery

https://cloud.google.com/dataform/docs

Apache License 2.0

835 stars 161 forks source link

Projects with operations only will output an error when starting a new run #345

Closed BenBirt closed 5 years ago

BenBirt commented 5 years ago

On Redshift (and possibly PG and Snowflake)

Returning error: error: cannot execute CREATE SCHEMA in a read-only transaction

And no operation is run

I assume dataform tries to create a schema befiore executing any query

Moved from dataform-co/dataform-co#1098 /cc @G2H

BenBirt commented 5 years ago

I can't seem to reproduce this. I made a new redshift project containing a single script select 1 as test, and it runs against the warehouse fine (also if I randomly change the default schema, etc).

@G2H can you indicate how to repro?

G2H commented 5 years ago

I confirm I can't reproduce this anymore