The dataform format command is now dramatically improved and has better formatter output for each SQL dialect that Dataform supports. Thanks @pokutuna for the contribution!
2.5.0: Enable use of schema() and database() context functions in SQLX code
No release notes provided.
2.4.2: Throw clearer compilation errors when non-string vars are provided
No release notes provided.
2.4.1: Add a CLI flag to disable analytics tracking
Users of the CLI (who are otherwise opted-in to analytics tracking) may now pass --track=false on an individual CLI command basis to disable analytics tracking.
2.4.0: Fix docker image to run dataform help as default command
No release notes provided.
2.3.2: Fix various CLI options
CLI errors regarding missing credentials files should now be rarer, and contain more explanatory detail when they are thrown
--include-dependents (for dataform run) now properly includes dependents of selection actions
2.3.0: Add a database() function in SQL templating
Both SQLX and JavaScript now support a database() function, which returns the (prefixed, as applicable) name of "this" action's database. (Contrived) examples:
publish("table", ctx => `select "${ctx.database()}" as col1`);
config { type: "table" }
select "${database()}" as col1
Assuming dataform.config contains "defaultDatabase": "foo", these both generate a table action whose SQL is select "foo" as col1. This is likely most useful in type: "operations" scripts.
Note: For warehouses without databases such as Redshift, this will add an error to the compilationErrors property.
Bugfix: The similar name() function has been fixed to properly attach any prefix as appropriate.
2.2.0: Add schema() function in SQL templating
Both SQLX and JavaScript now support a schema() function, which returns the (suffixed, as applicable) name of "this" action's schema. (Contrived) examples:
publish("table", (ctx) => `select "${ctx.schema()}" as col1`);
config { type: "table" }
select "${schema()}" as col1
Assuming dataform.config contains "defaultSchema": "foo", these both generate a table action whose SQL is select "foo" as col1. This is likely most useful in type: "operations" scripts.
... (truncated)
Commits
e75c442 Update sql-formatter & specify SQL language according to warehouse (#1490)
f27fb73 Separate sqlx build target into sqlx and format (#1499)
Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.
Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR:
- `@dependabot rebase` will rebase this PR
- `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it
- `@dependabot merge` will merge this PR after your CI passes on it
- `@dependabot squash and merge` will squash and merge this PR after your CI passes on it
- `@dependabot cancel merge` will cancel a previously requested merge and block automerging
- `@dependabot reopen` will reopen this PR if it is closed
- `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
- `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
- `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
- `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
You can disable automated security fix PRs for this repo from the [Security Alerts page](https://github.com/dataform-co/dataform-scd/network/alerts).
Bumps semver to 7.5.3 and updates ancestor dependency @dataform/core. These dependencies need to be updated together.
Updates
semver
from 5.7.1 to 7.5.3Release notes
Sourced from semver's releases.
... (truncated)
Changelog
Sourced from semver's changelog.
... (truncated)
Commits
7fdf1ef
chore: release 7.5.3bf53dd8
docs: add example for>
comparator (#569)abdd93d
fix: set max lengths in regex for numeric and build identifiers (#571)e7b78de
chore: release 7.5.258c791f
fix: diff when detecting major change from prerelease (#566)5c8efbc
fix: preserve build in raw after inc (#565)717534e
fix: better handling of whitespace (#564)2f738e9
chore: bump@npmcli/template-oss
from 4.14.1 to 4.15.1 (#558)aa016a6
chore: release 7.5.1d30d25a
fix: show type on invalid semver error (#559)Maintainer changes
This version was pushed to npm by npm-cli-ops, a new releaser for semver since your current version.
Updates
@dataform/core
from 1.5.5 to 2.6.0Release notes
Sourced from
@dataform/core
's releases.... (truncated)
Commits
e75c442
Update sql-formatter & specify SQL language according to warehouse (#1490)f27fb73
Separate sqlx build target into sqlx and format (#1499)69cad94
Release2.5.0
: to allow use of methods added to SQLX in https://github.com/...b91a6ee
Bump minimatch from 3.0.4 to 3.1.2 (#1495)3bc8d94
Bump loader-utils from 1.2.3 to 1.4.2 (#1492)f98dcfa
Remove old vm2 dependency. (#1493)44db3d3
Upgrade vm2 to3.9.19
. (#1491)cf2f509
Addschema
&database
to contextFunctions in compile time (#1485)f58bbdd
Remove/update dependencies resulting in updated fsevents dependency version. ...a728f46
Bump vm2 from 3.9.16 to 3.9.17 (#1478)Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting
@dependabot rebase
.Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself) You can disable automated security fix PRs for this repo from the [Security Alerts page](https://github.com/dataform-co/dataform-scd/network/alerts).