---
title: "Discussion on \"How to Get \"Total Data Scanned\" for a Redshift Query via the Data API\" | Hashnode"
description: "Discussion on \"How to Get \"Total Data Scanned\" for a Redshift Query via the Data API\". Problem\nYou can see \"data scanned\" metrics for queries in the Redshift console, but you need to access these numbers programmatically from Lambda functions, ETL jobs, or CI/CD pipelines that use the Redshift Data API. Without programmatic access to s..."
url: "https://hashnode.com/posts/how-to-get-total-data-scanned-for-a-redshift-query-via-the-data-api/689f008d870031202771f231"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [How to Get "Total Data Scanned" for a Redshift Query via the Data API](https://aaron-rose.hashnode.dev/how-to-get-total-data-scanned-for-a-redshift-query-via-the-data-api?utm_source=hashnode&utm_medium=feed)

Problem You can see "data scanned" metrics for queries in the Redshift console, but you need to access these numbers programmatically from Lambda functions, ETL jobs, or CI/CD pipelines that use the Redshift Data API. Without programmatic access to s...

Aug 15, 2025 · 5 min read · aaron-rose.hashnode.dev  
Read the article

-   [#aws](https://hashnode.com/tag/aws)
-   [#apis](https://hashnode.com/tag/apis)
-   [#redshift](https://hashnode.com/tag/redshift)
-   [#databases](https://hashnode.com/tag/databases)

## Written by

[Aaron Rose](https://hashnode.com/@aaronrose)

@aaronrose · Dallas, TX

  
[View profile](https://hashnode.com/@aaronrose)

Aaron Rose is a software engineer and technology writer.

Software engineer and technology writer. I explore Python, Go, AWS, cloud tools, Raspberry Pi projects, and practical DevOps—always from the ground up. More at tech-reader.blog

## Responses 1

Markdown supported · ⌘↵ to post

[Anik Sikder](https://hashnode.com/@anik169)

[Aug 15, 2025](https://hashnode.com/posts/how-to-get-total-data-scanned-for-a-redshift-query-via-the-data-api/689f008d870031202771f231/comment/689f1091a4ca6076858978f8)

This is a super valuable breakdown for anyone working with Redshift at scale. You’ve clearly highlighted a real gap scan metrics are critical for cost and performance control, and not having programmatic access is a blocker. The step-by-step guide makes it actionable, and the emphasis on Redshift Serverless billing ties it directly to real-world impact. Definitely something teams should implement if they care about efficiency and budget.

[Aaron Rose](https://hashnode.com/@aaronrose)

[Jan 19](https://hashnode.com/posts/how-to-get-total-data-scanned-for-a-redshift-query-via-the-data-api/689f008d870031202771f231/comment/689f1091a4ca6076858978f8#reply-696ebe27cd2841e1cf09b663)

Cheers anik, thank you 🙏
