Row level access policies with custom signed JWTs

Data API

Many teams have multiple customers' data in the same table. In a customer-facing feature, you only want to display that particular customer's data.  To ensure you can safely limit customer access to the right data, you can now rely on row-level access controls encoded in JWTs.  Patch can issue JWTs or respect ones that you supply with the filters encoded.

$ pat access signing-template create <name> <JWK file> --source snowflake_prod --dataset exec_dashboard --filters user_events:account_id:384752
Patch logo
Cover

Patch Changelog

Jul

12

Python Data Packages

Announcement

Data Packages are code libraries with a live connection to an underlying data source. They provide a powerful interface for querying, access control, versioning, performance optimization and more; over all your data, no matter where it lives. This could be any database or file system.

The Data Package can be installed using a package manager like pip . Then, it's imported like a library dependency into your code, whether that’s a backend service performing machine learning or enrichment tasks, a customer-facing application, or even an external consumer buying access from you directly to build using the package.

A dpm-agent intelligently routes queries submitted by consumers of a Data Package to the appropriate backend source, enforces access policies and applies performance optimizations. 

Today, we're excited to announce support for generated Python packages!

Sign up for early access at www.dpm.sh!

Jul

05

TypeScript / Node.js Data Packages

Announcement

Data Packages are code libraries with a live connection to an underlying data source. They provide a powerful interface for querying, access control, versioning, performance optimization and more; over all your data, no matter where it lives. This could be any database or file system.

The Data Package is imported like a library dependency into your code, whether that’s a backend service performing machine learning or enrichment tasks, a customer-facing application, or even an external consumer buying access from you directly to build using the package.

A dpm-agent intelligently routes queries submitted by consumers of a Data Package to the appropriate backend source, enforces access policies and applies performance optimizations. 

Today, we're excited to announce support for generated Node.js & TypeScript packages!