RAW Blog

Join Our Newsletter

To receive the latest news and blogs no more than once per month, and no spam.

October 18, 2022

Mobile-Friendly Websites: WordPress, Google Search Console API and RAW

Use RAW to check the mobile-friendliness of your web pages for SEO, programmatically – see our example using Wordpress and Google Search Console API

October 7, 2022

APIs – Good Fit for Data Products?

From Data Mesh, to Data Products and into APIs. Read why APIs can fit into new world of democratised and decentralised data.

October 6, 2022

Why our Customers chose API delivery for Data Products

We dig into 4 key characterstics of Data Products that our customers cite, and why APIs fit their needs well.

October 3, 2022

A Better Snowflake Cache: Smart and Simple with Savings

Snowflake caching works only some of the time. Often you need something that can work on top of it, alongside it, which is smart, fast and simple, as well as potentially saving money.

September 30, 2022

Integrating Snowflake with API-based Data: an Address Cleansing Example

Read how we combine Snowflake data with API from Melissa Address Cleansing – with less code, less effort and less cost – and create new data products too.

September 15, 2022

Querying data in JSON files across multiple S3 buckets and AWS accounts

Read how RAW helps a customer query, analyse and share S3 data in JSON files across multiple AWS accounts and S3 buckets.

September 8, 2022

Data Sharing: User Management and Invitations

We built our data delivery platform to have a simple and secure permissioning system, so that you can very easily control who has access to your API endpoints.

August 24, 2022

Introducing our Google Cloud API Connector

Our new Google Connector allows many services supported by Google’s APIs to be used securely in RAW. Check out an example using Google Search Console, used for SEO and website performance

August 16, 2022

New Features in the RAW Visual Studio Code Extension

New features in our RAW Visual Studio Code Extension to enable our developer community to build great APIs to expose and share data.

August 10, 2022

Sharing Data through APIs to Excel

Data access via an Excel spreadsheet to multiple sources. Connect to live data APIs with no technical expertise required.

August 2, 2022

Powerful new SEO & SEM Data Products with RAW

Create powerful SEO/SEM data products with RAW. This example compares historical search volumes for two keywords / brands over a time period for trend analysis.

June 8, 2022

How we use RAW internally: a Business Activity API and Dashboard

At RAW we eat our own dog food, as an emerging software vendor we want business metrics on how we are doing. We use RAW to create a Business Activity API, and then retrieve the data in Excel with a simple dashboard.

May 24, 2022

12 Benefits of Data Sharing via APIs

Data Sharing via APIs is a modern approach to unlocking valuable resources inside your organisation. Businesses sharing data are more likely to outperform those who do not. Read more about why using APIs is a better approach.

May 12, 2022

Defining and Running Tests for API endpoints

We show how easy it is to create an API test suite using just YAML for your RAW APIs inside VS Code using our RAW Extension: Define tests, execute them and fix your code.

April 28, 2022

RSS News Feed Filtering with RAW

Filter and alert on news stories on topics of interest, using RAW Labs on RSS feeds

March 23, 2022

816,000 interesting FREE datasets with RAW Labs

Free Datasets are a great resource – see an example showing how to use RAW to query, transform and join with other data, then expose API endpoints for further data sharing.

March 18, 2022

DataOps: Navigate the perfect storm between data agility and data control

How DataOps is your way out of the perfect data storm – balancing data agility with the need for data control

February 16, 2022

Analysing the News with RAW

Use RAW with Web APIs to produce powerful analysis results on web pages. This example shows analysing web pages in RSS feeds, using metadata extraction and Google’s language entity extraction.

February 8, 2022

NYC Taxi Cab Analytics and APIs, Part 3

Third and last in the Blog series, showing how to join file-based NY Cab and MTA data to weather data API to run some statistical correlation functions.

January 26, 2022

NYC Taxi Cab Analytics and APIs, Part 2

Second in Blog Series, we now parameterise our function to dynamically query different files, join to MTA train and bus data for total rides per day, and run over several months.

January 25, 2022

NYC Taxi Cab Analytics and APIs

First in Blog Series showing New York Taxi Cab Data, how we query, clean and join this data to produce simple APIs

January 24, 2022

Product Traceability: a Manufacturing Use Case

A major European manufacturing corporation challenged us to help them with providing a product traceability API on top of their machine data. 

January 21, 2022

API Integration: Where is the ISS ?

Georges shows how to integrate two APIs and produce a new API that can easily be published on our platform, using an example about the ISS spaceship and Reverse Geocoding

January 19, 2022

Resource-Intensive Data Products: “Calculation-as-a-Service”

Some Data Products are simple, but there’s plenty that are more complex, involving calculations, models and other longer-running and resource intensive workloads.

January 18, 2022

Querying all data, anywhere

Founder and CEO Miguel Branco explains the rationale behind the RAW platform, the problems it solves and how and why a better SQL is the way forward.

January 17, 2022

Tutorial 3. Managing complex data with RAW

Third Tutorial to show how sot read, manage and produce complex data in RAW

January 14, 2022

Tutorial 2. Producing complex data with RAW

Second RAW Tutorial to show how to produce complex data, extensions to Group By, Top level collections and records

January 12, 2022

Tutorial 1. First flight with RAW

First Tutorial with RAW where we take reader through a first query, first API and passing parameters to that API

January 12, 2022

Reference Data Standard Library

Standard Libraries are a commonly known construct in programming. Same for data; we show how to use RAW to surface and standardise data into APIs

January 12, 2022

Hello <name> !

Second basic blog post to show how easy it is to make incremental changes, e.g. pass parameters into a function that creates a new API endpoint

January 11, 2022

Hello world, meet RAW

here we show how to use RAW Data Product Platform to create a simple Hello World output

December 6, 2021

Introducing the RAW Data Product Platform

Data Products as a Service: A collaborative DataOps platform as a service for data APIs. Create and Share data faster.

November 15, 2021

Data as a Product

Do we really manage our data as a product? What does that mean for customers? Is a data product really that different from a traditional product? And what can we learn from other more established industries about their products, and apply them back to our fledgling data product space?

November 12, 2021

Retrieving JSON data from a REST API in Excel with Power Query

Use Excel with Power Query to retrieve data from REST APIs created through RAW in JSON, CSV, or even XML

September 16, 2021

Data Disaggregation: a perspective

How to deal with Data Disaggregation? Don’t fight the laws of physics, you won’t win. Architect for it, and then choose solutions that allow that architecture to be realised.

August 11, 2021

Interrogating machine generated data for diagnostics

Cesar Matos shows us how RAW can give fast answers to a complex data problem where engineers need to investigate issues plaguing operational systems.

August 3, 2021

Calculation-as-a-Service: Value at Risk (VaR) within Financial Services

A worked example of using RAW Labs Data Product platform to perform large scale data intensive calculations, using “Value at Risk” from the Financial Services domain.