Splitgraph has been acquired by EDB! Read the blog post.
 
Previous Post
PostgreSQL FDW aggregation pushdown part I: modifying Multicorn
Feb 8, 2022 · By Artjoms Iškovs
READING TIME: 3 min

Share datasets like Notion pages

Splitgraph now supports advanced data sharing settings. Make a repository private, invite a collaborator and control their level of access, all from a simple Web UI.

Create a dataset you wish to share

The easiest way to add data to Splitgraph is by uploading a CSV file. Go to the Upload page or use this widget:

See a previous blog post for more information.

You can also run a Splitgraph client locally. Check out the five minute demo that will show you how to create a dataset and publish it on Splitgraph.

In addition, we're working on a UI to add data to Splitgraph that will let you ingest and query data from over 100 SaaS sources and databases.

Open the Publication Status dialog

You can find the new Publication Status dialog to the right of the repository name.

Location of the publication status dialog

In here, you can:

  • set a repository as private. This means only you (and users you add) will be able to read data from it or even find it.
  • invite users to your repository
  • see who can access your repository and manage their access settings

Publication status dialog

Invite a collaborator by username or email

If your collaborator is already registered on Splitgraph, you can add them to the repository using their username:

You can also add a contributor by their e-mail address. If they are already registered on Splitgraph, they will be automatically added to your repository.

If they're not registered, they will receive an e-mail with an invitation to register on Splitgraph.

Sample invitation email

Manage levels of access

We currently support three roles:

  • Reader: Can view and query tables in a repository through the DDN or pull images with sgr
  • Writer: Can modify the repository's README and push data to it using sgr
  • Admin: Has all permissions and can control sharing

If a repository is public, everyone on Splitgraph has an implicit Reader role on it.

Next steps

  • Query the dataset over the DDN or the REST API
  • Check out the splitgraph.yml format for a sneak peek of how you will be able to add more data to Splitgraph

Want a private Splitgraph instance?

If you want Splitgraph for your internal company data, then join the private beta for our cloud SaaS product. We can deploy a white-labeled instance to your own infrastructure and setup a modern data stack for you without any hassle.

PostgreSQL FDW aggregation pushdown part II: Snowflake speedup