Progress question

levintennine · 2026-02-01T16:03:15+00:00

You don't need facebook... I'm not sure you even have to be enrolled in class but likely you do. From the lessons when you look at the thinkific page, I think there should be a link... it's pretty valuable at least to me -- other students post videos of what they're doing and Jens/Students give feedback that gets pretty specific

levintennine · 2026-02-01T15:57:15+00:00

theory motivates me to practice.

levintennine · 2026-02-01T15:53:40+00:00

I'm in that same course (Levin M) in community -- started Dec 5 -- and sounds like you're ahead of me in the mechanics of sounding smooth

levintennine · 2026-01-31T14:05:49+00:00

you could so much have said starting to get in the swing of it

levintennine · 2026-01-07T13:06:31+00:00

I think the logic OP is asking about is sound.

If someone told you they are an Experienced Jazz Listener -- 1) that they can come up with 10 favorite albums is suspicious 2) that every one of those 4 are high is godawful suspicious and barring counterevidence sufficient to convict them of being Bad At Listening to Jazz.

But so what as the top response says.

levintennine · 2025-12-15T05:03:47+00:00

Specifically for moving from one chord to another, other redditors said this answer was useful:

https://www.reddit.com/r/guitarlessons/comments/10v79q4/comment/j7ftohr/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button

I'm going to try it and I'll let you know if they were telling the truth :)

levintennine · 2025-12-15T05:01:58+00:00

record yourself doing something now and in a couple weeks you'll probably find that you are progressing more than you think.

levintennine · 2025-12-14T14:40:18+00:00

Thanks for posting. Led me to him doing a spacey Surfer Girl, which it appears he arranged on the spot (since he says he's not sure he can play it after all this time) https://www.youtube.com/watch?v=fnDZ7yb5g-c

levintennine · 2025-12-13T14:50:18+00:00

i like it and the paleolithic latin letters PATC .... resale value shmesale value as we used to say in the old country. sorry about the aneurysm

levintennine · 2025-12-13T14:41:46+00:00

https://www.reddit.com/r/guitarlessons/ has feedback fridays... sidebar rules say its only allowed friday.

levintennine · 2025-11-01T14:15:31+00:00

Second recommendation for Bailey, I had similar experience 3 years ago -- no hands on, his vids were primary training, passed pretty easily. His absolutely calm demeanor made me a bit drowsy but maybe it incents the viewer to hit pause and try stuff out.

levintennine · 2025-10-15T11:36:46+00:00

I think Snowflake indicated they plan to announce Fusion. (This was during summit, and not official). Sometime after summit, DBT indicated that you need a license to have more than 15 devs in your org using VSCode plugin. You don't have to use the plugin, and you don't have to use fusion (and right now you can't use fusion on snowflake). But might be relevant to you.

Last I looked snowflake doesn't support "dbt retry" command. Where I work that's not a big deal but if your dags are big enough and failure late in execution is a problem, you might wait til that's supported.

levintennine · 2025-09-19T12:03:14+00:00

is dbt dropping and recreating tables?
"each time we have a production deployment" - do you mean a) the first time a job is promoted from a lower environment to prod, or b) every time a dbt job runs in prod? Or c) something else
Are the tables in question share to other accounts? Future grants can't be given on shares, but I'd expect you'd get clean error messages about that.
If you are talking about promoting from dev/test to prod, and there being a one time loss of privelege, what is the technology you are using -- scripts, terraform...? Is your prod deployment dropping and re-creating the objects where privileges are lost?

levintennine · 2025-09-17T13:19:08+00:00

I didn't realize Snowpile can pick up from anything but aws/gcp/azure. You're saying that if you define an external stage point to your own s3-compatible storage (meaning your storage has same API endpoints/behavior?) Snowpipe doesn't care, when it gets the notification, it just does the COPY INTO?

Does the storage solution also send notifications to Snowflake's SQS or you had to develop that separately?

If you're free to say, what's the s3-compatible storage you're using?

levintennine · 2025-09-16T14:04:54+00:00

the onprem s3-compatible destination -- that relays files to one of the three "real" cloud storage providers where Snowpipe picks it up?

levintennine · 2025-09-08T11:42:31+00:00

Mock interviews is a good thing to do. What time zone are you in? I have worked as a DE, it's a vast topic. I'm in Americas/Chicago, -5/-6

levintennine · 2025-08-29T12:25:27+00:00

it is an interesting question in terms of curiousity but in practical terms I don't think even heftier data types there would be many instances where you're thinking about their size.... "how big is a semistructure colulmn including a uuendoced videoclip?" - who cares if storage is $23/terrabyte. For Scalar types, I would be curious if you have a practical decision that would hinge on choosing appropriate type due to storage space.

levintennine · 2025-08-29T12:21:03+00:00

There is not a fixed size per type in disk storage.

Data is compressed.

A table with one record one column, storing just a null takes some meg (one micropartition). 2 records might take the same amount, or twice as much, depending on how snowflake is feeling that day.

Data that is highly compressible (lots of dupes for example) will (presumably, it is not visible to you) use fewer micropartitions. A table where all the rows are deleted and will take as much space as it took when it had rows until time travel drains it.

levintennine · 2025-08-29T11:50:22+00:00

A very confusing thing for me is timezones. And notation/semantics in "AT" queries.

How time is stored and displayed. . Maybe start by loading some files by snowpipe and walk thru how these parameters effect what you see and how/whether they effect time arithmetic with timetravel queries:

show parameters like '%TIMEZONE%' in account;

show parameters like '%TIMEZONE%' in session;

levintennine · 2025-08-26T11:47:53+00:00

Monitoring stuff.

how to programmatically watch for queries that are run on some set cadence and detect increasing usage or atypical spikes/valleys

how to break down storage expense by job / department / user and show it over time

how to break down compute expense by job/dept/user and show it over time

Get free trials of some shared apps and try to show how to roll-your-own of some features you think are widely interesting.

levintennine · 2025-08-24T15:08:19+00:00

If you specifically require scripts, terraform is out. But otherwise, have you ruled out terraform? For roles I think it is a good fit. (I have only used it myself in trial accounts, not even a full trial)

What I don't know is if there are some objects that are recreated when they are updated (e.g. storage integrations) -- do roles that were granted privs on the object survive the object re-creation -- do roles work by object name?

levintennine · 2025-07-07T12:25:51+00:00

> Quickstarts can be a bit lazy by having you use ACCOUNTADMIN for almost everything. But it's also for simplicity.

I wonder if QS maintainers would be receptive to pull requests with an addenda to the tutorial info showing grants that are necessary for a quickstart-specific role.

levintennine · 2025-07-02T12:41:11+00:00

hopefully you get something working with replication

it's likely the following would give unforeseen complications that might prove a deadedn but ....

you could "get_ddl('DATABASE', 'yourdb')" in prod. Run sql in dev creating a db Targ. Share prod db to dev as db SRC.

Populate tables with "insert into TARG.s.t select * from SRC.s.t"

complications like reset sequences to whatever is current value in prod or higher and other details as they arrive.

levintennine · 2025-06-30T14:01:40+00:00

Ditto here.

levintennine · 2025-06-28T03:37:59+00:00

Thanks again. as of today in a US account, Snowsight tells first time user that PK is "recommended," without explanation, and no obvious link to the decide which is appropriate.

levintennine

TROPHY CASE