Connect Supabase data with Analytics Plus

Connect Supabase to Analytics Plus to analyze operational data such as incidents, service events, application telemetry, and infrastructure records. You can import selected tables or query results, schedule regular synchronization, or use Live Connect to analyze current source data without storing it in Analytics Plus.

On this page

Import Supabase data

Configure the connection

  1. Open the required workspace, click Import Your Data, and select Databases & Datalakes.
  2. Select Supabase.

Supabase selected from the Databases and Datalakes import sources

  1. Enter the Endpoint, Port, Username, Password, and Database Name for the Supabase database.
  2. Select Use SSL if the connection requires SSL. Configure SSH tunneling when it is required for the database connection.
  3. Click Next.

Supabase connection form with Analytics Plus product naming and IT operations sample values

Choose data to import

Choose one of the following import methods:

  • Single Table: Import one table from Supabase.
  • Multiple Tables: Import several tables in the same setup.
  • Custom Query: Import the result of a SQL SELECT query.

Single table

  1. Select Single Table, choose the table to import, and click Next.

Single Table selected with the Incidents table

  1. In Import Settings and Preview, enter the workspace name, table name, and an optional description.
  2. Review the data preview. Clear the checkbox beside a column that you do not want to import, and change a column name or data type when needed.
  3. Under On Import Errors, choose whether Analytics Plus should set an empty value, skip affected rows, or stop the import.
  4. Click Create.

Analytics Plus import preview for an IT incidents table

Multiple tables

  1. Select Multiple Tables.
  2. Select the required tables, confirm that they appear under Selected Tables, and click Next.

Multiple Supabase tables selected for import into Analytics Plus

  1. Enter the workspace name and an optional description.
  2. Review and, if required, edit the destination table names.
  3. Choose how import errors should be handled, and click Create.

Analytics Plus import settings for multiple IT operations tables

Custom query

  1. Select Custom Query.
  2. Enter a SQL SELECT query and click Next.

Custom SQL query that selects records from an Incidents table

  1. Complete the workspace, table, preview, column, and error-handling settings as you would for a single-table import.
  2. Click Create.

Schedule data import

During the initial setup, choose whether every scheduled synchronization should fetch all records or only new and modified records.

All records

When you fetch all records, choose one of these import strategies:

  • Add records at the end: Append every fetched row to the destination table.
  • Delete existing records and add: Replace the destination table's existing data with the latest fetched data.
  • Add records and replace if already exists: Match records using selected columns, replace matching records, and add new records.

You can also choose to include new columns that are added to the Supabase table after the import is configured.

Schedule settings configured to fetch all records for an Incidents table

Import synchronization settings that replace matching incident records

New and modified records

Choose incremental fetch when each synchronization should import only records added or modified after the previous successful fetch. Configure the column Analytics Plus should use to identify new or updated records. For setup details and supported data types, see Incremental Fetch.

Data synchronization frequency

Choose the synchronization interval that suits the rate at which the Supabase data changes. Available scheduling choices include hourly intervals, daily, weekly, monthly, and Not Scheduled. You can also configure notifications for consecutive import failures and select the administrators or users who should be notified.

Schedule settings with import failure notifications and recipients

Daily synchronization schedule with failure notification thresholds

For information about configuring more than one synchronization schedule, see Multiple Sync Schedules.

Import rollback

Users with the required administrative or custom-role permission can roll back the most recent import within four hours. A rollback removes the rows and columns added by that import while preserving formulas, lookup relationships, and other table configuration. Columns deleted by an import are not restored.

  1. Open the imported table.
  2. Click Import Data and select Last Import Details.

Last Import Details selected from the Import Data menu of an Incidents table

  1. Review the import summary and click Rollback.

Import Details panel with the Rollback option for an Incidents table

  1. Confirm the action. Analytics Plus records the rollback status in the import details.

Successful import rollback details for an Incidents table

For more information, see Import Rollback.

Live Connect

Use Live Connect when reports and dashboards should query the current Supabase data directly. In this mode, the source data is not imported and stored in Analytics Plus. Report loading time depends on the Supabase database's response time and performance.

  1. Open Import Your Data, select Databases & Datalakes, and choose Supabase.
  2. Select the Live Connect option.
  3. Enter the required connection details and continue.
  4. Select the tables required for reporting and complete the setup.

Manage data source settings

Administrators can open Data Sources in the workspace and select the Supabase source to review its connection settings, synchronization status, and available actions.

Supabase data source settings showing synchronized IT operations tables

Edit connection

Click Edit Connection to update the Supabase endpoint, port, credentials, database name, or connection security settings. Save the changes after verifying the updated connection.

Sync settings

Click Sync Settings to change what data is fetched, the import strategy, the synchronization frequency, or failure-notification settings.

Audit history

Click Audit History to review user and system actions performed on the data source, including when an action occurred and the administrator who performed it.

TypeActionDescription
User ActionData Source CreationRecords the administrator who configured the Supabase connection.
Table CreationRecords the new tables added to the workspace.
Remove Table from Data SourceRecords tables removed from the data source.
Edit SetupRecords connection changes such as reauthentication or enabling or disabling SSH.
Import SettingsRecords changes to the data-fetch settings.
Sync SettingsRecords changes to the data-synchronization settings.
Table-level Sync NowRecords the data fetched when a table-level synchronization is started manually.
System ActivitiesSchedule ImportRecords data fetched at scheduled intervals.

Sync history

Click Sync History to review data-synchronization activity. Successful synchronizations are displayed in green. Failed synchronizations are displayed in red along with the reason for the failure and the action required to resolve it.

Manage table synchronization settings

Use the table list in the data source settings to manage individual synchronized tables:

  • Sync Now: Import recent source changes immediately using the fetch method configured for the table. For tables configured to fetch only new records, you can also choose a full data fetch.
  • Edit: Choose whether each synchronization should fetch all source records or only new and modified records.
  • Delete: Stop synchronizing the table. The table, its lookup relationships, and reports created from it remain in the workspace.
  • Info: Review the import summary, including successfully imported records and records that encountered errors.

Import details for a synchronized Incidents table

Resolve synchronization failures

A synchronization can fail when connection credentials are invalid or expired, the source is unavailable, or source data no longer matches the configured destination data types. Analytics Plus displays an in-app notification with the reason for the failure and the corrective action. If email notifications are enabled, the configured administrators and users are also notified after the failure threshold is reached.

  1. Open Data Sources and select the Supabase source.
  2. Review Sync History and the affected table's import details.
  3. Correct the connection, source data, column mapping, or synchronization settings indicated by the failure.
  4. Use Sync Now to verify that synchronization succeeds.

Blend Supabase data with other sources

You can import data from files, feeds, cloud storage, other databases, and supported applications into the same workspace as the Supabase data. When data is imported into an existing workspace, Analytics Plus identifies columns with compatible data types and suggests possible lookup relationships. You can also use query tables to combine data from multiple tables in the workspace.

To add Supabase data to an existing workspace, click the Create icon in the side navigation panel and select New Table/Import Data. Select Supabase and complete the connection and import steps described on this page.

Import data into an existing table

  1. Open the destination table in Analytics Plus.
  2. Click Import Data and select Import Data into this Table.
  3. Select the configured database source, choose Single Table or Custom Query, and then select the source table or enter the query.

Importing an Incidents table from a configured database source into an existing Analytics Plus table

  1. Choose how the incoming records should be added to the existing table, map the source and destination columns, and specify how Analytics Plus should handle import errors.
  2. Review the import summary and click Import.

Analytics Plus adds the selected Supabase data to the existing table using the configured import behavior.