The Scenario
The quarterly infrastructure review is next week. You're the cloud data architect, and your CTO wants a summary of every Iceberg catalog integration configured in Snowflake — the AWS Glue connections, the Polaris entries, the REST catalog hooks. What's connected, what's the endpoint, is it enabled, what type is it.
This isn't information that lives anywhere obvious. It's distributed across Snowflake system tables and SHOW INTEGRATION commands you'd have to run one at a time, copy the output of, and then paste into an Excel worksheet where everything lines up.
The bad version:
- Run SHOW CATALOG INTEGRATIONS in SnowSight to get the names
- For each name, run DESCRIBE INTEGRATION to get the detail
- Copy each DESCRIBE result into a separate worksheet tab, then consolidate into one sheet with consistent column headers
- Find that Snowflake's DESCRIBE output doesn't use consistent property names across integration types — Glue and REST catalog entries have different field structures
This is a documentation task. It shouldn't require twenty minutes of normalization work.
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 enumerate catalog integrations, retrieve their configuration details, and write a structured summary worksheet — column-aligned and consistent across integration types.
Open a blank Excel worksheet and paste this into the SheetXAI sidebar:
Retrieve all available Snowflake catalog integration names and for each one write the integration name, catalog type, endpoint URL, and enabled status into this Excel sheet
What You Get
- One row per catalog integration in your Snowflake account
- Columns: integration name, catalog type, endpoint URL, enabled status
- Consistent column alignment regardless of integration type
- Header row in row 1, ready to drop into a review slide or governance doc
What If the Data Is Not Quite Ready
You need the full parameter set for a specific integration
Fetch detailed configuration for Snowflake catalog integration named GLUE_PROD_CATALOG and write every parameter and its value into columns A and B of this Excel sheet for infrastructure documentation
Filter to only enabled integrations
Retrieve all Snowflake catalog integrations where enabled status is TRUE, write integration name, catalog type, endpoint URL, and enabled status into this Excel sheet sorted by catalog type
Compare two integrations side by side in a parameter matrix
Fetch configuration details for Snowflake catalog integrations GLUE_PROD_CATALOG and REST_CATALOG_EU, put parameter names in column A, GLUE_PROD values in column B, and REST_EU values in column C of this Excel sheet
Full audit with type counts and enabled/disabled summary
Retrieve all Snowflake catalog integrations, write integration name, catalog type, endpoint URL, and enabled status into this Excel sheet, add a summary section below with count of integrations by catalog type and count of enabled vs. disabled
The pattern: the consolidation, the filtering, and the summary are part of the same instruction — not a separate normalization step after you've exported six separate DESCRIBE outputs.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask it to enumerate and document every Snowflake Iceberg catalog integration in one structured worksheet — ready for a governance review without a manual copy-paste in sight. Also see run a data quality audit for related governance workflows, or return to the Snowflake integration overview.