Troubleshooting

Common issues and how to resolve them.

Query returns stale data

What it means: Your query results don't reflect the latest sync. You see old data even though a sync completed successfully.

What to do: Check the sync history for the connection to confirm the sync finished. If it did and you still see stale data, click "Refresh" in the query editor's schema browser to reload the table list.

Sync shows error

What it means: One or more tables failed during the sync. The connection status shows error.

Why it happens: Common causes include:

• Credentials expired or revoked - API tokens (Stripe, HubSpot, Salesforce) can expire. Database passwords can be rotated.
• Source unreachable - the database server or API endpoint is down or blocking your IP
• Permission changes - the database user no longer has SELECT access on certain tables
• Schema change - a table or column was renamed or removed at the source

What to do:

1. Check the error message in the sync history - it shows which tables failed and why
2. Fix the underlying issue (update credentials, check network, restore permissions)
3. Use "Test Connection" to verify the fix
4. Re-run the sync - tables that succeeded previously still have their data, only failed tables need re-syncing

Partial failures are possible: some tables may sync successfully while others fail. Successfully synced tables are still queryable.

Connection test fails

What it means: rawquery cannot reach your data source with the provided credentials.

What to do:

• Database connections (PostgreSQL, MySQL) - verify the host, port, database name, username, and password. Ensure the rawquery server IP is allowed in your firewall or security group rules.
• API connections (Stripe, HubSpot, Salesforce, Shopify) - verify your API key or OAuth token is valid and has the required scopes
• Google Sheets - ensure the sheet is shared with the service account email shown during setup