- Run SQL and use the SQL REST API (for example submitting statements and checking status)
- Work with warehouses, databases, and schemas your role can access
- Build internal tools, dashboards, and data workflows backed by Snowflake
Common use cases and example apps
| Example app | Example prompt | Description |
|---|---|---|
| SQL explorer | Build an internal tool that runs read-only SQL against our analytics schema and shows results in a table. | Ad-hoc querying with guardrails you define in app logic. |
| Metric dashboard | Show daily revenue and signups from Snowflake summary tables with date filters. | Operational dashboards fed by modeled tables in Snowflake. |
| Pipeline status | After a user uploads a file, poll Snowflake for load completion and show pass/fail. | Orchestration-style UX on top of warehouse data. |
| Support lookup | Given an account ID, load key fields from our Snowflake customers view for the support UI. | Enrich product UIs with trusted warehouse data. |
| Data validation | Run lightweight row counts and null checks on staging tables after our ETL runs. | Quality checks using SQL against Snowflake. |
How Snowflake connections work
- OAuth 2.0 (authorization code): You register a custom OAuth integration in Snowflake and enter the Account URL, Client ID, Client secret, and Role in Lovable. You (or your admin) then complete sign-in with Snowflake to authorize the connection.
- Role: Choose a role that has the warehouse and object access your app needs. Do not use
ACCOUNTADMINorSECURITYADMIN, they are blocked by the connector validation pattern. - Gateway: API requests are proxied through Lovable’s connector gateway, which manages tokens. See Gateway-based connectors for limits.
Snowflake compute and storage costs are billed by Snowflake / your cloud agreement, not by Lovable.
How to connect Snowflake
Workspace admins and owners can create Snowflake connections. Link each connection to the Lovable projects that should use it.Prerequisites
- Access to a Snowflake account where you can create or manage an OAuth security integration
- Permission to use a Snowflake role appropriate for your app (not
ACCOUNTADMINorSECURITYADMIN) - Lovable workspace admin or owner role
Step 1: Create a Snowflake OAuth integration
Work with your Snowflake administrator if needed.- In Snowflake, create a custom OAuth security integration and obtain the OAuth client ID and client secret.
- Configure redirect URIs and any other settings required by your organization. Use the redirect URI that Lovable shows during the connect flow so authorization can complete.
- Confirm the account URL (for example
https://myorg-myaccount.snowflakecomputing.com).
Step 2: Connect Snowflake in Lovable
- Go to Settings → Connectors → Shared connectors and select Snowflake.
- Click Add connection.
- Enter a Display name (for example
Snowflake Prod). - Fill in Account URL, Client ID, Client secret, and Role exactly as in Snowflake.
- Start the Connect / Authorize flow and sign in to Snowflake when prompted.
Limitations
- Scopes and roles are determined by your Snowflake OAuth integration and the role you configure; the app cannot exceed those permissions.
- Per-user Snowflake login for every visitor is not what this connector provides—it represents a shared authorization for the workspace connection.
- Gateway limits apply as described in Gateway-based connectors.
How to unlink projects from a connection
Editors and above can remove specific projects from a connection without deleting the connection entirely. The connection will remain available for other projects. To unlink projects:
When unlinked, those projects will no longer have access to through this connection. If a project needs again, you can link it to any available connection.