# dbt - Dasar (Data Engineering)

> Proyek dbt, models, sources, refs, tests, dokumentasi, materializations (table, view, incremental), seeds

- 20 pertanyaan wawancara
- Mid-Level
- [Pertanyaan Wawancara: Data Engineering](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara.md)

## 1. Apa itu dbt (data build tool)?

**Jawaban**

dbt adalah alat transformasi data yang memungkinkan menulis transformasi dalam SQL dan menjalankannya di data warehouse. Ini menerapkan prinsip software engineering (versioning, tests, dokumentasi) pada pekerjaan transformasi data. dbt tidak menangani ekstraksi atau loading (E dan L dari ELT), hanya transformasi.

## 2. Apa struktur dasar dari proyek dbt?

**Jawaban**

Proyek dbt berisi file dbt_project.yml di root yang mendefinisikan konfigurasi proyek. Folder utamanya adalah models (berisi file SQL), tests untuk tests kustom, macros untuk macro Jinja, seeds untuk file CSV, dan snapshots untuk capture data historis. File profiles.yml (biasanya di luar proyek) mendefinisikan koneksi ke warehouse.

## 3. Apa peran file profiles.yml di dbt?

**Jawaban**

File profiles.yml berisi informasi koneksi ke data warehouse (BigQuery, Snowflake, Redshift, PostgreSQL, dll.). Biasanya disimpan di folder ~/.dbt/ dan bukan di proyek untuk menghindari versioning credentials sensitif. Setiap profil dapat memiliki beberapa target (dev, prod) yang memungkinkan peralihan mudah antara environment.

## 17 pertanyaan lagi tersedia

- Apa itu model di dbt?
- Apa peran fungsi ref() di dbt?

Daftar gratis: https://sharpskill.dev/id/login

## Topik wawancara Data Engineering lainnya

- [Linux & Shell - Dasar-dasar](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/linux-shell-basics.md): 20 pertanyaan, Junior
- [Git & GitHub - Dasar-dasar](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/git-github-fundamentals.md): 20 pertanyaan, Junior
- [Python lanjutan untuk Data Engineering](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/python-advanced-de.md): 25 pertanyaan, Junior
- [Docker - Dasar-dasar](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/docker-fundamentals.md): 25 pertanyaan, Junior
- [Google Cloud Platform - Dasar-Dasar](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/gcp-fundamentals.md): 20 pertanyaan, Junior
- [CI/CD dan Kualitas Kode](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/ci-cd-code-quality.md): 20 pertanyaan, Mid-Level
- [Docker Compose](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/docker-compose.md): 20 pertanyaan, Mid-Level
- [FastAPI - API Data](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/fastapi.md): 20 pertanyaan, Mid-Level
- [SQL Lanjutan untuk Data Engineering](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/sql-advanced-de.md): 20 pertanyaan, Mid-Level
- [Data Lake - Arsitektur dan Ingesti](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/data-lake.md): 20 pertanyaan, Mid-Level
- [BigQuery untuk Data Engineering](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/bigquery-de.md): 20 pertanyaan, Mid-Level
- [PostgreSQL - Administrasi](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/postgresql-admin.md): 20 pertanyaan, Mid-Level
- [Data Modeling untuk Data Engineering](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/data-modeling-de.md): 20 pertanyaan, Mid-Level
- [Fivetran & Airbyte - Ingesti Data](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/fivetran-airbyte.md): 20 pertanyaan, Mid-Level
- [Apache Airflow - Dasar-Dasar](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/airflow-fundamentals.md): 20 pertanyaan, Mid-Level
- [Kubernetes - Dasar-Dasar](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/kubernetes-fundamentals.md): 20 pertanyaan, Mid-Level
- [dbt - Fitur lanjutan](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/dbt-advanced-de.md): 20 pertanyaan, Senior
- [Pola ETL / ELT / ETLT](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/etl-elt-patterns.md): 20 pertanyaan, Senior
- [Apache Airflow - Lanjutan](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/airflow-advanced.md): 20 pertanyaan, Senior
- [Airflow + dbt - Orkestrasi Pipeline](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/airflow-dbt-integration.md): 20 pertanyaan, Senior
- [PySpark - Pemrosesan Skala Besar](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/pyspark.md): 20 pertanyaan, Senior
- [Google Pub/Sub - Streaming Data](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/pubsub-streaming.md): 20 pertanyaan, Senior
- [Apache Beam & Dataflow](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/apache-beam-dataflow.md): 20 pertanyaan, Senior
- [Kubernetes - Produksi dan Penskalaan](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/kubernetes-advanced.md): 20 pertanyaan, Senior
- [Terraform - Infrastructure as Code](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/terraform.md): 20 pertanyaan, Senior
- [Database NoSQL](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/nosql-databases.md): 20 pertanyaan, Senior
- [Data Architecture Modern](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/data-architecture.md): 20 pertanyaan, Senior
- [Monitoring dan Observability](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/monitoring-observability.md): 20 pertanyaan, Senior
- [IAM dan Keamanan Data](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/iam-security-de.md): 20 pertanyaan, Senior

---

Source: SharpSkill (https://sharpskill.dev), tech interview preparation for your real stack.
HTML version of this page: https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/dbt-fundamentals-de