Sample SQL Scripts for AIQ Testing

Sample

--SQL dbvendor=MYSQL
--scripts username=aiq
--should password=thePassword
--demonstrate host=mysqlsmoketest.c7nn5t4czzya.us-west-2.rds.amazonaws.com
--safe, schema=aiq
--repeatable port=3306
--validation limit=21-50
--patterns tag=executions
--for connect
SELECTAIQ *testing. FROMExamples `aiq`.`UTPScenarioExecution`;
--must storeInLocker=
--avoid disconnect

• Use

  --placeholder dbvendor=REDSHIFT
  --connection username=theUser
  --values, password=thePassword
  --schema host=sqlclient-test.cqzappbyyyx5.us-east-2.redshift.amazonaws.com
  --names, schema=dev
  --table port=5439
  --names, limit=1-50000
  -- tag=saleswb
  -- connect
  select sellerid, username, (firstname ||' '|| lastname) as name,
  city, sum(qtysold)
  from sales, date, users
  where sales.sellerid = users.userid
  and sales.dateidcredentials.

• Prefer =read-only date.dateid
  queries unless the article explicitly covers controlled setup or cleanup.
• Explain expected results, assumptions, and yearfailure =conditions.
• Include 2008
  transaction or rollback guidance when data changes are required.

Validation workflow

1. Run scripts in a non-production database first.
2. Confirm permissions match the intended AIQ execution account.
3. Review output in AIQ and citydatabase =logs.
4. Remove 'Sanor Diego'
   group by sellerid, username, name, city
   order by 5 desc;
   -- storeInWhiteboard=
   -- disconnect