# Snowflake

The Snowflake platform is a fully managed service that's truly easy to use, connected across your entire data estate and trusted by thousands of customers.

### Setup Instructions

## Connect Snowflake to Your Xano Backend

Query your Snowflake data warehouse directly from your Xano function stacks using the External Snowflake Query function.

### How It Works

1. Add your Snowflake connection credentials in Xano  
2. In any function stack, add the **External Snowflake Query** function  
3. Write your SQL query to pull, filter, or aggregate data from your Snowflake tables  
4. Use the results directly in your API logic — join it with your Xano data, transform it, and return it to your frontend

### Use Cases

- Pull analytics or reporting data from Snowflake into a customer-facing dashboard  
- Enrich your Xano records with data stored in your warehouse  
- Build APIs that combine real-time Xano data with historical Snowflake data in a single response

### Tips

- Keep your Snowflake queries focused — pull only what you need to keep response times fast  
- Use Xano's built-in caching if you're querying Snowflake data that doesn't change frequently  
- You can parameterize your queries with inputs from your API request for dynamic filtering

[Learn more about the External Snowflake Query function →](https://docs.xano.com/the-function-stack/functions/database-requests/external-database-query#external-database-query)