What Is DBT and Why Is It So Popular – Intro To Data Infrastructure Part 3
Interviews for Top Jobs at dbt Labs
Talent Acqusition Partner Interview
I applied online. The process took 2 weeks. I interviewed at dbt Labs (Los Angeles, CA) in Jan 2022
Interview
The interview process consisted of a screener phone call, a brief presentation, three interviews with department leaders focused on specific themes such as ‘Adaptability,’ and a final interview with Tristan, the CEO. All of the interviews were straightforward. This role did not require SQL knowledge.
- Tell me about a time that you advocated for a candidate and they did not end up working out.
Sales Engineer Interview
I applied through a recruiter. The process took 4 weeks. I interviewed at dbt Labs (Boise, ID) in Jan 2022
Interview
The interview process itself was on par with most sales engineer interviews. Had a technical screen with SQL questions and a mock discovery/demo call.Here is the kicker, I was told that I crushed the technical and sales interviews. They were questioning whether they wanted to hire me because I am a conservative person and my political beliefs didn’t fit in with the company. The hiring manager literally had a meeting with me to tell me that the company is far left-leaning and that he didn’t know if I would “fit in.” Very disappointed to say the least. By far the most unprofessional thing I have had happen to me.
- How would you get the highest sales amount of each month from a table that has daily transactions?
36. How do I run models downstream of a seed? You can run models downstream of a seed using the model selection syntax, and treating the seed like a model. $ dbt run –models country_codes+
23. How can I see the SQL that dbt is running? To check out the SQL that dbt is running, you can look in: dbt Cloud: Within the run output, click on a model name, and then select “Details” dbt CLI: The target/compiled/ directory for compiled select statements The target/run/ directory for compiled create statements The logs/dbt.log file for verbose logging.
2. What are the configurations in a model? Configurations are “model settings” that can be set in your dbt_project.yml file, and in your model file using a config block. Some example configurations include: Change the materialization that a model uses – a materialization determines the SQL that dbt uses to create the model in your warehouse.
26. Can I store my models in a directory other than the `models` directory in my project? By default, dbt expects your seed files to be located in the models subdirectory of your project. To change this, update the source-paths configuration in your dbt_project.yml file, like so: dbt_project.yml source-paths: [“transformations”]
1. What is a model in dbt (data build tool)? A model is a select statement. Models are defined in .sql files (typically in your models directory): Each .sql file contains one model / select statement The name of the file is used as the model name Models can be nested in subdirectories within the models directory When you execute the dbt run command, dbt will build this model in your data warehouse by wrapping it in a create view as or create table as statement.
How to answer “why do you want this job” interview question
Answering this interview question can be a surprisingly tricky one, especially if you try to answer it without thinking about who your audience is and what they really want to know. If you want to learn how best to answer this question, you will need to consider both the needs of the company and your own career goals.
When asked the interview question “Why do you w…
Read more at Why Do You Want This Job?
The interviewer’s job is to hire the best candidate for a job role. Most of the candidates that make it to the interview stage are qualified for the job. So merely having the qualifications won’t be enough to separate you from the crowd.
Once you’ve been invited to the interview, it mostly comes down to a battle of who can sell themselves better. The better you are at convincing (or selling yourself), the greater the chances that you will be the one to get the job.
So, let’s walk you through proven ways to answer the interview question “why should we hire you”.
Formats disponiblesRTF, PDF, TXT ou lisez en ligne sur Scribd
FAQ
Is dbt a ETL tool?
It doesn’t extract or load data, but it’s extremely good at transforming data that’s already loaded into your warehouse. This “transform after load” architecture is becoming known as ELT (extract, load, transform). ELT has become commonplace because of the power of modern analytic databases.
What is dbt tool used for?
What is a dbt model?
Is dbt a good tool?
