Multiple Shared Databases Unavailable in Snowflake

[XinhhD]

Issue Summary

Multiple Shared Databases Unavailable in Snowflake

Multiple shared databases in Snowflake are no longer available, causing benchmark instances to fail with SQL compilation errors.

---

Error Details

Error Message

003030 (02000): SQL compilation error:
Shared database is no longer available for use. It will need to be re-created if and when the publisher makes it available again.

Affected Databases and Instances

Database	Instance ID	Status	Error Type
NETHERLANDS_OPEN_MAP_DATA	sf009	❌ Failed	Database unavailable
NETHERLANDS_OPEN_MAP_DATA	sf013	❌ Failed	Database unavailable
AMAZON_VENDOR_ANALYTICS__SAMPLE_DATASET	sf029	❌ Failed	Database unavailable

Impact

• 3 instances (out of 547 total) cannot be executed
• 2 shared databases are affected
• Queries fail immediately during schema exploration or SQL execution

---

Reproduction Steps

Observe error when agent attempts to query NETHERLANDS_OPEN_MAP_DATA and AMAZON_VENDOR_ANALYTICS__SAMPLE_DATASET:

[SYNTAX_ERROR] SQL syntax error: 003030 (02000): SQL compilation error:
Shared database is no longer available for use.

---

Environment

• Snowflake Account:

• Database: NETHERLANDS_OPEN_MAP_DATA, AMAZON_VENDOR_ANALYTICS__SAMPLE_DATASET (shared database)
• Benchmark: Spider2-Snow
• Date Observed: 2025-12-24

---

Additional Context

Instance Details

sf009

• Question: Compare total surface area of buildings in Amsterdam vs Rotterdam
• Required Tables: NETHERLANDS_OPEN_MAP_DATA.PUBLIC.BUILDING
• Key Columns: CONTAINS_ADDRESSES, SURFACE_AREA

sf013

• Question: Compare total road lengths in Amsterdam vs Rotterdam
• Required Tables: NETHERLANDS_OPEN_MAP_DATA.PUBLIC.ROAD
• Key Columns: QUADKEY, CLASS, LENGTH

sf029

• Question: Generate a daily detailed sales report for each product under the 'Manufacturing' distributor view, covering the 30 days leading up to February 6, 2022
• Required Tables:
  • AMAZON_VENDOR_ANALYTICS__SAMPLE_DATASET.PUBLIC.RETAIL_ANALYTICS_SALES
  • AMAZON_VENDOR_ANALYTICS__SAMPLE_DATASET.PUBLIC.RETAIL_ANALYTICS_TRAFFIC
  • AMAZON_VENDOR_ANALYTICS__SAMPLE_DATASET.PUBLIC.RETAIL_ANALYTICS_INVENTORY
  • AMAZON_VENDOR_ANALYTICS__SAMPLE_DATASET.PUBLIC.RETAIL_ANALYTICS_NET_PPM
• Key Columns: Multiple metrics including ordered units, revenue, glance views, inventory data, vendor metrics

Logs

sf009 Error Log Excerpt

[SYNTAX_ERROR] SQL syntax error: 003030 (02000): SQL compilation error:
Shared database is no longer available for use. It will need to be re-created if and when the publisher makes it available again.

sf013 Error Log Excerpt

[SYNTAX_ERROR] SQL syntax error: 003030 (02000): SQL compilation error:
Shared database is no longer available for use. It will need to be re-created if and when the publisher makes it available again.

sf029 Error Log Excerpt

[SYNTAX_ERROR] SQL syntax error: 003030 (02000): SQL compilation error:
Shared database is no longer available for use. It will need to be re-created if and when the publisher makes it available again.

---