The Scenario
The CTO meeting is in two hours. You're the BI lead. Someone in last week's cloud cost review asked how much storage your ANALYTICS.REPORTING schema is actually consuming, and nobody had a clean answer. Your CTO followed up this morning: get me a full table inventory — all 120 tables, row counts, byte sizes — before the sync.
You know where the data lives. You've run SHOW TABLES IN SCHEMA before. What you haven't done is turn that output into a formatted, sorted Excel worksheet that a CTO can read in a two-hour window.
The bad version:
- Run SHOW TABLES IN SCHEMA ANALYTICS.REPORTING in SnowSight
- Export the result — which includes 20 columns you don't need, in an order nobody asked for
- Open in Excel, delete the irrelevant columns, rename the three you're keeping, sort by size descending
- Find the byte sizes are in scientific notation and need formatting before they're readable
You have two hours. You've used forty minutes.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook, connects to Snowflake through its built-in integration, and can pull a targeted schema-level table inventory — structured, sorted, and labeled exactly as you need it.
Open a blank Excel worksheet and paste this into the SheetXAI sidebar:
Show all tables in Snowflake database PROD schema PUBLIC that were created in the last 90 days and write table_name, row_count, owner, and created_date into this Excel sheet
What You Get
- Columns: table_name, row_count, owner, created_date
- All tables in PROD.PUBLIC created within the last 90 days
- Header row in row 1, typed correctly — dates as dates, numbers as numbers
- No columns you didn't ask for, no extra formatting pass needed
What If the Data Is Not Quite Ready
You need size in gigabytes rather than bytes
List all tables in Snowflake database ANALYTICS schema REPORTING, write table_name into column A, row_count into column B, and size in gigabytes (rounded to 2 decimal places) into column C of this Excel sheet — sort by size descending with headers in row 1
Pull from multiple schemas into one worksheet
List all tables in Snowflake database ANALYTICS for schemas REPORTING and PUBLIC, write schema, table_name, row_count, and size_bytes into columns A through D of this Excel sheet — sort by size_bytes descending with headers in row 1
Add a size tier classification column
List all tables in Snowflake database ANALYTICS schema REPORTING, write table_name, row_count, and size_bytes into columns A, B, C — add a column D called size_tier with values LARGE if size_bytes > 10000000000, MEDIUM if between 1000000000 and 10000000000, SMALL otherwise — sort by size_bytes descending
Full inventory with owner filter and a summary row
List all tables in Snowflake database ANALYTICS schema REPORTING owned by the role TRANSFORMER, write table_name, row_count, size_bytes, owner into columns A–D of this Excel sheet sorted by size_bytes descending — add a summary row at the bottom with total tables and total size_bytes
The pattern: sort order, derived columns, and filters are part of the same request as the inventory pull — not a second step in Excel after you've exported the raw data.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask it to pull a targeted table inventory for any Snowflake schema — sorted, labeled, and sized for the audience you're presenting to. For the account-wide version, see build a Snowflake data catalog, or return to the Snowflake integration overview.