mz sql

The mz sql command executes SQL statements in a region.

shell

mz sql [options...] [-- psql options...]

Arguments

Argument	Environment variables	Description
`--region=<REGION>`	`MZ_REGION`	Use the specified region.
`--profile=<PROFILE>`	`MZ_PROFILE`	Use the specified authentication profile.

Launch a SQL shell against the aws/us-east-1 region:

shell

mz sql --region=aws/us-east-1

Execute a single SQL query against the default region for the profile:

shell

mz sql -- -c "SELECT * FROM mz_sources"