@ Mentions
1. @ Mentions
Let's use Snowflake CoCo to explore a dataset containing student information. We can use the prompt on the screen to find the top performing students. Hmmm. This is strange. These students' names seem a little bit… fictional. Let's investigate to find what happened. Maybe if we see what SQL CoCo used to gather this information, we can find out what happened. This might be the problem. It looks like CoCo is querying data from a test database. This database is just used for testing and is probably filled with fictional data. Turns out that this Snowflake account has two databases: SCHOOL and SCHOOL_TEST. They both have similar names and similar data, so it is not a surprise that CoCo used the wrong one. We want CoCo to use the real SCHOOL database. How can we specify it? The way to do this is using @ mentions. You can use an @ mention to reference a specific Snowflake object. Here is a better prompt. This one specifies the exact database to use. With this prompt, CoCo will narrow in on the correct database and select the correct data. That looks much better. Using @ mentions can help narrow down a query and keep CoCo focused on the objects you want. Although CoCo usually does a good job at discerning what objects are important, @ mentions help ensure that it accesses the objects you want.2. Let's practice!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.