The Neon Input Node is our first managed database access node, and an intuitive approach to giving people access to a serverless PostgreSQL which users are able to manage in Neon Lake. Data here is safe, and protected by 0Auth (Two way authentication). As you use ET1.1 csv files, json, and manual tables, this data […]| Dev3lop
CSV, JSON, and Public CSV endpoints or manual tables. These help you kick start your data pipeline. Once your data comes into the data input, it begins to flow downstream using a custom DAG streaming engine. Input Node Overview The Input nodes are essential for moving the needle in ET1, without data, we are using […]| Dev3lop
The CSV Input Node, what a classic, flat files living on your computer can be consumed and the data can be extracted here in ET1. CSV is a common file type for data gurus. Comma-Separated Values, a plain text file format for storing tabular data with values separated by commas. If you have a CSV […]| Dev3lop
On your magic quest to join data? We call it the Joiner node. A simple joining solution that helps people join data at a row level. In ET1, Joiner is focused on “keeping it simple” and will aim to automatically infers your joins. ET1 assumes. Inferring a join means it assumes you prepared the data […]| Dev3lop
If a web-cam is available ET1’s code will try to automatically sync and if you can wave and point, this radial menu is a fun way to augment your ETL development. Using computer vision (explained in depth below) we map a skeleton over your hands and able to create a radial menu we are calling […]| Dev3lop
The Unique Filter Node or Unique Tool finds unique values per row in your data pipelines, or allows people to quickly review duplicates only. Plus, you can select what column(s) to find unique values within. This enables people to easily understand what is inside of a column. Duplicate rows happen, The Unique Filter node manages […]| Dev3lop
Familiar with graphs? How about DAGs? This is not a paradigm shift, but think of DAG as a cool way for tiny team in Austin/Dallas Texas to build an Extract Transform and Load software! Like a guitar pedal, there’s an input and output. Sometimes it’s just an output. Then you have your input only tools. […]| Dev3lop
Aggregation, what a classic. Aggregating your data is a landmark trait for any data steward, data wrangler, or data analyst. In ET1, you can easily aggregate your data. The Power of Grouping (Group By) with the Aggregate Node Aggregations turn a sea of numbers into meaningful insights. Group by in ET1 is nested in the […]| Dev3lop
The filtering nodes help you reduce the number of rows, drill into the exact information needed, and create a data set that will add value VS confuse your audience. When filtering, remember you’re reducing the amount of data coming through the node, or you can swap to include. Include, exclude, and ultimately work on your […]| Dev3lop
