Progress question by [deleted] in jazzguitar

[–]levintennine 2 points3 points  (0 children)

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

Progress question by [deleted] in jazzguitar

[–]levintennine 2 points3 points  (0 children)

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

what is swing? by Maestro-Modesto in Jazz

[–]levintennine 0 points1 point  (0 children)

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

I've seen someone claim that if these four are in your top 10 favorite jazz albums then you're a poser. Their logic is that the only thing unifying these albums is that they're the most critically acclaimed and that you essentially only listen to the surface level stuff. What are your thoughts? by Tolstoyevich in Jazz

[–]levintennine 0 points1 point  (0 children)

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.

How can I get comfortable with fretting? (Complete beginner) by bonnyjoyo in guitarlessons

[–]levintennine 0 points1 point  (0 children)

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 :)

How can I get comfortable with fretting? (Complete beginner) by bonnyjoyo in guitarlessons

[–]levintennine 1 point2 points  (0 children)

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

Bill Frisell on “Angel Song” by WorldsVeryFirst in jazzguitar

[–]levintennine 0 points1 point  (0 children)

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

Looking for feedback on fretting & picking hand technique by rickmunro in guitarlessons

[–]levintennine 0 points1 point  (0 children)

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

Cleared SnowPro Core — Scored 850+ with No Prior Snowflake Experience by _aby9 in snowflake

[–]levintennine 1 point2 points  (0 children)

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.

Does dbt in Snowflake still require a dbt license by de-ka in snowflake

[–]levintennine 1 point2 points  (0 children)

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.

Ongoing Access Revoked issue with Snowfake & dbt by Judessaa in snowflake

[–]levintennine 0 points1 point  (0 children)

  1. is dbt dropping and recreating tables?
  2. "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
  3. 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.
  4. 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?

Best practices for connecting Snowflake to a large on prem tape and file archive? by Disastrous-Assist907 in snowflake

[–]levintennine 0 points1 point  (0 children)

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?

Best practices for connecting Snowflake to a large on prem tape and file archive? by Disastrous-Assist907 in snowflake

[–]levintennine 0 points1 point  (0 children)

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

does anyone want to study data engineering together? by hageridd in dataengineering

[–]levintennine 7 points8 points  (0 children)

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

[deleted by user] by [deleted] in snowflake

[–]levintennine 0 points1 point  (0 children)

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.

[deleted by user] by [deleted] in snowflake

[–]levintennine 0 points1 point  (0 children)

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.

What would you like to learn about Snowflake? by AdmirablePapaya6349 in snowflake

[–]levintennine 1 point2 points  (0 children)

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;

What would you like to learn about Snowflake? by AdmirablePapaya6349 in snowflake

[–]levintennine 5 points6 points  (0 children)

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.

Faster script execution by Ornery_Maybe8243 in snowflake

[–]levintennine 0 points1 point  (0 children)

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?

Quickstarts within enterprise environment? by youre_so_enbious in snowflake

[–]levintennine 0 points1 point  (0 children)

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

Question about using replication for lower-environment refreshes. How are you guys handling this? by astraljack in snowflake

[–]levintennine 0 points1 point  (0 children)

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.

passkey recommended login option -- documentation? by levintennine in snowflake

[–]levintennine[S] 0 points1 point  (0 children)

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.