Ideas from the NOCD Tech Team
Prerequisites Existing cluster Some familiarity with AWS ECS i.e. setting up cluster, services, task definitions, launch templates, auto scaling groups, and capacity providers Steps Setup Task Definition as normal but specify GPU Resource { "...
You need a CSV or Parquet file to load into Rill (https://docs.rilldata.com/using-rill/import-data). Here are steps and caveats you can follow to get a dataset in Bigquery into that format and processed with Rill. Much of the guidance here is from th...
Imagine that you have a transportation array. Our array will have car and plane objects in it. Our task will be to add a type to our array and print car emoji or a plane emoji in our UI. Let's create an array and add types for it. interface Car { h...
The CSS box model is simple, right?
A versatile approach to binning data in MySQL
Sometimes a table just needs to capture JSON input and store it. An example is the greenhouse api (https://developers.greenhouse.io/webhooks.html). In order to track stage changes you need to listen to webhook events which arrive as json blobs. Rathe...
Lineage is a common area of study in the data modeling space. You often see graphs like this: This is a way of organizing tables into common groups for reusability with ad hoc reporting queries. These tables often start at source tables (your raw in...
TL;DR BigQuery features Arrays that are a powerful addition to standard SQL. In MySQL, JSON objects offer similar functionalities, but generating sequences requires some workarounds. MySQL's implementation of recursions offers even greater flexibilit...
A theoretical exercise to realize the purpose of the binlog