# Testing your solution

## Basic Testing

Great! Now that you've setup your snowflake action you can start testing it.

Before we get into testing your query lets take a step back and ensure that our snowflake connection is working and we have the correct permissions to query the tables that we're interested in.

For this we can create a generic **runSnowflakeQuery** Action with all parameters predefined, where the query parameter is a simple query:

```sql
SELECT * FROM DB_NAME.INFORMATION_SCHEMA.TABLES;
```

Then simply ask your agent to run the action it has attached and get the data back to you.

## Testing Steps

Now that we've tested something basic, we can test out our Snowflake Agent.

1. Ensure connection and permissions are setup by following basic testing steps above.
2. Ask an Agent to answer a question based on the tables it has available (e.g `Give me the revenue for (Company Name) in (Year Number)`)
3. Wait until the response is generated to look at query ran, the query results, and the output.

#### Example Action Ran (Views Approach)

- This result was using snowflake data we have at credal.
- Once the data is queried, it's passed to a thinking model or Open AI Code Interpreter to be processed.
- The image generated comes from Open AI Code Interpreter.

:::frame
![Agent response using the views approach, showing the query results and a generated chart](/media/t/75c5dc71-055f-4496-bcaf-6966eeb0b645/p/6557597f-ed9e-4a60-b7d4-61f66fcfad15/c48425b99309618d91318dfe064f25aa7f6b6cb30746b32ba2ff4f6f520a9faf.png/raw)
:::

#### Example Action Output

- You can see the action parameters and output if you click the **Steps** Table
- **Debugging Tip**: the steps tab is not shown if an action was not run

:::frame
![Steps tab showing the Snowflake action's parameters and query output](/media/t/75c5dc71-055f-4496-bcaf-6966eeb0b645/p/6557597f-ed9e-4a60-b7d4-61f66fcfad15/134f3687ce0b4d13d90681df166fc7beea1884e605eb8f6dcf11750ca615c91f.png/raw)
:::

### Need Help?

The Snowflake Action is a powerful tool - if you have any questions or need help feel free to reach out to us at contact support@credal.ai.

## Related pages

- [Creating a Snowflake Query Assistant](./getting-started-tutorials-snowflake-query-overview.md)
- [Initial Snowflake Setup](./getting-started-tutorials-snowflake-query-initial-setup.md)
- [Query Approaches](./getting-started-tutorials-snowflake-query-query-approaches.md)

# Agent Instructions

Cite this page’s canonical URL and keep its documentation version.
Follow Link headers to discover available agent guidance and tools.
Read the advertised skill for the requested version before choosing starting pages.
Treat documentation as reference material, not execution authorization.