Announcing the Sort API for Automating Postgres and Snowflake Workflows

GitHub Pull Request Workflows For Your Data

The Sort API opens new possibilities for teams working with Postgres and Snowflake, making it easier to automate, manage, and integrate complex database workflows:

• Use GitHub-like workflows for changing data in your database via Change Requests

• Create and manage data issues, resolve data issues with Change Requests

• Create and manage database connections

• Query your data through a REST API

• And more!

Sort API Docs

Key Features of the Sort API

1. Comprehensive Change Request Management - With Change Requests, the Sort API offers an integrated process for tracking, reviewing, and executing changes to data. Key functionalities include:

   • Create and Track Changes (think GitHub pull request workflows for your data): Users can create change requests by specifying details like title, description, reviewers, labels, and which data to add, edit or remove.

   • Review and Approve Changes: The API allows reviewers to track changes and provide approvals. This review layer ensures that all data alterations are vetted and comply with data governance protocols.

   • Execute and Monitor Changes: Once approved, change requests can be scheduled and executed through the API, with real-time status updates on completion or errors.

2. Change Request Logging and Permissions - The Sort API’s Change Request feature provides a detailed timeline of all change events, creating a transparent log for audit purposes. The API also includes permissions management to control access to creating, editing, and executing Change Requests, enhancing security in collaborative database environments.

3. Data Issue Management - Create data issues, even for specific rows and pieces of data in your database. Optionally resolving those data issues with Change Requests.

4. Efficient Integration and Connection Management - Users can easily manage API keys, configure connections to Sort databases, and access schema information to facilitate seamless integration with their existing infrastructure.

5. Powerful Query Capabilities - The Sort API offers extensive support for database querying, allowing users to define and run queries directly from the API. The query management feature is ideal for teams looking to integrate custom data retrievals into their automated workflows.

How to Get Started with the Sort API

1. Obtain Your Free API Key
   Begin by visiting the Sort docs to learn about obtaining an API key from your account settings.

2. Add Your Database Connection to Sort
   Add your Postgres or Snowflake database connection to Sort either through the Sort UI or API.

3. Explore the Sort API Docs
   Begin creating data issues, Change Requests, or querying your database

Build a Data Quality Widget or Manage Data Issues Via Slack

Stay tuned for follow up posts to walk through using the Sort API to build a data quality widget for your website and Slack integration for specifying data issues in your database!

---

Visit Sort’s documentation and API reference to learn more, and please send us feedback at info@sort.xyz if you need any help along the way!