Skip to content

NamedQuery

Source: src/AWS/Athena/NamedQuery.ts

An Amazon Athena named (saved) query — a reusable SQL statement stored against a Glue database inside a workgroup. Its identity is the server-assigned NamedQueryId; the name, description, and queryString are updatable in place, while changing database or workGroup replaces it.

const query = yield* AWS.Athena.NamedQuery("TopCustomers", {
database: "analytics",
queryString: "SELECT customer_id, SUM(amount) AS total " +
"FROM orders GROUP BY customer_id ORDER BY total DESC LIMIT 10",
workGroup: wg.workGroupName,
});