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:
Data source origin:
For example, is this Shopify Orders data or Internal Enrollment data?Project name:
The Google Cloud project where your database or dataset is hosted.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: Grant Funnel Access to Your Database
To allow Funnel to connect and retrieve data from your database, please grant access to our service account:
Service Account:
funnel-customs-account@funnel-customs.iam.gserviceaccount.com
Required Role:
BigQuery Job User (includes the bigquery.jobs.create permission)
If your system requires IP whitelisting, please reach out via support.
This will allow Funnel to securely connect to and query your database.
Step 3: Share Access Details Securely
Once access has been granted, please share the following information via your Custom Connector Request:
Confirmation that the Funnel service account has access
The SQL query you’d like to run
Any additional connection or authentication details (if applicable)
You can securely provide these details by visiting your Custom Connector Request Status page and selecting Add Credentials for your request.
Step 4: Confirmation and Testing
Once we’ve received your details and verified access, our Integration Engineering team will:
Test the connection to your database
Validate your query and data structure
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 BigQuery database:
Submit a Custom Connector Request (see instructions here), or
Enable Show custom connectors and select the appropriate tile for your database type.
Selecting the tile will automatically send your request.