Nothing here yet.
Nothing here yet.
May 18, 2023 · 1 min read · Sometimes you want to share a single dataset with a third party. Here's how you can do that. First add them in the IAM with role Bigquery Job User: Then go to the bigquery dataset and hit sharing and share with just that user. You should test with...
Join discussionApr 13, 2023 · 3 min read · 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...
Join discussion
Feb 21, 2023 · 6 min read · We'll generate a series of sensor recordings from raw sensor readings that can come in at arbitrary times: Begin by creating a table of recordings: CREATE TABLE sensor_readings ( id int not null auto_increment, name varchar(255) not null, ...
Join discussion
Apr 16, 2022 · 2 min read · 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...
Join discussion
Apr 14, 2022 · 5 min read · 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...
Join discussion