[Copy](javascript:void(0);)

``` -- dbvendor=MYSQL

-- username=aiq

-- password=thePassword

-- host=mysqlsmoketest.c7nn5t4czzya.us-west-2.rds.amazonaws.com

-- schema=aiq

-- port=3306

-- limit=21-50

-- tag=executions

-- connect

SELECT * FROM `aiq`.`UTPScenarioExecution`;

-- storeInLocker=

-- disconnect ```

[Copy](javascript:void(0);)

``` -- dbvendor=REDSHIFT

-- username=theUser

-- password=thePassword

-- host=sqlclient-test.cqzappbyyyx5.us-east-2.redshift.amazonaws.com

-- schema=dev

-- port=5439

-- 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.dateid = date.dateid

and year = 2008

and city = 'San Diego'

group by sellerid, username, name, city

order by 5 desc;

-- storeInWhiteboard=

-- disconnect ```

[Copy](javascript:void(0);)```
-- dbvendor=SNOWFLAKE

-- region=us-west-2

-- account=qrazxhk-kiw37206

-- role=ACCOUNTADMIN

-- username=theUser

-- password=thePassword

-- warehouse=COMPUTE_WH

-- db=APPVANCE

-- schema=AIQ

-- connect

update COUNTRIES 

set COUNTRY_NAME='NAME CHANGED' 

where COUNTRY_CODE=999;

-- disconnect
```

[Copy](javascript:void(0);)```
-- dbvendor=MSSQL

-- username=theUser

-- password=thePassword

-- host=mssqlsmoketest.c6mn5c3czyyb.us-west-2.rds.amazonaws.com

-- schema=master

-- port=1433

-- connect

call sp_tables;

-- storeInLocker=

-- disconnect
```

[Copy](javascript:void(0);)```
-- dbvendor=ORACLE

-- username=theUser

-- password=thePassword

-- host=oraclestest.c4nm5t3czzya.us-west-2.rds.amazonaws.com

-- schema=ORCL

-- port=1521

-- connect

SELECT aiq.getversion() FROM dual;

-- tag=results

-- storeInLocker=

-- disconnect
```