We should allow antiwork to remain what it had been for the past 6 years.

If it is a movement that we want then we need to agree on the goals and the rules.

Hi r/dataengineering, few months ago I've shared my takeaways of the Airflow Summit and this time I'd like to share takeaways from the dbt Coalesce 2021 conference. I really don't know if dbt is used by people in this sub but still I'm trying.

So, for people not used to it, dbt is a framework to organize and run your SQL queries on top of your favourite data warehouse. More and more companies are using it, the core project is open-source but they sell a Cloud version with and IDE and stuff to ease the deployment of your projects.

Also from the panel at the conference we can see that dbt is not a tool used by Fortune 500 companies. I would bet they often already have a internal system doing the same.

This year at the Coalesce we got 5 kind of talks:

• Food for thought — to help us seeing forward
• 101 talks about dbt or other concepts
• Feedbacks from companies implementing dbt
• Promotional content (often from the sponsors)
• Diversity talks about how we can be more open in the data field

Food for thought

• Erica from dbt explained why you should aim from self-service rather than Data as a Service, she also defined what is self-service and what you should measure to get it — Scaling Knowledge over Scaling Bodies
• Tristan had a chat with Martin Casado about investments in data and how big is this wave? — They talk about the fact that the Modern Data Stack is probably a déjà vu but still something changed because companies key differentiator now is data, before it was software. But after all isn't data software?
• Down with "data science" — I liked it because the key concept is that words have a meaning, job titles matters.

dbt

• Git for analytics engineers and how to build a mature dbt projects
• The metrics layer could be the next big thing when it comes to analytics. It means we have a middleware between our warehouse and our customer facing apps that holds metrics definition and that is able to answer quickly to every question. Benn described it and Drew (dbt co-founder) [gave us a glimpse of the dbt Server](http

August, 1965

Pan-Arabism is rife in all sectors of Libyan society, as its people watch other Arab nations prosper under the ideology while the west pilfers their newfound oil wealth. However, Libya’s strict laws around political activity has prevented effective organisation, with the most outspoken groups being students and trade unions, however they still tacitly support the King to prevent crackdowns or arrests by security forces. Therefore, although pan-Arab sentiment exists, it is a general feeling rather than a coherent and directed movement, lacking any credible leadership to channel the will of the people.

However, the secession of Egypt from the United Arab Republic has shaken the status quo, lighting a spark within Arab nationalist politics. Debate among Libyans had been occurring for years over whether Ba’athism or Nasserism was the formula to emulate for a successful Arab Republic. Although Ba’athism had been the most popular choice, due to the successes and longevity of the UAR under its guidance, Nasserism had been argued by some intellectuals as a more effective transitory state. The credibility of this concept was shattered by Nasser’s abandonment of the UAR for what was perceived as his own personal political clout, attempting to cement his own legacy independent of that of the UAR. Libyans viewed this as a betrayal of pan-Arab ideology.

In the days following the announcement, crowds gathered outside the Egyptian embassy, chanting and holding placards. These protestors brandished slogans denouncing Nasser and his movement as traitors to the Arab people and Western puppets attempting to support the Israeli agenda in the Middle East. As word travelled and numbers swelled, some protesters began to grow more upset with the Egyptian government, launching rocks and other projectiles at its walls. The small number of poorly trained police deployed to monitor the situation were unable to control the violence, prompting a much stronger deployment the next day. Although order was restored around major Egyptian business and the embassy by the end of the week, this further fuelled the sentiment felt by Libyans that the King was in the pocket of Western interests and ignorant of his constituents' demands.

The week of unrest had been a recruiting boon for Ba’athist elements in the country, who pounced on a chance to steer pan-Arab sentiment away from the charismatic personality of Nasser and into their sphere of influence. Underground cells ha

But this has been fun. Early release or not, the last 2 days have been interesting to say the least

Hi,

I've got a sql question that I'm struggling with wrapping my head around.

I've got two columns.

• Column A , can contain null values and the names A, B, and C
• Column B, can't contain null values and can contain A, B and U.

I want to say:

SELECT

Column A - If A Then Adam. If B then Brent and if C Then Collin. If Null go to Column B.

Column B - If A then Adam. If B then Brent if U then Unknown.

I know I can use the COALESCE function to give me the first non null value between the two columns... and this would be fine if I just wanted to leave the columns with A,B,C, or U... but since I want names to display rather than just the first initial, I'm having a hard time getting this down.

Can I wrap a Case function within a Coalesce function? and if so, whats the best approach to do that?

Hi, I use coalesce in the query below, however I get a blank cell instead of 'text to replace null'

This is in Snowflake. Could you please help.

select coalesce(year(date), ’999’ as year,
coalesce(geo_country, ‘grouping’) as geo_country,
count(id)
from <>
where date between <date> and current_date 
group by cube(1,2);

Qn 1: The output cell is blank for the sub total rows, since I am using coalesce, should the cell not be '999' or 'grouping'

Qn 2: For the first field, if I replace ‘999’ with a string, say ‘grouping’, I get an error message ‘Numeric value 'grouping' is not recognized’ How do I format to get ‘grouping’ in the cell instead of a blank cell.

Thanks so much.

Welcome to our twenty-fourth installment of Cool Query Friday. The format will be: (1) description of what we're doing (2) walk though of each step (3) application in the wild.

Let's go!

Coalesce

When we're talking CQF, we're all about overdoing it. This week, we're going to review the coalesce command. We can use coalesce to combine disparate fields into a single field name for easier time-lining. While it probably won't be something you use all the time, having this trick in the bag can help create nice, tight query output.

Seed Data

To start, I'm going to plant some simple seed data to work with. You can do this as well or, if you're very familiar with how Falcon organizes events, you can substitute in your own data.

Seed Data

On a test VM, I'm going to open cmd.exe and run the following command:

tracert -d crowdstrike.com

After this command executes, you can close out cmd.exe.

Next, I'm going to find this execution using Event Search:

event_platform=win event_simpleName=ProcessRollup2 ComputerName=ANDREWDDF9-BL FileName=tracert.exe

For the time being, enable "Verbose Mode" for your output (drop down located under the time picker). You should have output that looks similar to this: https://imgur.com/a/Z88Xso4. Make sure to switch out my computer name for yours.

Now that you've located the seed event, we want to pay attention to two values: aid and TargetProcessId_decimal. We now want to change our search to look like this:

aid=7ce9db2ac1da4e8fb116e494a8c77a2d 253714948641

The format is:

aid=<aid> <TargetProcessId_decimal>

Don't forget to swap in your aid and TargetProcessId values. This is where we'll begin.

Quick Refresher on TargetProcessId

When a process executes, Falcon records a ProcessRollup2 event with a TargetProcessId. I always refer to the TargetProcessId as the "Falcon PID." It is guaranteed to be unique for the lifetime of your endpoint's dataset (per given aid). When your executing process performs additional actions, be they seconds, minutes, hours, or days after executing, Falcon will record those events with a ContextProcessId value that is identical to the TargetProcessId. This is how we chain the events together regardless of timing.

Here is the scenario we're reviewing this week. You have located a process of interest. You really want t

The Fed’s recent 2018 experience and the medium- and long-term experience of the ECB and BOJ all point to a firm no.

Gold $2000 silver $45 by end of the year