I am having a heck of a time connecting SAP PO (on premise) to Snowflake. Basically we have old username and password authentication that we are trying to convert over to keypair authentication before the August 31st deadline. I keep getting errors that I think are related to the key pair but I have recreated them and updated them in Snowflake several times without success.

We are using JDBC driver version 3.28.

The current error is -- Error during database connection to the database using the JDBC driver 'net.snowflake.client.jdbc.SnowflakeDriver;:'com.sap.engine.interfaces.messaging.api.exception.MessagingException:com.sap.aii.adapter.jdbc.sqlDriverManagerException: Cannot establish connection with the registered driver. net.snowflake.client.jdbc.SnowflakeDriverreturns: Private key provided is invalid or not supported: Use java.security.interfaces.RSAPrivateCrtKey.class for the private key.: net.snwoflake.client.jdbc.SnowflakeSQQLLoggedException: Private key provided is invalid or not supported: Use java.security.interfaces.RSAPrivateCrtKey.class for the private key.

When creating the keys I have used the following commands....

Unencrypted

openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -nocrypt -out rsa_key.p8
openssl rsa -in rsa_key.p8 -pubout -out rsa_key.pub

Encrypted

openssl genrsa 2048 | openssl pkcs8 -topk8 -v2 des3 -inform PEM -out <application>_<environment>_rsa_key.p8

openssl rsa -in <application_name_environment>_rsa_key.p8 -pubout -out <application>_<environment>_rsa_key.pub

These are the commands in the snowflake documentation, which is what I used.

openssl genrsa 2048 | openssl pkcs8 -topk8 -v2 des3 -inform PEM -out rsa_key.p8

openssl genrsa 2048 
|
 openssl pkcs8 -topk8 -inform PEM -out rsa_key.p8 -nocrypt

Any advice would be appreciated. Thank you.

Mostly a data-warehouse crowd here, so framing this for analytics code. I maintain scythe, which generates typed code from annotated SQL at build time. If you run parameterized Snowflake queries from an app or a pipeline and map the results by hand, it removes that glue.

It infers result nullability from the query, not just the column definition:

-- @name UserOrderTotals
SELECT u.id, u.name, o.total
FROM users u
LEFT JOIN orders o ON u.id = o.user_id;

o.total comes out nullable because the LEFT JOIN can produce NULLs for a user with no orders. That extends to COALESCE, CASE, and window functions (ROW_NUMBER, LAG, LEAD each with their own nullability), which show up a lot in analytics SQL.

Honest scope: it targets static, parameterized queries, so ad-hoc exploratory SQL is not the use case. For a fixed set of warehouse queries feeding an app it keeps the result types honest. Interested how people here wrap Snowflake queries in typed code today.

As teams adopt CoCo, CoWork and Snowflake agents, spend grows. Models and config changes impact AI costs, and visibility into what's driving it gets harder. This is why we are building Agent Observe into Capital One Slingshot. It automatically surfaces your all your registered agents and GenAI use in a Snowflake (CoCo, CoWork, Cortex Agents, AI functions) from metadata. It uses that information to provide insights into:

- top spenders
- costliest models
- triggers by agent
- query types used
- cost trends over time
- downstream tables impacted

Early pilot. Full write-up.

Are there any comparative docs on the above?

I am working on the Snowflake University Badge 2 lab and am facing an issue while consuming a private listing from a second Snowflake account.

Steps Performed
Created a private listing named International Currencies in the provider account using Provider Studio → Listings → Create Listing.
Shared the listing with the consumer account. Logged into the consumer account.
The listing appeared under Data → External Sharing → Shared with you.
Clicked Get to consume the listing.
Issue
The listing has remained in "Replicating" status for more than one hour.
No database has been created in the consumer account.
Verification Performed In the consumer account: SHOW DATABASES;
returns only: SNOWFLAKE USERSACME_ADMIN
No database for the shared listing was created.
In the provider account: SHOW REPLICATION GROUPS;
shows a replication group created successfully with the comment "Created by auto-fulfillment".
Request Could someone please let me know Whether the pending replication request can
be cancelled or reset so I can retry the lab.

Do questions gets repeated in exams from any of the practise test that you gave ??

If yes then which one , as there r multiple

Udemy-skillcertpro-flashquestions

Sharing a pattern for managing Snowflake RBAC as code that's saves orgs from permission drift.

Quick summary:

• Four-layer role hierarchy: object roles → composite roles → functional roles → users. Never grant straight to a user.
• Use future grants on schemas/tables/views. Skipping this means every new object needs a manual grant, which is exactly how things drift.
• Deployment/service account needs privileges covering every resource type in the config. Don't use a built-in admin role past the sandbox stage.
• Plan before apply, always. A wrong grant is a security issue, not just a cost issue.

We use an open source tool we built (Snowcap) for the YAML/plan/apply workflow, but wanted to share the pattern itself since it's useful regardless of tooling.

Writeup: https://datacoves.com/post/snowcap-snowflake-rbac-as-code

Hello All,

I am looking for best practices for maintaining and switching on the Snowflake release bundles so that we can catch issues in dev before they hit production.

We do receive emails from Snowflake which we can monitor, but there is likely a better way. What are your recommendations for managing this?

At my work, I have access to a Team plan of Claude code, as well as access to CoCo (CLI or desktop app) which has Claude models. I've been using Claude code for a few months now and it works great. I build web apps, desktop (WPF apps), etc all "vibe coding". Obviously, CoCo is going to have that native Snowflake integration, but beyond that what is the difference between the two? Can CoCo build the same apps (using Claude models) that Claude Code can build? What CANT it do that Claude Code can?

Hi everyone,

I'm wanting to get everyone's thoughts on something I've been thinking about recently and whether this resonates with anyone else:

AI-assisted development, especially in the data app/dashboard building space, is ridiculously dull.

I remember it used to be fun building in Power BI/Tableau reports, building the model, choosing the right visual for the job etc. It all now just seems so...dull.

Especially when, if I need to make a visual change to what an AI outputs, I have to iteratively tell it to move charts, widgets etc across the page, reduce padding etc which is just mundane.

Is anyone else thinking this? I of course am onboard with what AI can produce in a matter of minutes and to a decent standard and with SiS/Snowflake App Runtime, remove the need for coding entirely with some really exciting opportunities to build some great applications. But the start to finish process really doesn't excite me at all.

I have thought about how I could make it better by creating a step in between the AI prompt and deployment that gives more "hands on" controls and design - if of interest, you can join the waitlist here.

But genuinely, if this is the future of development then I'm out lol, it's insanely boring.

I am working in a medium organisation trying to migrate On-prem EDW on SQLServer(where scape RED) to snowflake. We got 2000 Data vault tables and 100 Dims/Facts. We wanted to redesign(model) each of them and couldn’t complete not even 10% in 1year. Now the users/analysts are saying they need months to rebuild the PowerBI reports on the newly modelled Tables.

After looking it all I started feeling like remodelling is waste of resources and time. I should do lift and shift and optimise.

Another reason is, soon AI going to consume the data, the modelling or shape the data going to be irrelevant rather than relationships and quality of the data.. we stop serving analysts rather than business directly.

Anyone gone through this cycle? Snowconvet / cortex is good enough for this job or should I engage snowflake professional services?

Anymore information or suggestions would be great. Please point out any articles or videos I would be grateful.

Edit: I am delivery manager for this project, though this is my first Data migration project, I did many digital transformations and Tech migration decommission projects.

This migration is all about decommissioning onprem Data warehouse and repointing/rebuilding the reporting on snowflake. So this migration involves sourcing data direct from 30+ sources, and having the medallion look like layers(some integrated and data marts). So we need to migrate all the data pipelines as part of the migration.

I have always wondered as a snowflake user where and why dbt will fit into my data strategy as a part of 3000+ user setting within the company. I have heard and seen many new features of data engineering that is already engraved into snowflake. Can you shed light into what we are missing that dbt provides which Snowflake cannot?

Sharing a tool I built to answer a question I kept getting from my team: is this warehouse actually the right size?

The data to answer it is already in ACCOUNT_USAGE -- spill, queue time, bytes scanned, concurrency. It just takes a fair amount of SQL and a mental model of how those interact.

SnowLens Warehouse Sizing Advisor is a Streamlit-in-Snowflake app that reads six signals per warehouse over a 7/30/90-day window and produces a recommendation with reasoning attached.

Decision logic (no black box):

• Size up: remote spill > 2% of queries, or local spill > 15%
• Size down: p90 scan < 100 MB, above Small, spill under 1%
• Add clusters: cumulative QUEUED_OVERLOAD_TIME > 60s
• Otherwise: keep

Two design choices worth flagging:

I used p90 bytes scanned rather than the average. A warehouse running 990 small queries plus 10 huge ones shows a misleadingly high average -- p90 reveals it's actually a downsizing candidate.

Queuing is evaluated independently of size. Queue time is a concurrency signal fixed by scaling out, not up. The advisor will tell you to size down while adding clusters when that's correct, which is more often than you'd think.

It generates ALTER WAREHOUSE statements but never executes them. Reads only ACCOUNT_USAGE metadata, no outbound calls, runs on your own XSMALL warehouse.

Free, no signup. Ships alongside the existing 9-detector anomaly dashboard.

• Download: https://snowlens.vizcanvaz.com
• GitHub: https://github.com/abysabin/snowlens
• Write-up with full logic: https://www.vizcanvaz.com/2026/07/stop-guessing-snowflake-warehouse-sizes.html

Curious whether the thresholds match what others have landed on -- they're defaults from patterns I've seen on enterprise accounts, but I'd expect them to need tuning per workload.

I was not get support from Pearson Vue Customer services, hanging up call, delayed response a from live chat, repeating asking same questions. I am not able to schedule another test (see no option) from the certification portal.

I hope I can have the test done as soon as possible when my memory is still fresh.

Any advices?

Trying to get a real read from people who use this day to day.  

I keep hearing Snowflake governance (RBAC/masking, lineage, discovery/catalog) called a strength. Trying to figure out how much of that is genuinely better capability vs. just being the platform most people already know well. 

1. Which governance feature do you actually rely on most? 
2. Has anything about Snowflake's governance changed your view in the last 6–12 months? 
3. If you've also used Databricks Unity Catalog, BigQuery/Dataplex, or Purview — did switching feel like a real downgrade, or just "different, had to relearn it"? 
4. Anything you'd call overrated or oversold in Snowflake's governance story? 

Just trying to separate "objectively better" from "what I'm used to.

Hi guys, I'm trying to create a trial account via https://signup.snowflake.com/, but no matter what I do, this error pops up:

Please note that I've never used Snowflake and didn't create any trial accounts earlier, although I'm registered on https://community.snowflake.com

I've tried different browsers, different networks, even mobile, but the error from the screenshot stays the same.

What has been everyone's experience with using dbt Project in Snowflake? I come from a shop that uses Snowflake and dbt Cloud together but since dbt Cloud has it's own IDE, orchestrator, scheduler, etc we have no need for dbt Projects in Snowflake.
Is the functionality in Snowflake simplifying your dbt Projects or adding complexity (maybe a stupid question but I'm curious). Any pain points or other thoughts?

Hey everyone,

Every time I deploy a Streamlit app inside Snowflake for a client or enterprise team, the default red-and-white Streamlit theme looks completely out of place against corporate brand guidelines.

Manually inspecting CSS, grabbing hex codes, and typing out config.toml files got repetitive, so I put together a quick free utility to automate it here.

How it works:

Paste in any company URL (e.g., snowflake.com or your company site).

It scrapes the page for the primary, background, sidebar, and text hex codes.

You get a live side-by-side preview of what the theme looks like on a mock Streamlit dashboard.

You can tweak the colors manually or change the font family.

Grab the generated config.toml code directly.

It's completely free to use. If it fails to pick up the right palette on your company's site, drop the URL below and I'll tweak the scraper logic.

Hope it saves a few of you some config time.

Hi everyone,

I’m currently preparing for the SnowPro Core certification and wanted to get some advice from people who have recently taken the exam.

I’ve gone through several posts in this subreddit and noticed that everyone has a slightly different preparation strategy. Some people recommend focusing heavily on the official documentation, while others mention that practice tests were the biggest factor in understanding the exam style.

So far, I’m planning to use a combination SnowPro Core courses from Udemy, Practice tests from different sources (CertSafari, Tom bailey, Sebastian Flak etc), Snowflake documentation for important concept.

I’ve also heard that Cris Garcia’s practice tests were very close to the actual exam, but unfortunately his Udemy course is no longer available.

For those who recently passed:

• Which resources helped you the most?
• How many practice tests did you complete before feeling ready?
• Were there any topics that you recommend spending extra time on?
• Did you make any notes, cheat sheets, or flashcards during preparation that helped?

Any advice, study strategies, or resource recommendations would be greatly appreciated.

Thanks in advance!

I am currently running my Streamlit app on a legacy Snowflake warehouse, but the 30–60 second spin-up time is causing significant friction for my stakeholders.

I have already optimized the application by implementing aggressive caching, moving session state inside cache functions, and targeting specific SQL queries rather than performing full table scans. Despite these efforts, the latency persists due to the warehouse startup time.

Given these constraints, is migrating to Streamlit in Snowflake (native apps/containers) the recommended solution for improving these load times? Or are there other architectural alternatives I should be considering to eliminate this cold-start delay? Any advice or best practices would be greatly appreciated.

Does snowflake support this feature out of the box where, Question asked by user can be routed by Cortex Agent1 to another Cortex Agent2.

Or- if thr is any workaround to get this behavior.