⚡ TL;DR Create a custom OAuth security integration, add the account URL, client ID and secret, and use a least-privilege role. Reconnect about every 90 days.
Warehouse data, finally in front of the people who need it.
🔌 What It Does
Runs SQL, uses the SQL REST API and reads warehouses and semantic views through native OAuth.
⚙️ Setting It Up
Enter the account URL plus the OAuth client ID and secret from a custom security integration, and assign a dedicated least-privilege role.
💡 What You Can Build
A few ideas:
- ✅ SQL explorers
- ✅ Metric dashboards
- ✅ Pipeline status checks
- ✅ Support lookups
⚠️ Limits
One shared connection per workspace, access limited by role, queries need a warehouse, and a reconnect about every 90 days.
💡 Pro tip Set a reminder to reauthorize before the 90 days run out.
Need data apps built on Snowflake? Lord of the Wix can help. ✨
❓ Lovable Snowflake integration FAQ
How does it authenticate?
Native Snowflake OAuth.
Are connections per user?
No, shared.
How often must I reconnect?
About every 90 days.
Is a warehouse required?
Yes.
Are semantic views supported?
Yes.
🙏 Credit: Based on public information from the Lovable documentation. Lovable is a product of Lovable. Source: docs.lovable.dev. Lord of the Wix is an independent agency and is not affiliated with Lovable.