article thumbnail

Data Engineering Weekly #181

Data Engineering Weekly

Hiring the Right Team : Start with generalists who possess both technical and soft skills. The blog compares the advantages of Javascript-stored programs vs. SQL-stored programs. In the data warehouse, the programming abstraction standard is around SQL and dataframes.

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.

Insiders

Sign Up for our Newsletter

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

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.

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

Snowflake Releases New Geospatial Innovations, Now with CARTO Workflows Integration

Snowflake

Introducing CARTO Workflows Snowflake’s powerful data ingestion and transformation features help many data engineers and analysts who prefer SQL. Making geospatial insights available to a broader audience With this bundle of product updates and partner tools, Snowflake addresses the needs of both expert developers and generalist analysts.

article thumbnail

10 Lessons from 10 Years of Innovation and Engineering at Picnic

Picnic Engineering

For instance, we developed frameworks like Define, Extract, Transform, Present (DETP) where analysts can use SQL to build personalized recommendations without the involvement of engineering teams. Our main learnings are that agility must be structured to scale, culture evolves (and thats ok!),

article thumbnail

Data Engineer Roles And Responsibilities 2022

U-Next

SQL – A database may be used to build data warehousing, combine it with other technologies, and analyze the data for commercial reasons with the help of strong SQL abilities. The job description for Data Engineers may require them to eventually specialize in one or more SQL kinds (such as advanced modeling, big data, etc.).