Skip to content

Sigma Computing

Sigma Computing and Tallyfy Analytics

Sigma Computing can’t connect directly to AWS Athena - which is the query engine behind Tallyfy Analytics. If you’re set on using Sigma, you’ll need a workaround.

Sigma is a cloud-native BI platform that gives business users a spreadsheet-like interface on top of cloud data warehouses. No SQL required. If you’re comfortable with Excel, you’ll pick it up fast.

What Sigma connects to

Sigma requires persistent, always-on connections to data warehouses. It supports these platforms natively:

PlatformConnection type
SnowflakeNative connector
Google BigQueryNative connector
Amazon RedshiftNative connector
DatabricksNative connector
PostgreSQLNative connector
MySQLNative connector
Microsoft SQL ServerNative connector
AlloyDBNative connector
StarburstNative connector

AWS Athena isn’t on this list because it’s serverless - it doesn’t maintain persistent connections. Athena runs queries on demand against S3 storage, which is a fundamentally different pattern than what Sigma expects.

Workarounds for Tallyfy Analytics

Three paths forward:

Bridge through Redshift Spectrum - If you already have Amazon Redshift, use Redshift Spectrum to query the S3 data where Tallyfy Analytics stores everything. Then connect Sigma to Redshift normally.

Migrate to a supported warehouse - Copy your analytics data into Snowflake, BigQuery, or Redshift. Any of these work natively with Sigma.

Switch BI tools instead - If you’d rather keep Athena, use a tool that supports it directly:

  • Power BI (with the appropriate ODBC drivers)
  • Tableau (via JDBC connection)
  • AWS QuickSight (built specifically for Athena)

Practical recommendation

If you’re already using Tallyfy Analytics, Power BI or Tableau are the straightforward choices - they connect to Athena without extra infrastructure. Sigma is a strong platform, but the Athena gap means added complexity you probably don’t need.

Keep an eye on Sigma’s roadmap. They may add Athena support in the future, and submitting a feature request to Sigma directly helps signal demand.

Sigma > Connection limitations and alternatives

Sigma Computing cannot connect directly to Tallyfy Analytics due to an architectural mismatch between Sigma’s need for persistent data warehouse connections and AWS Athena’s serverless query model but teams can work around this by using a Snowflake or Redshift Spectrum bridge to read Tallyfy’s S3 data without duplication or by switching to natively compatible BI tools like Power BI or Tableau or AWS QuickSight that connect to

Sigma > Alternatives for spreadsheet-style analytics

Since Sigma Computing requires persistent database connections that are incompatible with Tallyfy Analytics’ serverless Athena architecture you can achieve similar spreadsheet-style data exploration using Power BI with Athena ODBC drivers or AWS QuickSight with native Athena integration or Tableau for advanced visualization or by bridging through Snowflake or Redshift to use Sigma itself.

Analytics > Looker

Looker integrates with Tallyfy Analytics through Amazon Athena to transform workflow data into interactive dashboards and embedded analytics that enable teams to explore process insights answer business questions and monitor performance in real-time without requiring technical expertise.

Integrations > Tallyfy Analytics

Tallyfy Analytics is an add-on service that copies workflow data to a dedicated Amazon Athena infrastructure where users can connect BI tools like Tableau and Power BI to build custom reports and perform deep analysis on process performance trends and task completion metrics.