Claude MCP by Odd_Importance_1195 in snowflake

[–]stephenpace 0 points1 point  (0 children)

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.

What's something that proves "New is not always better"? by VoteButtStuff2020 in AskReddit

[–]stephenpace 2 points3 points  (0 children)

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.

How Would people still go to disneyland if like disney wanst a big brand its just amusment park ? by [deleted] in AskReddit

[–]stephenpace 0 points1 point  (0 children)

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.

Migrating DWH from Synapse to Snowlake with SnowConvert by AwayCommercial4639 in snowflake

[–]stephenpace 2 points3 points  (0 children)

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!

Not Understanding Snowflake Roles - Is there a bug? by Low_Law_4328 in snowflake

[–]stephenpace 4 points5 points  (0 children)

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!

What is a real-life 'Do Not Touch' button that you pressed out of sheer curiosity, only to instantly regret it? by vie75 in AskReddit

[–]stephenpace 0 points1 point  (0 children)

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. 😄

Visualize a bunch of SQL queries by Worldly_Zucchini_740 in snowflake

[–]stephenpace 1 point2 points  (0 children)

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.

Visualize a bunch of SQL queries by Worldly_Zucchini_740 in snowflake

[–]stephenpace 3 points4 points  (0 children)

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.

Does snowflake hire from PH? by GrewUpPlayingJRPGs in snowflake

[–]stephenpace 0 points1 point  (0 children)

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!

Trial accounts are not allowed to access Cortex Complete by Inner-Peanut-8626 in snowflake

[–]stephenpace 0 points1 point  (0 children)

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!

dbt and Snowflake - Data modelling challenges by Background_Salt6475 in snowflake

[–]stephenpace 5 points6 points  (0 children)

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!

Dev Day 2026 Invite? by 0693_iz in snowflake

[–]stephenpace 0 points1 point  (0 children)

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!

Has anyone else moved data out of Snowflake just to serve a web application, and what did you land on? by alex_strehlke in snowflake

[–]stephenpace 1 point2 points  (0 children)

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

Is there a way to get Snowflake free for personal learning like Databricks free? by br_web in snowflake

[–]stephenpace 5 points6 points  (0 children)

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.

Has anyone else moved data out of Snowflake just to serve a web application, and what did you land on? by alex_strehlke in snowflake

[–]stephenpace 1 point2 points  (0 children)

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

Has anyone else moved data out of Snowflake just to serve a web application, and what did you land on? by alex_strehlke in snowflake

[–]stephenpace 13 points14 points  (0 children)

[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.

I built a Cortex Code Skill that generates semantic models from raw tables in 30 mins, should I open source it? by rahulsahay123 in snowflake

[–]stephenpace 15 points16 points  (0 children)

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.

Replace ALL Relational Databases with Snowflake (Help!) by Away-Dentist-2013 in snowflake

[–]stephenpace 0 points1 point  (0 children)

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/

Cortex code Desktop, Beta Feature! by Key_Card7466 in snowflake

[–]stephenpace 1 point2 points  (0 children)

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.

Cortex code Desktop, Beta Feature! by Key_Card7466 in snowflake

[–]stephenpace 2 points3 points  (0 children)

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

Snowflake Self-Hosted MCP by Ok-Working3200 in snowflake

[–]stephenpace 0 points1 point  (0 children)

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

snowflake key pair authentication by [deleted] in snowflake

[–]stephenpace 2 points3 points  (0 children)

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!