Skip to content

Data Connectors#

Data connectors fetch external data for your dashboards. Use them with widgets to display live data from databases, APIs, and files.

Connector Configuration

Before using data connectors in your dashboard, you need to create and configure them in the Management Portal. Each connector requires specific configuration details like connection strings, API keys, and authentication settings.

To learn more about creating and configuring connectors, visit: Connectors Overview

HTTP Connector#

The HTTP connector enables you to fetch data from REST APIs and web services.

Configuration: HTTP Connector Setup Guide

from engineai.sdk.dashboard.data.connectors import HttpGet
from engineai.sdk.dashboard.widgets import table

# Basic HTTP request
data = HttpGet(
    slug="sales-api",
    path="/sales",
    headers={"X-DASHBOARD-SLUG": "sales-dashboard"}, # Optional
)

# Use in a widget
table = table.Table(
    data=data,
    columns=["customer_id", "revenue"]
)

API Reference: HttpGet

DuckDB Connector#

DuckDB connector provides high-performance analytics by supporting queries across different storage types including databases and cloud storage services.

Configuration: DuckDB Connector Setup Guide

from engineai.sdk.dashboard.data.connectors import DuckDB
from engineai.sdk.dashboard.widgets import table

# Query S3 data directly
data = DuckDB(
    slug="s3-analytics",
    query="SELECT customer_id, revenue FROM 's3://my-bucket/sales/data.parquet'"
)

# Use in a widget
table = table.Table(
    data=data,
    columns=["customer_id", "revenue"]
)

API Reference: DuckDB

Snowflake Connector#

Snowflake connector provides secure access to your Snowflake data warehouse, enabling real-time dashboard updates from your enterprise data.

Configuration: Snowflake Connector Setup Guide

from engineai.sdk.dashboard.data.connectors import Snowflake
from engineai.sdk.dashboard.widgets import table

# Define Snowflake data source
data = Snowflake(
    slug="sales-db",
    query="SELECT customer_id, revenue FROM sales WHERE region = 'US'"
)

# Use in a widget
table = table.Table(
    data=data,
    columns=["customer_id", "revenue"]
)

API Reference: Snowflake