Set up connection

Connect to your data sources

Navigate to the Connect application using the side navigation bar.
Select your data source type.

To connect to Supabase, use the following credentials and configuration steps:

Create the execute_raw_sql Function: To enable secure execution of SQL queries, run the following SQL in your Supabase SQL editor:

CREATE OR REPLACE FUNCTION public.execute_raw_sql(query text)
RETURNS jsonb
LANGUAGE plpgsql
SECURITY INVOKER
AS $$
DECLARE
    result jsonb;
BEGIN
    -- Execute the SQL query and store the result in a JSONB format
    EXECUTE format('SELECT json_agg(t) FROM (%s) AS t', query) INTO result;
    
    RETURN result;
EXCEPTION
    WHEN others THEN
        -- Handle errors gracefully by returning the error message in JSON
        RETURN jsonb_build_object('error', SQLERRM);
END;
$$;

Set Up Credentials in Upsolve Hub: Use the following details to connect to your Supabase instance:
- URL: The unique URL of your Supabase instance.
- Anon Key: The public API key for accessing Supabase.
- Service Key: The secret API key for accessing Supabase.
You can find these details in your Supabase API settings.

For enterprise features, look for the 🔒 symbol. These features are available in our Enterprise plan. Please contact us for more information.

Input the corresponding credentials for the data source.

Click Save to see if connection is set up successfully.

You are now good to go to start building charts and creating dashboards. If you do not see the data source type you want to connect to in the Connect application, please raise a support ticket.

Get Started

Data Connection

Charts

Dashboards

Filtering

Data Permissioning

Dashboard Deployment

Sharing and Export

Connect to your data sources

Get Started

Data Connection

Charts

Dashboards

Filtering

Data Permissioning

Dashboard Deployment

Sharing and Export

​Connect to your data sources

Connect to your data sources