Remove recent-articles
article thumbnail

Data News — Week 24.08

Christophe Blefari

— Apache Arrow is an awesome library that powers a lot of innovations in the data space in the recent years. JVM vs. SQL data engineer — There's a big discussion in the community about what real data engineering is. Is it DataFrames or SQL? Still, I prefer SQL/Python data engineering, as you know me.

Data Lake 130
article thumbnail

Data News — Week 23.24

Christophe Blefari

I'm now under the Berlin rain with 20° When I write in these conditions I feel like a tortured author writing a depressing novel while actually today I'll speak about the AI Act, Python, SQL and data platforms. The ultimate SQL guide — After the last canva on data interviews, here's a canva to learn SQL.

Insiders

Sign Up for our Newsletter

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

article thumbnail

Mythbusting: The Venerable SQL Database and Today’s Real-Time Analytics

Rockset

Rockset is the real-time analytics database in the cloud for modern data teams. So I don’t fault you for resisting my message, which is that the SQL database that came of age in the 80s still has a critical role to play today in moving data-driven companies from batch to real-time analytics. This may come as a surprise.

article thumbnail

Data News — Week 23.17

Christophe Blefari

At the moment we have a dbt Semantic Layer that correspond to YAML definitions and MetricFlow—which was Transform open-source project—that is able to understand the semantics to generates SQL. or employees (SQL writing or document drafting) ; either by improving actual AI stuff: search, discovery, information extraction.

SQL 100
article thumbnail

Offload Real-Time Reporting and Analytics from MongoDB Using PostgreSQL

Rockset

Offloading read operations to another database, such as PostgreSQL, is one option that accomplishes this end. After discussing what PostgreSQL is, this article will look at how to offload read operations to it. What Is PostgreSQL? This capability allows PostgreSQL to be used as a document database as well.

MongoDB 40
article thumbnail

How to Speed up Local Development of a Docker Application running on AWS

DoorDash Engineering

We needed to move quite fast during one recent expansion of our business, which required a local development experience that could keep up. We knew we’d be deploying a Docker container to Fargate as well as using an Amazon Aurora PostgreSQL database and Terraform to model our infrastructure as code. Node version >= 16.13

AWS 119
article thumbnail

How to Use ChatGPT ETL Prompts For Your ETL Game

Monte Carlo

So, don’t forget to review your ChatGPT outputs before leverage scripts or pushing any SQL code to production. Extraction ChatGPT ETL prompts can be used to help write scripts to extract data from different sources, including: Databases I have a SQL database with a table named employees.