-
Notifications
You must be signed in to change notification settings - Fork 0
exec
jeremywinters edited this page Apr 15, 2017
·
1 revision
exec
Usage:
sneaql exec PATH_TO_TRANFORM_ROOT
Options:
-s, [--step-file=STEP_FILE]
-e, [--env-file=ENV_FILE]
-url, [--jdbc-url=JDBC_URL]
-u, [--db-user=DB_USER]
-p, [--db-pass=DB_PASS]
-j, [--jdbc-driver-jar=JDBC_DRIVER_JAR]
-c, [--jdbc-driver-class=JDBC_DRIVER_CLASS]
[--debug], [--no-debug]
Description:
executes the transform provided
PARAMETERS
you can provide the following parameters via an environment variable or by
putting them in a sneaql.env file
* export SNEAQL_JDBC_URL=jdbc:redshift://your-redshift-hostname:5439/dbname
* export SNEAQL_DB_USER="dbadmin"
* export SNEAQL_DB_PASS="password"
* export SNEAQL_JDBC_DRIVER_JAR="java/RedshiftJDBC4-1.1.6.1006.jar"
* export SNEAQL_JDBC_DRIVER_CLASS="com.amazon.redshift.jdbc4.Driver"
note that if you provide an attribute on the command line it will override the
environment variable value.
EXAMPLE
$ sneaql exec .
the above will execute the transform in the current directory. note that
sneaql.json file must be in this directory or provided via -s option.
- assign
- assign_result
- execute
- execute_if
- test
- exit_if
- exit_step_if
- recordset
- remove_recordset
- iterate
- on_error
Configuration
-
Command Reference