dataform-co/dataform

Running the CLI with "run --dry-run" causes BigQuery changes to be applied

kolban-google opened this issue · 0 comments

Summary: When I run dataform run --dry-run, the SQL is executed. I had anticipated the SQL not to be executed.

Details:
I have a BigQuery dataset I call dataform. It has no tables in it.

I have a SQLX file called ages.sqlx. Contained within is:

config { type: "table" }

SELECT
    name, age
FROM 
(
    SELECT "Bob" as name, 55 as age UNION ALL
    SELECT "Jane", 42 UNION ALL
    SELECT "John", 35 UNION ALL
    SELECT "Sarah", 27 UNION ALL
    SELECT "Mike", 57
) 

I then run:

$ dataform run --dry-run
Compiling...

Compiled successfully.

Dry running (no changes to the warehouse will be applied)...
Table dry run success:  dataform.ages [table]
$ 

I then query my BigQuery environment and now find that a table called dataform.ages was indeed created. I had not expected the table to be created during the dry run invocation.

My CLI version is:

$ dataform --version
3.0.0-beta.5
$