What's new in Sigma
Admin
Improved management of developer credentials
On the Developer access page in the Administration portal, the owner of each set of developer credentials is now identified by email instead of by user name. As a result, admins can now determine which API token is assigned to whom when there are multiple users with the same user name.
API
Allowlist IP addresses for API access (GA)
Restrict access to the Sigma API for your organization by adding IP addresses and IP address ranges using CIDR notation to an allowlist. With an allowlist configured, only users making API requests from allowed IP addresses can make successful requests.
For more details, see Restrict API access by IP address.
New API endpoint to update the schedule for an export
The following endpoint to update the workbook schedule for an export is now available:
- Update a workbook schedule (
PATCH /v2/workbooks/{workbookId}/schedules/{scheduleId})
New 2.1 version for some API endpoints
The following endpoints are now available in a v2.1 version. The new version uses pagination for the API response by default, allowing you to retrieve large responses in manageable segments.
- List members (
GET /v2.1/members) - List teams (
GET /v2.1/teams) - List workspaces (
GET /v2.1/workspaces) - List materialization schedules for a workbook (
GET /v2.1/workbooks/{workbookId}/materialization-schedules) - List scheduled exports for a workbook (
GET /v2.1/workbooks/{workbookId}/schedules)
The equivalent endpoints in v2 continue to work, but might not use pagination by default for all customers.
New option for Export data from a workbook endpoint
When exporting an entire workbook or workbook page using the Export data from a workbook (POST /v2/workbooks/{workbookId}/export), the format parameter now supports the xlsx option to support the Excel file format.
Bug fixes
- Users are no longer signed out of Sigma if they attempt to run a query with OAuth credentials that do not exist.
- For connections that use OAuth, users can now see and use stored procedures that they have access to.