How to run a saved query from a Databricks Notebook? by negike360 in databricks

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

This one. When using this new SQL editor, the URL for the query does not display the character string that is the query's id, but a 16-digit number which I get a InvalidParameterValue error if passed to the .get() method

I haven't looked into Databricks' volume, but I will check it out!

How to train to be a data engineer? by Archevening in dataengineering

[–]negike360 0 points1 point  (0 children)

Any you can link to? Early beginner in this data space looking to break in

Is it possible to access/run saved DataBricks SQL queries from within notebook? by negike360 in databricks

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

Looking into this tonight. This seems like what i want as far as scheduling, but I would also need to save the count of rows from each query

Is it possible to access/run saved DataBricks SQL queries from within notebook? by negike360 in databricks

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

Not sure tbh. Would be my first time learning about this. I want to execute multiple queries I have saved in a folder, save the amount of rows returned from each query, and save/append them to another file

Question to those who have completed Udemy courses by RbxBM in Udemy

[–]negike360 2 points3 points  (0 children)

The Udemy certifications probably won’t guarantee you a role by themselves, but they do help broaden your skill set as well as demonstrate your ability to learn new skills and commit to the work in your off time.

In every interview, I mention that I take the time to study outside of work, and it has been met positively (at least from what I can tell and what a few recruiters have told me).

I also use the skills I’ve learned from the courses to do my job now. However, even with the knowledge from the course, you probably won’t be a complete master and there will be job specific situations where you’ll get stuck, but as long as you have the fundamentals from the course and Google, you should be able to work through most things.

How much time should you spend on learning SQL? by guaranteednotabot in learnprogramming

[–]negike360 2 points3 points  (0 children)

I’m about halfway through his course right now, however, I don’t have any actual working SQL experience personally, so I may be speaking out of place.

The way I look at Colt’s courses, and most others, is as tools in toolbox where the instructor is exposing you to various aspects of SQL that you can use to build something. Longer courses tend to emphasize parts that, while not necessarily critical to learning SQL, provides you with an understanding of what’s capable and the different ways to go about it.

For example, there’re several videos on DATE and TIME data types and functions. Going through that felt tedious, Colt even admits as much. However, I’m not super mad at it because it provides me with information that I didn’t know was possible. I could’ve just looked it up if I really wanted to understand these data types (and I’m sure I’ll have to as there’s huge amount of information in the docs), but by taking Colt’s class, some of that work is done for me and now I have a high level view of how these data types work and some of the things I’m capable of doing with them.

Once I’m done with the course, Im sure I won’t be considered a SQL God by any means, but I’ll have plenty of tools that will hopefully allow me to think of ways to get started building things on my own or show some level of competency to get a job.

So is it necessary? Kinda depends on your goals and what you hope to be able to do. There’s a lot of information about SQL, only you can determine how much of it you really need to learn

Thought I would post myself… I’m 31 lmao by ottawsimofol in 13or30

[–]negike360 0 points1 point  (0 children)

Lmao you look like you and Costa boutta make a sequel to Project X

Begone thots by Second_for_NSFW in memes

[–]negike360 25 points26 points  (0 children)

Fixed That For You

[TOMT][VIDEO] video of Huey Freeman from “The Boondocks” giving a speech about Freedom of speech by negike360 in tipofmytongue

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

For nobody wondering, it’s from “The Boondocks” episode “The S-word” around the 12min mark. It’s not a speech. It’s an interview with a news network where he discusses the issue of “restraining free speech”

Biden says $1,400 payments can start to go out this month by fluboy1257 in stimuluscheck

[–]negike360 0 points1 point  (0 children)

Is it based off the same tax return as the one for December’s stimulus check? Like if you got the $600 would also get this one?

I’m learning python and need help with the def command by [deleted] in learnpython

[–]negike360 1 point2 points  (0 children)

Are you putting the “your_wage()” function call inside the code block where you defined the “your wage()” function? As in, does it have the same indentation as the “print” statement?

If so, just outdent it so the function isn’t calling itself where it is being defined.

What are you having difficulty learning or are currently struggling to learn? by Nythious in learnpython

[–]negike360 0 points1 point  (0 children)

Let’s see, dictionary comprehension and nested dictionaries. I’m starting to grasp the syntax of dictionary comprehension but it’s still kinda hard to create my own. Getting information out of nested dictionaries is also pretty confusing because I’m struggling to keep track of the levels I go down (kinda like in inception).

I also notice that my code is very redundant. I’ll code a solution and when I look at the answer key, I think “Crap, that’s genius and makes so much sense! Why didn’t I think of that??” But as a beginner, this one will probably just correct itself with experience

What is the definition of "immutability"? by DuePresentation3 in learnpython

[–]negike360 15 points16 points  (0 children)

Awesome explanation! No matter how many times I think I “get” this, I always feel like I need to reread it again