finos / finos/tracdap

SQL scripts as models

Open
#239 0 comments 0 reactions 0 assignees View on GitHub
enhancement
Dominant language
Java
Stars
55
Forks
18
Avg merge
6h 29m
Merged PRs (30d)
16

Description

SQL model steps take the form of update statements:

UPDATE input_1 SET field_1 = field_1 * 2 WHERE field_2 = "some_filter";

This injects a model into the chain whose output is the input dataset with the update operations applied. The input dataset is not modified - we use the update form because it is clearer than a select when there are a lot of columns, most of which are unchanged.

Implemented by converting into spark sql or operations on a pandas data frame, mostly used for overlays.

Contributor guide

Open the contributing guide

Research direction

No files, tests, or entry points are named. Start by locating the model-step handling and the Spark SQL and pandas execution paths, then clarify how UPDATE syntax is parsed and how overlays are represented. Done means an agreed implementation with coverage for the stated non-mutating input behavior and both execution backends.

Written by the indexing model from the issue text.

Assessment

Tech stack
pandas, spark, sql
Domain
data-engineering
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.