MySQL - Execute Queries | Alli Documentation

Overview

Execute any SQL query against a MySQL database, without returning any of the resulting data. This Blueprint should primarily be used for queries that perform functionality other than SELECT, like multi-step SQL jobs, or DML statements.

Variables

Name	Reference	Type	Required	Default	Options	Description
Host	MYSQL_HOST	Alphanumeric	✅	None	-	The domain or the IP address of the database you want to connect to.
Port	MYSQL_PORT	Integer	✅	3306	-	Number for the database port to connect to. Defaults to 3306.
Username	MYSQL_USERNAME	Alphanumeric	✅	None	-	Name of the user to connect to the database with.
Password	MYSQL_PASSWORD	Password	➖	None	-	Password associated to the provided username.
Database	MYSQL_DATABASE	Alphanumeric	✅	None	-	Name of the database in MySQL to connect to.
Extra URL Parameters	MYSQL_URL_PARAMETERS	Alphanumeric	➖	None	-	Extra parameters that will be placed at the end of the connection string, after the "?". Must be separated by "&".
Query	MYSQL_QUERY	Alphanumeric	✅	None	-	Any SQL query that runs a job against the database (CREATE, DROP, INSERT, etc.). Formatting is ignored.

YAML

Below is the YAML template

YAML


source:
  template: MySQL - Execute Queries
  inputs:
    MYSQL_HOST:
    MYSQL_PORT: '3306'
    MYSQL_USERNAME:
    MYSQL_PASSWORD:
    MYSQL_DATABASE:
    MYSQL_URL_PARAMETERS:
    MYSQL_QUERY:
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 101
    - 102
    - 210
    - 212
    - 220
    - 221
    - 222
    - 249