article thumbnail

Data News — Week 23.42

Christophe Blefari

Tests are directly added in the SQL code at the column that is target. Rise of the data generalist: smaller teams, bigger impact — You don't need to convince me. Schema are interpreted from the folder structure (with DuckDB). lea understand the views relationships, you don't need a ref. As an echo of last bullet point.

article thumbnail

Data Architect: Role Description, Skills, Certifications and When to Hire

AltexSoft

This specialist supervises data engineers’ work and thus, must be closely familiar with a wide range of data-related technologies like SQL/NoSQL databases, ETL/ELT tools, and so on. To perform or supervise data modeling, data architects must have expertise at database administration and SQL development.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

15+ Must Have Data Engineer Skills in 2023

Knowledge Hut

SQL Today, more and more cloud-based systems add SQL-like interfaces that allow you to use SQL. Traditional data transformation tools are still relevant today, while next-generation Kafka, cloud-based tools, and SQL are on the rise for 2023. ETL is central to getting your data where you need it.

article thumbnail

The LLM Factory: Driven by Snowflake and NVIDIA 

Snowflake

Because the container is running inside Snowflake, organizations can provide users with user defined functions (UDFs) that can be called from SQL to run advanced processing inside the container without operational burden.

article thumbnail

?Data Engineer vs Machine Learning Engineer: What to Choose?

Knowledge Hut

Languages Python, SQL, Java, Scala R, C++, Java Script, and Python Tools Kafka, Tableau, Snowflake, etc. Data engineers play three important roles: Generalist: With a key focus, data engineers often serve in small teams to complete end-to-end data collection, intake, and processing.

article thumbnail

Audit_helper in dbt: Bringing data auditing to a higher level

dbt Developer Hub

Auditing tables is a major part of analytics engineers’ daily tasks, especially when refactoring tables that were built using SQL Stored Procedures or Alteryx Workflows. Easy and intuitive code : Because audit_helper relies on dbt macros, it was designed to be an intuitive tool that runs on simple SQL queries.

article thumbnail

97 things every data engineer should know

Grouparoo

34 Fundamental Knowledge Knowledge of fundamental concepts allows you to embrace change 35 Getting the “Structured” Back into SQL Tips on writing SQL. 95 Why Data Science Teams Need Generalists, Not Specialists Specialization can slow things down. Be adaptable. Other engineers must be able to reproduce your results.