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 not in a dashboard. It's not in a shared doc. It's distributed across Snowflake system tables and SHOW INTEGRATION commands that you'd have to run one at a time, copy the output of, and then paste into a sheet where everything actually lines up.
The bad version:
- Run SHOW CATALOG INTEGRATIONS in SnowSight to get the list of integration names
- For each name, run DESCRIBE INTEGRATION <name> to get the detail
- Copy each DESCRIBE result into a separate tab, then manually consolidate them into one sheet with consistent column names
- Discover that Snowflake's DESCRIBE output doesn't have a consistent column order across integration types, so GLUE_PROD_CATALOG and REST_CATALOG_EU have different property names in the same position
This is an infrastructure audit, not a puzzle. You shouldn't have to normalize property names by hand.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet, connects to Snowflake through its built-in integration, and can enumerate catalog integrations, retrieve their configuration details, and write a structured summary sheet — column-aligned and consistent across integration types.
Open a blank Google Sheet 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 Google 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 (Glue, Polaris, REST)
- Header row in row 1, ready to share as-is
What If the Data Is Not Quite Ready
You need the full configuration detail 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 Google Sheet for infrastructure documentation
You need to filter to only enabled integrations
Retrieve all Snowflake catalog integrations, keep only those where enabled status is TRUE, write integration name, catalog type, endpoint URL, and enabled status into this sheet sorted by catalog type
You need to compare two integrations side by side
Fetch configuration details for Snowflake catalog integrations GLUE_PROD_CATALOG and REST_CATALOG_EU, write each integration's parameters into a separate column with parameter names in column A, GLUE_PROD values in column B, and REST_EU values in column C
Full audit with integration type counts and a summary
Retrieve all Snowflake catalog integrations, write integration name, catalog type, endpoint URL, and enabled status into this sheet, then add a summary section below the table showing count of integrations by type and count of enabled vs. disabled
The pattern: property normalization, filtering, and summarization are part of the same prompt — not a manual step after you've exported a raw DESCRIBE result.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask it to enumerate and document your Snowflake Iceberg catalog integrations in a single structured sheet — ready for an infrastructure review without a single manual copy-paste. Also see run a data quality audit for related governance workflows, or return to the Snowflake integration overview.