Skip to main content

How to request data from a database in Funnel

If you’d like to connect data from a database to Funnel, you can do so by submitting a Custom Connector Request.

Updated this week

If your use case requires this data in Funnel, you can request it as a Custom Connector.

Custom Connectors and the Custom Connector Request feature are available in the following plans: Business and Enterprise. See our Pricing page for more details.


Step 1: Submit a Custom Connector Request

When submitting your request to Funnel, please include the following information:

  • Database Credentials:
    Do not send credentials via email. To share securely:

    1. Go to the Custom Connector Request Status page.

    2. Click “Add Credentials.”

    3. Enter the relevant connection details when prompted.

  • Database Type: Specify your database system (e.g., MySQL, PostgreSQL, Microsoft SQL Server, etc.).

  • Hostname: Provide the database hostname.

  • Port: Include the port number used for your database connection.

  • Data source origin:
    For example, is this Shopify Orders data or Internal Enrollment data?

  • Full explicit SQL query:
    Please include the complete SQL query for the data you want to import.
    Example:

    SELECT campaign_id, campaign_name  FROM `dataset.table`

    Avoid using SELECT * — specifying only the required fields ensures better performance and clarity.


Step 2: Share Access Details Securely

Once access has been granted, please share the following information via your Custom Connector Request:

  • Confirmation that Funnel has access

  • The SQL query you’d like to run

  • Database credentials

You can securely provide these details by visiting your Custom Connector Request Status page and selecting Add Credentials for your request.


Step 3: Confirmation and Testing

Once we’ve received your details and verified access, our Integration Engineering team will:

  1. Test the connection to your database

  2. Validate your query and data structure

  3. Set up your Custom Connector

Each SQL query you provide will be treated as its own data source within Funnel.
If you require multiple datasets, please submit a separate query for each one.


How to Request This Custom Connector

To request data from a database:

  1. Submit a Custom Connector Request (see instructions here), or

  2. Enable Show custom connectors and select the appropriate tile for your database type.

Selecting the tile will automatically send your request.


Did this answer your question?