/* To persist statistics and disallow engine rebuilding with default sampling, set @WithNoRecompute = 1 */ | |
DECLARE @WithNoRecompute BIT = 1 | |
,@NoRecomputeSQL VARCHAR(50) = ''; | |
IF @WithNoRecompute = 1 | |
BEGIN | |
SET @NoRecomputeSQL = ',NORECOMPUTE'; | |
END; | |
DROP TABLE IF EXISTS #Temp; |
Paste in Settings > Rules for AI👇
`DO NOT GIVE ME HIGH LEVEL SHIT, IF I ASK FOR FIX OR EXPLANATION, I WANT ACTUAL CODE OR EXPLANATION!!! I DON'T WANT "Here's how you can blablabla"
- Be casual unless otherwise specified
- Be terse
- Suggest solutions that I didn't think about—anticipate my needs
- Treat me as an expert
- Be accurate and thorough
- Give the answer immediately. Provide detailed explanations and restate my query in your own words if necessary after giving the answer
-- ref: https://github.com/jimtodd92/airflow_metadata_mining/blob/main/airflow_metatdata_mining.sql | |
-- To get Critical user activities like paused and dagrun_clear in past 24 hours. | |
SELECT event | |
,DATE (dttm) | |
,count(*) | |
FROM PUBLIC.log | |
WHERE DATE (dttm) BETWEEN ( | |
SELECT max(DATE (dttm)) - 1 | |
FROM PUBLIC.log | |
) |
While there are a number of definitions, for our purposes, soft skills are all of the skills that are not technical. Meaning - the you that shows up the interview, as well as your technical ability. Your interview is composed of your technical prowess, as well as your soft-skills and ability to answer non-technical questions around teamwork, leadership, failure (yes), ability to adapt, timeliness, and communication skills.
If you have heard of the airport test - when hiring managers ask themselves would I want to be stuck in an airport with this person? - your non-technical stories will help them answer that question. In short: non-technical questions will ask you to tell a number of stories that supplement your technical mastery.
Interviews are subjective, based off of who’s interviewing you. When you prepare for soft-skill questions, understand the value that you can bring to a company as well as your goals and interests. You will deliver better answers and be more con
For many of you, this will be your first time negotiating. Perhaps some of you have never once considered negotiating, and have always accepted what the employer offered. While negotiation isn’t required, it’s often recommended. You should be compensated fairly for your valuable technical skills.
This section will cover a number of strategies to help you get the best compensation possible. You shouldn’t be out to take the employer for all they’re worth. Instead you should look for compensation that works for everyone involved. Negotiation offers the ability to dramatically increase your earning potential in a very short period of time! Negotiating in a way that is researched, open, and strives to create a win-win result for you and the employer tends to have the best outcome.
Effective negotiators understand the difference between negotiating and having a conversation. The conversation is everything that happens before the employer makes
{"_id":1,"_type":1,"_typename":"JOBGROUP","_name":"WEEKLY_DASHBOARD","_parentid":100,"_parentname":"\\DASHBOARD","_active":"Y","_effectivecalendarid":10,"_ownerid":1,"_ownername":"DASHBOARD-USER","_timewindowfromtime":null,"_timewindowfromtimeasstring":null,"_timewindowuntiltime":null,"_timewindowuntiltimeasstring":null,"_childrencount":5,"_agentid":null,"_effectiveagentid":10,"_extendedinfo":null,"_agentname":null,"_agenttype":null,"_agentostype":null,"_agentlistname":null,"_agentlistfullname":null,"_allowunscheduled":"Y","_inheritcalendar":"N","_inheritagent":"Y","_inherittimewindow":"Y","_parentactive":"Y","_command":null,"_allowrerun":"Y","_concurrency":1,"_concurrencytype":1,"_fullpath":"\\DASHBOARD\\WEEKLY_DASHBOARD","_parameters":null,"dependencies":{"totaldependencies":0,"dependencies":[]},"successors":{"totalsuccessors":0,"successors":[]}} | |
{"_id":2,"_type":2,"_typename":"JOB","_name":"DAILY_PROCESS","_parentid":101,"_parentname":"\\DASHBOARD\\WEEKLY_PROCESS","_active":"Y","_effectivecalendarid":11,"_ |
{ | |
"meta": { | |
"theme": "elegant" | |
}, | |
"$schema": "https://raw.githubusercontent.com/jsonresume/resume-schema/v1.0.0/schema.json", | |
"basics": { | |
"name": "Kin shah", | |
"label": "Senior Software Developer / Engineer at Bloomberg LP", | |
"image": "", | |
"email": "[email protected]", |
pip install apache-airflow-providers-mysql
error: subprocess-exited-with-error
× Getting requirements to build wheel did not run successfully.
│ exit code: 1
╰─> [24 lines of output]
/bin/sh: 1: pkg-config: not found
/bin/sh: 1: pkg-config: not found
async function scrollDown() { | |
const wrapper = document.querySelector("#search-page-list-container"); | |
await new Promise((resolve, reject) => { | |
var totalHeight = 0; | |
var distance = 600; | |
var timer = setInterval(async () => { | |
var scrollHeightBefore = wrapper.scrollHeight; | |
wrapper.scrollBy(0, distance); | |
totalHeight += distance; |