Hydra Academy / Hydra CLI

1. 3:36
   01

   Getting started with hdrctl on Killercoda

   A first look at hdrctl, the Hydra ETL command line, in a free Killercoda playground.

   • Open the Hydra ETL labs on Killercoda
   • Check the installed version with hdrctl --version
   • List the commands with hdrctl --help
   • Get help on one command with hdrctl init -h
   • Switch the CLI to Spanish with --lang es

   Try it: Lab 1 — Meet hdrctl Watch on YouTube
2. 4:35
   02

   Create a project with hdrctl init and explore its structure

   hdrctl init scaffolds a complete Hydra ETL project in one command. What it creates, and what each file does.

   • Create a project with hdrctl init
   • Read its structure: Data/, output/, workflows/, jobs/job1/, .hydra/
   • The four files of a job: sources, destinations, transformations, pipeline
   • Edit them in the Killercoda Editor, with the HYDRA ETL extension

   Try it: Lab 1 — Meet hdrctl Watch on YouTube
3. 3:29
   03

   Check a MySQL job before running it with hdrctl test

   hdrctl test goes through a job section by section and tells you what is wrong before you run it.

   • Create a MySQL project; credentials come from environment variables
   • Break the load mode: upsret instead of upsert
   • Read the error: Input should be 'append', 'replace' or 'upsert'
   • Fix it and test again until everything passes

   Try it: Lab 3 — hdrctl test Watch on YouTube
4. 2:57
   04

   Hydra ETL over HTTP: hdrctl serve and the REST API

   hdrctl serve starts a REST API, so any HTTP client can drive Hydra ETL.

   • Start the API with hdrctl serve --no-studio --port 5678
   • Call /api/health with curl
   • Validate a job over HTTP, then read the error returned as JSON
   • Try Hydra DSL in the playground on hydraetl.com

   Try it: Lab 4 — hdrctl over HTTP Watch on YouTube