List All Snowflake Databases and Schemas Into an Excel workbook

The Scenario

A compliance audit is coming up in three weeks and the data governance lead needs to submit a full inventory of every Snowflake database and its schemas before the kickoff meeting. Nobody has ever written this down anywhere. The knowledge exists across four engineers' heads and a Confluence page that hasn't been updated since 2023.

You've been handed the task. You have read access to the Snowflake account. You do not have time to navigate every database one at a time through the UI and transcribe schema names into an Excel workbook by hand.

The bad version:

• Open the Snowflake UI, click into the first database, expand the schema tree, and write down each schema name in the workbook manually.
• Repeat for all 8 databases — clicking, expanding, reading, typing — for 20 to 40 schemas depending on what's in there.
• Inevitably miss a schema that was hidden under a collapsed folder, discover it's missing when the compliance reviewer asks about it, and redo the row.

This inventory needs to be accurate and it needs to be done today. Manual transcription from a UI is the wrong tool for an accuracy requirement.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It connects to Snowflake and can enumerate databases and schemas programmatically, then write the structured result directly into your workbook.

Paste this into the SheetXAI sidebar:

List all databases in my Snowflake account, then for each database list all schemas — write everything into this sheet with one row per schema and columns: database_name, schema_name

What You Get

• Row 1 with headers: database_name and schema_name
• One row per schema across all accessible databases, fully enumerated
• INFORMATION_SCHEMA entries included unless you specify otherwise
• If a database is inaccessible with your credentials, the database name appears with an access error note in the schema_name column

What If the Data Is Not Quite Ready

You want to exclude the INFORMATION_SCHEMA from every database

List all databases in my Snowflake account and all schemas within each database, but exclude any schema named INFORMATION_SCHEMA — write database_name and schema_name into columns A and B of this sheet starting at A1 with headers

You need to filter down to a specific set of databases

List all schemas in Snowflake databases PROD, STAGING, and ANALYTICS — write database_name and schema_name into columns A and B of this sheet, one row per schema, sorted alphabetically by database_name

You need to add a third column for the database owner

List all databases and their schemas in my Snowflake account, including the owner of each database — write database_name, schema_name, and database_owner into columns A, B, and C of this workbook sheet with headers

You need to cross-reference the schema list against an existing ownership map in the workbook

Look at the database and schema names I've listed in column A and B of the Ownership worksheet, then check each one against Snowflake to confirm it still exists — write 'EXISTS', 'MISSING', or 'ACCESS DENIED' in column C for each row

The goal in every case is the same: one prompt that handles the enumeration, the filtering, and the write together.

Try It

Get the 7-day free trial of SheetXAI and open the Excel workbook where your data governance inventory lives, then ask it to enumerate your Snowflake databases and schemas in one pass. You can also explore exporting a table inventory by size or return to the Snowflake overview.