RAW Blog
Join Our Newsletter
To receive the latest news and blogs no more than once per month, and no spam.
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
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.
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.
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.
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.
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.
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.
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
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.
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.
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.
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.
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.
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.
RSS News Feed Filtering with RAW
Filter and alert on news stories on topics of interest, using RAW Labs on RSS feeds
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.
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
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.
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.
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.
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
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.
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
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.
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.
Tutorial 3. Managing complex data with RAW
Third Tutorial to show how sot read, manage and produce complex data in RAW
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
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
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
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
Hello world, meet RAW
here we show how to use RAW Data Product Platform to create a simple Hello World output
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.
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?
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
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.
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.
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.