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 a fundamental architecture mismatch between Sigma’s need for persistent data warehouse connections and AWS Athena’s serverless query model but you can bridge the gap using Snowflake or Redshift Spectrum to read Tallyfy’s S3 data without duplication or switch to natively compatible BI tools like Power BI or Tableau or AWS QuickSight that support Athena directly.

Sigma > Alternatives for spreadsheet-style analytics

Since Sigma Computing requires persistent database connections that don’t match Athena’s serverless model you can explore Tallyfy Analytics data through alternatives like Power BI for spreadsheet-style grids and Tableau for advanced visualizations and AWS QuickSight for native Athena integration or bridge to Sigma itself via Snowflake or Redshift.

Analytics > Looker

Looker and Looker Studio both connect to Tallyfy Analytics through Amazon Athena so teams can build interactive dashboards and drill into workflow performance data without writing SQL using either the enterprise platform or the free visualization tool.

Integrations > Tallyfy Analytics

Tallyfy Analytics is an add-on that replicates your workflow data into a private Amazon Athena environment where you can run SQL queries and connect BI tools like Tableau or Power BI to build custom dashboards and track process trends over time.