Environment Variables - full360/sneaql GitHub Wiki

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)