Docs/Getting Started/Connecting Your Warehouse

Connecting Your Warehouse

Celiq guides you through warehouse setup with a conversational wizard — no technical knowledge required.

LuminaryUpdated Jun 2026 · 4 min read

✦

In this section

Part of Celiq's semantic layer platform. Connect your warehouse, model your data once, query it everywhere.

💡

Tip

What it is: A step-by-step guided setup that connects your data warehouse without requiring DevOps knowledge.
Why use it: Most teams connect in under 5 minutes. The wizard generates the exact script you need to run — one copy-paste.
Where to find it: /connect or click "Connect warehouse" from the home page
Who can use it: Luminary role only.

Connecting Your Warehouse

Celiq guides you through warehouse setup with a conversational wizard — no technical knowledge required.

How it works

Go to /connect (or click "Connect warehouse")
Choose your warehouse type
Answer 2–3 simple questions about your setup
Run the generated setup script (one command in your cloud console)
Paste the output back into Celiq — connection tested automatically

Supported warehouses

Warehouse	Auth methods
BigQuery	Service account JSON
Snowflake	Username/password, key pair
PostgreSQL	Username/password, SSL
Redshift	Username/password
MySQL	Username/password

The setup script

Celiq generates a script that creates a read-only service account with the minimum permissions needed. You run it once in your cloud console — it takes about 30 seconds.

What the script does:

Creates a dedicated service account (e.g. celiq_reader)
Grants SELECT-only permissions on your schema
Outputs the credentials in the format Celiq expects

You never need to grant write access. Celiq is always read-only.

After connecting

Once the connection test passes, Celiq begins Auto-Provisioning — it scans your schema, detects your business type, and sets up your workspace automatically. See Auto-Provisioning.

Troubleshooting connection failures

Error	Likely cause
`SSL certificate error`	Set SSL mode to `require` or `disable` depending on your DB config
`Authentication failed`	Re-run the setup script — credentials may have expired
`Timeout`	Firewall rules blocking Celiq's IP range (see IP allowlist below)
`Permission denied on schema`	Re-run the setup script — the SELECT grant may not have applied

Celiq IP ranges (for allowlisting): See Lumen → Integrations → IP Allowlist.