skills.rest
rilldata
rilldataOFFICIAL
Explore all skills by this author →
Website𝕏@rilldataGitHub

rill-connector

Configure Rill connectors for diverse data sources with JSON schema.

47|9|Updated May 17, 2023
Search Tags:#database#configuration#cloud#connector#data source#rill
One-click install
npx skills add https://github.com/rilldata/rill-examples --skill rill-connector
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: rill-connector
Source: https://github.com/rilldata/rill-examples/tree/main/medicaid-provider-spending/.claude/skills/rill-connector
Command: npx skills add https://github.com/rilldata/rill-examples --skill rill-connector

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides comprehensive guidance on defining and managing data connectors within the Rill application, enabling seamless integration with various external data sources.

Core Features & Use Cases

  • Connector Configuration: Learn how to configure connectors for different database types (DuckDB, ClickHouse, BigQuery, etc.) and object stores (S3, GCS).
  • Secrets Management: Understand best practices for securely managing credentials using .env files.
  • Managed Connectors: Discover how Rill can provision and manage OLAP databases automatically.
  • Use Case: Configure a ClickHouse connector to securely access your production data warehouse, allowing Rill to build dashboards and metrics views directly from it.

Quick Start

Configure a DuckDB connector with managed: true for local development.

Frequently Asked Questions about rill-connector

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I configure a data source connector in Rill?▼

To configure a data source connector in Rill, define the connector syntax using the provided JSON schema, specifying driver-specific properties for services like DuckDB, ClickHouse, S3, or BigQuery.

What is a managed Rill connector for OLAP databases?▼

A managed Rill connector automatically provisions and manages OLAP databases, allowing you to set up local development environments by enabling the managed property in your connector configuration.

How do I manage secrets and credentials for database connectors?▼

Manage database connector secrets and credentials securely using .env files, ensuring that sensitive properties for services like Postgres or Snowflake are handled safely across development and production environments.

Can I use Rill to connect to object stores like S3 and GCS?▼

Yes, you can connect Rill to object stores like S3 and GCS by configuring the appropriate connector driver and specifying the necessary access modes and bucket properties in the JSON syntax.

Does Rill support integration with cloud data warehouses like BigQuery and Snowflake?▼

Rill supports integration with cloud data warehouses including BigQuery, Snowflake, Redshift, and Athena, providing driver-specific properties to establish secure connections for building dashboards.

What are the limitations when setting up environment-specific configurations?▼

Environment-specific configurations require distinct setups for development and production, relying on proper secrets management and access modes to prevent connection failures when switching database contexts.

Related Skills

Explore More Software Engineering Skills→
towertower
19

setup-secrets

Manage credentials as runtime environment variables via Tower MCP.

Official
Intermediate
sourcegraphsourcegraph
16

bigquery

Run BigQuery SQL queries and export results using the bq CLI.

Official
Advanced
rilldatarilldata
47

rill-canvas

Create custom canvas dashboards in Rill using declarative YAML.

Official
Intermediate
xukrutdonutxukrutdonut

database

Execute SQL queries and manage schemas across PostgreSQL, MySQL, SQLite, MongoDB, and Redis.

Community
Intermediate