Environment Variables

Environment Variables

SneaQL refers to environment variables upon startup, which are used for the following:

• Database connection and configuration parameters
• Git connection parameters (for use with external repos)
• Optional variables for use in your SneaQL transform
• AWS API credentials
• Secrets management configuration (with biscuit)

Database connection and configuration parameters

SneaQL requires the following connection information for your database:

• SNEAQL_JDBC_URL - the JDBC url associated with your database instance. You can get this from your DBA

• SNEAQL_DB_USER - username for database connection

• SNEAQL_DB_PASS - password for database user

• SNEAQL_JDBC_DRIVER_JAR - location of the JDBC driver jar file (see section below)

• SNEAQL_JDBC_DRIVER_CLASS - class name for use with JDBC driver

• --jdbc_url/SNEAQL_JDBC_URL - the JDBC url associated with your database instance. You can get this from your DBA

• --db_user/SNEAQL_DB_USER - username for database connection

• --db_pass/SNEAQL_DB_PASS - password for database user

• --jdbc_driver_jar/SNEAQL_JDBC_DRIVER_JAR - location of the JDBC driver jar file (see section below)

• --jdbc_driver_class/SNEAQL_JDBC_DRIVER_CLASS - class name for use with JDBC driver

Optional parameters:

• SNEAQL_LOG_UTC - Enables UTC logging if true
• SNEAQL_AVAILABLE_ENV_VARS - Comma delimited list of environment variables made available to the SneaQL transform. This allows for restricting
• SNEAQL_EXTENSIONS - Comma delimited list of SneaQL extensions (indicated by the name of their ruby gem)