Troubleshooting
This section covers common errors you may encounter when connecting to or querying Data Lens, along with their likely causes and recommended solutions.
| Error | Cause | Solution |
|---|---|---|
| Connection timeout | Network/firewall issues | Add *.snowflakecomputing.com to your firewall allow list |
| Authentication failed | Invalid credentials | Verify username and check your SSO configuration |
| Permission denied | Insufficient privileges | Contact your admin for the MERCHANT_READER role |
| Query timeout | Query too complex | Add filters, reduce date range |
| No data returned | Incorrect merchant_id | Verify merchant_id, check date range |
| SSL certificate error | Outdated SSL/TLS | Update OS certificates, use TLS 1.2+ |
Diagnostic query
-- Check your current session info
SELECT CURRENT_USER(), CURRENT_ROLE(), CURRENT_DATABASE(), CURRENT_SCHEMA();
-- Verify table access
SHOW TABLES IN SCHEMA PAYPAL_DATASHARE_DB.RECONCILIATION;
-- Test data access
SELECT COUNT(*) FROM transfer_v1
WHERE DISBURSEMENT_DATE = CURRENT_DATE;