Query Command

The query command executes and retrieves the results of a query on a specified connection and returns the results in table format, JSON, or CSV.

You can run it in three modes:

• Direct query: provide --connection and --query
• Asset query: provide --asset (optional --environment) to execute the SQL from an asset file
• Auto-detect: provide --asset + --query to run an ad-hoc query using the asset's connection and dialect

Flags:

Flag	Alias	Description
--connection	-c	The name of the connection to use (direct query mode).
--query	-q	The SQL query to execute.
--asset		Path to a SQL asset file within a Bruin pipeline.
--environment	--env	Target environment name as defined in .bruin.yml.
--start-date		Start date for query variables in YYYY-MM-DD or YYYY-MM-DD HH:MM:SS.
--end-date		End date for query variables in YYYY-MM-DD or YYYY-MM-DD HH:MM:SS.
--limit	-l	Limit the number of rows returned.
--timeout	-t	Timeout for query execution in seconds (default: 1000).
--output [format]	-o	Output type: plain, json, csv.
--config-file		The path to the .bruin.yml file.

Example

bruin query --connection my_connection --query "SELECT * FROM table"

Example output:

+-------------+-------------+----------------+
|   Column1   |   Column2   |    Column3     |
+-------------+-------------+----------------+
| Value1      | Value2      | Value3         |
| Value4      | Value5      | Value6         |
| Value7      | Value8      | Value9         |
+-------------+-------------+----------------+