InternshipTools and first-week setup
The tools a Databricks & Snowflake intern uses and how to set up your workspace in week one.
These are the main tools for Databricks & Snowflake tasks. You do not need all of them on day one; the Level 1 tasks tell you when to install each one.
- Snowflake
- Databricks (Free Edition)
- PySpark & Spark SQL
- Delta Lake
- dbt
- Power BI / Tableau Public
- SQL
Set up your workspace
- Create a free GitHub account if you do not have one, with a professional username, and set up your LinkedIn profile: every task is submitted with a LinkedIn post.
- Create one repository for the internship, for example databricks-and-snowflake-internship, with a README that says who you are and what the repo holds.
- Keep one folder per task, named with the task number and title, so mentors find your work quickly.
- Commit small changes every day with clear messages. Your daily work report uses these commits as proof.
- Never commit passwords, API keys or personal data. Put secrets in a .env file and add it to .gitignore.
Your first tasks
| Task | What to do |
|---|---|
| Warehouses and lakehouses | In a repo named lakehouse-internship, explain data warehouses, data lakes and lakehouses, OLTP versus OLAP, and ETL versus ELT with examples. |
| Free accounts | Sign up for Databricks Free Edition and a Snowflake 30-day trial. Set Snowflake warehouse auto-suspend to 60 seconds and a resource monitor. Screenshot the setup. |
| SQL refresher | Write 10 SQL queries on a sample sales dataset: filters, joins, GROUP BY, HAVING, CASE and subqueries. |
| Window functions | Write queries using ROW_NUMBER, RANK, LAG and running totals to find each customer's latest order and month-on-month growth. |