Retrieve column names and data types for data lake tables to understand table structure and write optimized queries in Snowflake.
Python
Apache 2.0
456,944 tools. Updated 2026-08-14 06:31
"How to query data from a Snowflake database" matching MCP tools:
- Retrieve complete details for a Snowflake connected tag by its group ID, including masking configuration, status, database info, and timestamps.GPL 3.0
- Creates an empty masking policy for a tag to control how tagged data is masked. Supports Snowflake and Databricks with platform-specific tag handling.GPL 3.0
- Delete a Snowflake tag from ALTR after removing all associated policies. For Databricks, use delete_policy instead.GPL 3.0
- Register a Snowflake tag in ALTR to enable its use in masking policies and tag management.GPL 3.0
- Search Snowflake query audits using filters like tags, columns, users, and roles to find tag-based or column-based masking events. Returns a search identifier for retrieving results later.GPL 3.0
Matching MCP Servers
- AlicenseCqualityCmaintenanceMCP server that renders bar, line, and pie charts from data using QuickChart, returning PNG file paths.1275MIT
- Alicense-qualityDmaintenanceA versatile tool that enables querying and exporting data from multiple relational databases (MySQL, PostgreSQL, Oracle, SQLite, etc.) in read-only mode for data safety.12Apache 2.0
Matching MCP Connectors
Architecture-grounded query for AI agents. Governance constraints, system dependencies, evidence.
Search Argus HQ public FDA enforcement data: warning letters, recalls, approvals, 483s.
- Retrieve the numeric ALTR database ID for a database name, required to initiate classification jobs.GPL 3.0
- Connect a new data source to ALTR with keypair or password authentication. Supports Snowflake, Databricks, and OLTP databases.GPL 3.0
- Remove a tag mask from a Snowflake column using database, schema, and tag name instead of a tag group ID.GPL 3.0
- Retrieve Snowflake service user IDs required for keypair authentication when creating database connections.GPL 3.0
- Retrieve full masking configuration, status, and timestamps for a specific Snowflake tag using database, schema, and tag name. Use when you know the exact tag but not the tag group ID.GPL 3.0
- List Snowflake databases connected to ALTR and retrieve their IDs for classification jobs.GPL 3.0
- Run database-native EXPLAIN on a SQL query to inspect the query plan, revealing whether it will scan excessive data before executing the real query.Apache 2.0
- Export anonymized, prioritized, and stitched historical data from Cold Storage DB to enterprise warehouses like Snowflake, ClickHouse, or BigQuery.MIT
- Query data from Hologres databases using SELECT SQL statements to retrieve specific information for analysis and decision-making.Apache 2.0
- Execute a read-only SQL query via a Preset database connection to verify query functionality before dataset creation. Supports SELECT, SHOW, DESCRIBE, and EXPLAIN statements.MIT
- Execute SQL queries on data product output ports to retrieve business data while enforcing governance policies and access controls, with support for Snowflake and Databricks.MIT
- Execute SQL on Snowflake through the omni-dev daemon, returning result sets as YAML. Supports multi-statement scripts and optional per-query warehouse, role, database, and schema.BSD 3-Clause
- Configure a new database source in the configuration file, including optional connection testing. Supports SQL Server and Snowflake via linked server.GPL 3.0
- Retrieve comprehensive details for a specific Snowflake query, including warehouse size, elapsed time, bytes scanned, rows produced, and error messages, using its QUERY_ID.MIT