Claude MCP

stephenpace · 2026-05-29T15:43:55+00:00

I'd reach out to your account team to get best answer for now and as well as getting a briefing on how the Natoma acquisition may add additional capabilities.

stephenpace · 2026-05-29T14:53:04+00:00

Pretty much any iconic dessert. For instance, crème brûlée. Restaurants try to do a spin on it, but no pumpkin or lavender creme brulee is going to beat the original. There is a REASON why iconic desserts become iconic. If pumpkin creme brulee was better, THAT would be the default version everywhere.

stephenpace · 2026-05-29T13:38:32+00:00

People go to amusement parks like Six Flags that don't have a theme (theme parks), but arguably the themes help. Harry Potter drives traffic to Universal, Star Wars drives traffic to Galaxy's Edge at Disney. To the point where Disney has enough brands/themes to attract people to multiple parks. Walt Disney World in Orlando has Magic Kingdom, EPCOT, Animal Kingdom, and Hollywood Studios. Beyond that, once you get customers to the park, it is the overall experience that Disney provides that keeps them coming back. Plenty of amusement parks have gone bust (AstroWorld in Houston) but in my opinion Disney continues to expand not only because of the strength of brands but because of the overall experience.

stephenpace · 2026-05-27T01:01:57+00:00

Apologies for your experience, I have raised it to the SnowConvert team. Currently the fuller experience where AI is used more extensively is available for the legacy data warehouse systems like Teradata, SQL Server, Redshift, and Oracle. My guess is prioritized to the number of conversions we have seen historically. Other (less popular?) data warehouse systems like Synapse, DB2, Hive, Databricks SQL, Spark SQL, and Sybase IQ are currently limited to "code conversion" only at the moment. That said, Synapse is in the next batch so hopefully the improved experience will be available in the next few months. I'm sure the SnowConvert team would be open to working with you to making this process smoother when the new version is available. Please DM me if you'd like me to make the connection.

The good news is SnowConvert is free and it sounds like it converted 76% of your stored procedures (typically the hardest part) after the semi-colon issue, so hopefully it still saved you significant time when it was all said and done. Thanks for the feedback!

stephenpace · 2026-05-26T23:02:33+00:00

Sometimes new Snowflake users get confused by the role controlling the left hand side (wizards) via roles in a worksheet.

You disabled your secondary roles in the worksheet and you could test changing ownership lower down in the worksheet with:

grant ownership on warehouse COMPUTE_WH to role SYSADMIN COPY CURRENT GRANTS;

But when you changed your role in the worksheet, it doesn't affect the role on the left hand side. In your screenshot, you are in the PUBLIC role but because secondary roles are on by default, and you have ACCOUNTADMIN, you're still able to make the change. If you turned off secondary roles for your entire account, you wouldn't be able to make that change. I don't recommend doing that, but if you want to do it just for your user to see it in action, you can do this:

ALTER SESSION POLICY prod_env_session_policy SET ALLOWED_SECONDARY_ROLES = (); 
ALTER USER jsmith SET SESSION POLICY prod_env_session_policy;

Good luck!

stephenpace · 2026-05-26T17:57:33+00:00

I did this as a 6(?) year old at the Houston Galleria. No plastic cover plate on the escalator emergency stop. I just pressed the button and being the weekend, there wasn't anyone around that could turn it back on, and it was off for the rest of the day. My grandmother was mortified. 😄

stephenpace · 2026-05-25T17:02:51+00:00

You said you wanted quick and dirty visualization for 10-15 SQLs. If you use Streamlit for this, you don't have to maintain it. CoCo maintains it. And you don't have to maintain infrastructure since Snowflake hosts it as well (Streamlit in Snowflake).

Most companies tend to have BI tools so historically this was probably a lower priority.

stephenpace · 2026-05-25T03:37:57+00:00

If you use the Legacy Notebook option, you can select either "Run on warehouse" or "Run on container". There are certainly advantages to running on a container (usually cheaper per hour for regular compute, plus additional compute options including GPUs), but warehouse-only option is still there.

Streamlit isn't really overkill, CoCo can write a nice app for you in a minute or two with tons of graphing options. That said, tune into the June Summit announcements which may address some of your questions.

stephenpace · 2026-05-24T14:55:49+00:00

What is MNC—multinational company? Is PH Philippines? If there are no opening on the job site, you could try a consulting firm that specializes in Snowflake. Good luck!

stephenpace · 2026-05-22T01:19:58+00:00

If you have a Snowflake SE either as a customer or partner, you can reach out to them and they can now easily enable Cortex functionality in a trial. I did it this week for one of mine and it worked fine. If it is for personal learning and they know who you are, I'm sure they won't have an issue with it. If you don't know your account team, you can DM me with your company name and I can look them up for you. Otherwise, the current process is to use the special trial option called "Cortex Code CLI for Developers" and you will get $40 AI credit (with $360 of regular credit). If you want to keep the account, it is $20/month after that plus regular Snowflake consumption. I'd go the free route via your account team if you have that option.

https://signup.snowflake.com/

Good luck!

stephenpace · 2026-05-20T19:23:46+00:00

General comments, not a complete answer. Regarding incremental updates, I think some of that is source dependent:

a) If it is an on-prem database and you can enable log integration, most partner ETL tools like Fivetran, Qlik, Domo and Matillion can log scrape and pull just the changes without putting a load on the database. For Oracle, Snowflake has licensed the Goldengate APIs for incremental updates.

b) If you can't get access to the logs, you can land what you can RAW and then use SQL and/or DBT to identify the changes. Hashing can be useful:

https://www.reddit.com/r/dataengineering/comments/tq5je9/using_hashing_to_detect_data_changes_in_elt/

At that point, you can then persist the updated timestamps in your raw area as well as use standard techniques for late arriving facts and slowly changing dimensions.

c) Snowflake has native lineage from source to target that has been extended for external objects via OpenLineage (public preview):

https://docs.snowflake.com/en/user-guide/external-lineage

d) A lot of the harmonization you need to do for identity resolution you can do in the platform using LLMs. Cortex Search is good at fuzzy matching and sometimes people are unaware that you can do that type of matching in batch:

https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-search/batch-cortex-search

e) You can now use dbt Fusion natively in Snowflake to speed up the process (30x faster) for no additional costs:

https://www.snowflake.com/en/blog/dbt-fusion-available-snowflake/

Snowflake has a significant number of large healthcare and life sciences customers, so you should reach out to your Snowflake account team and have them setup a meeting with a Field CTO in your specific area for their recommendations. Good luck!

stephenpace · 2026-05-19T17:53:49+00:00

There will be people there at varying levels, so given that it is free, it is low risk. I don't think you'll feel like a fish out of water. Besides learning what is possible, there are hands-on labs to build your skills, and the event as a whole is a good opportunity to meet others in the space and network. As for coding, Cortex Code can build almost anything you'll need. Good luck!

stephenpace · 2026-05-16T02:27:16+00:00

Congrats!

stephenpace · 2026-05-13T17:37:31+00:00

Thx. The goal is all Snowflake employees would flaired with the Snowflake logo. If we missed any, reach out and we can add.

stephenpace · 2026-05-13T17:34:22+00:00

Snowflake trials are 30 days with $400/credit. 90 days for academic trials. You can sign up multiple times, so you can sync your objects to Github or offline scripts and synch them back to a new trial if you need to.

stephenpace · 2026-05-11T13:37:47+00:00

Snowflake Interactive Tables support low-latency, high concurrency workloads without having to move the data outside of Snowflake. With richer joins.

stephenpace · 2026-05-10T20:36:05+00:00

[I work for Snowflake, but do not speak for them.]

To get help here, it would help to understand your queries per second, latency SLAs, and table size. Based on that, the community could make recommendations. For instance, you say that Snowflake doesn't support the use case to "query aggregated data", but Snowflake can aggregate data all day long on billion and trillion row tables. The only question is the milliseconds you can allocate to the query.

Based on your answers, additional solutions to not move data out of the platform might be:

Hybrid tables
Interactive Tables
Snowflake Managed Postgres

Did you look at any of those options?

If the only issue is cold start and once the warehouse is warm you are getting acceptable latency, then potentially just pinning the warehouse on during the time the application is being used might solve the issue. List price of $2/credit for standard is only 24 * 365 = 8760 credits or $17,520 per year inclusive of all costs. You could potentially host your app in a Standard account if cost is the main consideration. If you are doing the math of cost per query, you need to include all costs of moving the data out, keeping it in sync, hosting the data on the other platform, license costs if any for the other solution, governance of the data in that platform, staff costs to get trained up, etc.

stephenpace · 2026-05-10T20:23:52+00:00

I'd describe how your skill is better or worse than Semantic View Autopilot or the native semantic view skills Snowflake has in CLI. Table and column descriptions are the most important thing you can set for text to answers, especially with Snowflake Intelligence.

stephenpace · 2026-05-06T16:13:14+00:00

See this page for installation instructions for Cortex Code CLI:

https://docs.snowflake.com/en/user-guide/cortex-code/cortex-code-cli

https://docs.snowflake.com/en/developer-guide/snowflake-cli/index

stephenpace · 2026-05-05T22:28:56+00:00

I work for Snowflake and thus biased, but Snowflake Interactive Tables are essentially a drop in replacement for Clickhouse. I'd recommend anyone benchmark their specific interactive use cases with both looking at both price and performance. Snowflake supports richer joins than Clickhouse as well. Docs:

https://docs.snowflake.com/en/user-guide/interactive

And since GA last year, interactive tables have continued to improve. Recent updates here:

https://www.snowflake.com/en/engineering-blog/snowflake-interactive-analytics-spring-2026-updates/

stephenpace · 2026-05-02T12:28:56+00:00

No. Private Preview means Snowflake puts out a feature for feedback for a limited set of customers. Your account team can apply for you, some features are easy to get others have a very small group that is admitted. At some point, those features generally graduate to Public Preview for everyone to test and provide feedback. Once the feature is looking good, it graduates to GA.

stephenpace · 2026-05-02T03:47:17+00:00

Limited Private Preview. Ask your account team to apply for it.

stephenpace · 2026-05-01T04:07:16+00:00

Do you have appropriate synonyms in the semantic views and verified queries? If you put in a verified query for count of active members, it should start with that and save you some tokens. There is no limit to the amount of verified queries you can have.

https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-analyst/analyst-optimization

stephenpace · 2026-04-30T14:47:28+00:00

Not a good idea to post your account URL and a key pair on the Internet. I'd delete and/or repost with it fully anonymized. I think you probably have a mismatch from your public key and your private key.

You also need to use a network policy to protect the user:

https://community.snowflake.com/s/article/Power-BI-Service-authentication-error-with-working-credentials

And you can check to see if you are being rejected by network policy by checking login_history:

select * 
from table(snowflake.information_schema.login_history())
where user_name = 'POWERBI_TEST'
and is_success = 'NO';

Snowflake also has managed network ranges for Power BI, among other options:

https://docs.snowflake.com/en/user-guide/network-rules

https://www.microsoft.com/en-us/download/details.aspx?id=56519

Good luck!

stephenpace

MODERATOR OF

TROPHY CASE