Sigma is the only Cloud Analytics solution with a spreadsheet-like UI, enabling anyone to explore data at cloud scale and speed.
Go to siteThe Sigma API allows users to automate and integrate their business intelligence directly from Sigma Computing into other services and workflows. Sigma is a powerful tool for creating live, actionable dashboards and reports from cloud data warehouses. With Pipedream, users can harness this capability to trigger workflows based on Sigma events, manipulate and analyze Sigma data, and synchronize insights across other apps, enhancing data-driven decision-making processes.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
sigma: {
type: "app",
app: "sigma",
}
},
async run({steps, $}) {
return await axios($, {
url: `${this.sigma.$auth.server}/v2/whoami`,
headers: {
Authorization: `Bearer ${this.sigma.$auth.oauth_access_token}`,
},
})
},
})
Automatically Distribute Sigma Reports: Set up a workflow on Pipedream where Sigma reports are automatically fetched and emailed to stakeholders at regular intervals or in response to specific data changes. This can be integrated with email platforms like SendGrid to streamline communication.
Real-time Slack Notifications for Sigma Dashboard Updates: Create a Pipedream workflow that monitors changes in Sigma dashboards or reports and sends notifications through Slack. This helps teams stay updated on the latest insights without constantly checking Sigma.
Sync Sigma Data with Google Sheets for Further Analysis: Use Pipedream to develop a workflow where data from Sigma is automatically extracted and pushed into Google Sheets. This allows for additional data manipulation or sharing within teams who prefer accessing data through Google Sheets.
Sigma uses OAuth authentication. When you connect your Sigma account, Pipedream will open a popup window where you can sign into Sigma and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Sigma API.
Pipedream requests the following authorization scopes when you connect your account:
POST
{{custom_fields.server}}/v2/auth/token
content-type: application/x-www-form-urlencoded
client_id={{custom_fields.client_id}}
&
client_secret={{custom_fields.client_secret}}
&
grant_type=client_credentials
POST
{{custom_fields.server}}/v2/auth/token
content-type: application/x-www-form-urlencoded
accept: application/json
client_id={{custom_fields.client_id}}
&
client_secret={{custom_fields.client_secret}}
&
grant_type=refresh_token
&
refresh_token={{oauth.refresh_token}}