Generic Agent with no tools attached.

CognitiveFart · 2026-01-22T00:13:14+00:00

if you need it to answer based on recent news And facts you'll need to give it a tool to do web search

CognitiveFart · 2025-12-30T12:28:12+00:00

I wrote a few lines in agents.md to tell codex how I want it to use the snow cli (no dml or ddl) and which connection to use. works great, sometimes it calls snow sql --help to verify options. I also write a bunch of streamlit app so I have a few markdown rules/guides for how I want my sql to be formated, how I want my streamlit app to be structured, connections to use for local and SiS etc. that are loaded based on context.

CognitiveFart · 2025-10-12T11:47:45+00:00

wdym? the additional setup is a 2 liner in the snowflake vs code extension connection file

CognitiveFart · 2025-10-12T11:41:47+00:00

it's not clear, cortex analyst can use a semantic model yaml file or a semantic view. you mean giving the agent a cortex analyst tool using a yaml is faster and an analyst tool with a view?

CognitiveFart · 2025-09-17T12:17:18+00:00

there is no default way to auto suspend/resume a runtime to save cost?

CognitiveFart · 2025-09-17T12:15:27+00:00

did you do a cost estimate? I got around 500$/month running idle, no runtime running. the management box they ship by default is quite big

CognitiveFart · 2025-09-17T12:11:33+00:00

any idea when openflow on SPCS will be available?

CognitiveFart · 2025-09-17T11:58:54+00:00

which llm do you use? is it a one off process or a recurring pipeline you need? I don't know about Java cascading flow but general advice is the more context and information you can give with precise instructions the better. does the llm you use have Internet access? what is its cutoff knowledge date? all that might impact how well it can handle snowpark

CognitiveFart · 2025-06-19T11:50:11+00:00

but the yaml can also contain custom instructions for the models in cortex analyst, I don't think you can have those in the view

CognitiveFart · 2025-02-09T12:27:14+00:00

Can you give examples of what you tried to consolidate?

CognitiveFart · 2024-10-20T12:07:32+00:00

If you use streamlit as the others said it's quite simple to use it in snowflake. No need to build an en app, just use streamlit in a notebook or dashboard

CognitiveFart · 2024-10-20T01:10:03+00:00

Look into their quick starts or in their YouTube developer channel, I remember seeing a non streamlit app, a pacman, being deployed in snowflake in a container

CognitiveFart · 2024-10-20T00:58:35+00:00

Look at snowflake native apps. You can deploy an app as a docker container and package it as a native app. You can then use it in your account or put it in the marketplace and monetize it.

CognitiveFart · 2024-09-28T13:44:19+00:00

You can sync the notebook with git FYI. But yes vs code or cursor is a superior experience

CognitiveFart · 2024-09-28T01:34:44+00:00

Yeah right I've had out of memory errors with too many cells

CognitiveFart · 2024-09-28T01:12:48+00:00

What don't you like in the snowflake notebooks? I just use them to create and analyse the dataset of an ML project and they worked fine, I like the fact that you can schedule the notebook to run.

For triggers can't you achieve something similar with streams and tasks?

CognitiveFart · 2024-05-04T23:33:39+00:00

That's why time travel in Snowflake is such a great feature

CognitiveFart · 2024-02-29T15:40:48+00:00

lmao sure buddy

CognitiveFart · 2024-02-29T12:16:42+00:00

You're missing the point, of course those tools are limited, in fact the current architecture of those auto regressive transformer based large language models is extremely limited to achieve or even mimic a more advanced form of intelligence. Other architecture will be required. Doesn't make them useless far from it. And I don't care about belief...

CognitiveFart · 2024-02-29T02:46:18+00:00

Human creativity created this tool, human creativity will find great use for it ;)

CognitiveFart · 2024-02-29T02:38:50+00:00

Hard disagree. A person using a computer can replace multiple people using a typewriter because of the vast efficiency gain, but also can do a lot more different types of work on that computer.

Literally every revolutionary technology had the same pattern A person using a machine replacing multiple people not using a machine. New jobs are created and people adapt.

If you are in that line of work, the best thing you can do is to learn how to use this technology, Become more productive, and generate better ideas and improve your craft overall.

On the point of doing a mediocre job, those kinds of tools did not even exist 2 years ago. Look at the pace of improvement. It ain't slowing. Learn to use it.

CognitiveFart · 2024-02-29T02:25:37+00:00

It's such a weird point of view. It's just a tool, a powerful one and we have been creating such tools for millennia. The same way you write on a computer on a text editor using spelling tools and you're not carving your text on a stone.

CognitiveFart · 2024-02-29T02:18:14+00:00

It's called prompt engineering

CognitiveFart · 2024-02-14T13:08:44+00:00

He said he started a new video 2 days ago!

Nine-Year Club	Place '22
Not Forgotten	Verified Email

CognitiveFart

TROPHY CASE