This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I would like to run certain SQLX files during incremental executions,
but skip them during full refresh executions. What would be a clean way
to accomplish this?I was thinking of using the disabled property in the
config block, similar to below, but ...
Is there a way to adjust the default tab size in the Dataform IDE? In
the BigQuery IDE, the default tab size is 2 spaces. This was also
previously the default tab size for the Dataform IDE, but it seems to
have changed to 4 spaces recently.I noticed ...
I'm creating an incremental table in Dataform, but want to change how
duplicate rows are merged. The default behavior is for duplicate rows to
overwrite existing rows in the table (Merge rows in an incremental
table). Instead, I would like to sum val...
Hey Artem, thanks for the reply. The table will still exist whether it
be an incremental or non-incremental execution so your solution wouldn't
work out exactly.But your idea of essentially nullifying the operation
in the WHERE clause is a good one. ...
Hello, thanks for the suggestion. Unfortunately, the incremental
function does not work in the configuration block. When I add it as you
describe I get the following error:incremental is not definedI believe
it would need to be included in a JavaScri...
There’s a syntax mistake here. On line 8 of your query you have a
missing closing bracket at the beginning of the line. It should be ) AS
total_orders. Or you could move the ) to the end of line 7 depending on
your styling.This is because you have an...
That would prevent an incremental table from running as a full refresh.
I’m looking to prevent other types of SQLX files (ex. table, view,
operation) from running at all in the case of a full refresh
execution.Unless the protected property can apply ...