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

Data News — Week 23.27

Christophe Blefari

I'm working for the Series of articles in advance for August about "creating data platforms" and I'm looking for ideas about the data I could use for this. The idea, is then, to use the semantics to generate SQL queries. You can read my article on the semantic layer. Who's leading the data peloton?

Kafka 130
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.

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.

article thumbnail

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

Rockset

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. In many tech circles, SQL databases remain synonymous with old-school on-premises databases like Oracle or DB2.