top of page
Chen Hirsh
Oct 11 min read
SQL Windows Functions might be non-deterministic
How using SQL Windows functions with non unique order column can cause indeterminate results
4
Chen Hirsh
Sep 241 min read
Databricks workflows for-each - not quite there yet
Databricks recently added a for-each task to their workflow capability. How does it work and what are its limitations?
3
Chen Hirsh
Sep 151 min read
Instant data replication with Databricks table cloning
Cloning tables in Databricks is a fast way to create replicated data for test proposes, or archiving.
1
Chen Hirsh
Sep 81 min read
Working with Excel files in Databricks
Working in Databricks, you can read and write Excel files, but you need to pay attention to some pitfalls.
1
Chen Hirsh
Sep 11 min read
A simple code source control for SQL Server
A simple source control for SQL server code objects like views and stored procedures.
3
Alon Ohayon
Aug 283 min read
How to display missing months in Power BI charts without showing future dates
When you’re using Power BI, you probably create line charts that show data by month pretty often. It usually works great, but what...
0
Chen Hirsh
Aug 251 min read
The mystery of the vanishing variable
A Python variable has vanished! Can you help the confused Data Engineer find out why?
1
Chen Hirsh
Aug 181 min read
Ingest Google Analytics data into Databricks
Use Databricks notebook to read and ingest data from Google Analytics.
6
Chen Hirsh
Aug 111 min read
How to plan a successful Data Architecture
How to design a data platform for your project? What question should you ask?
1
Guy Glantser
Aug 73 min read
Navigating Database Choices for Startups: Relational or NoSQL?
When founding a startup, one of the critical technical decisions you'll face is selecting the right database. This choice can...
0
bottom of page