Accessing Settings
Via VS Code Settings
- Open VS Code Settings:
- Windows/Linux:
Ctrl+,
- Mac:
Cmd+,
- Search for “Koala”
- Modify settings as needed
Via Settings JSON
- Open Command Palette (
Ctrl+Shift+P)
- Type: “Preferences: Open Settings (JSON)”
- Add Koala settings
Core Settings
Query Execution
{
// Request timeout in milliseconds (default: 120000 = 2 minutes)
"koalaDataExplorer.timeout": 120000,
// Maximum rows to return (default: 1000)
// Note: Locked to 50 in free mode
"koalaDataExplorer.maxRows": 1000,
// Auto-refresh data sources on connection
"koalaDataExplorer.autoRefreshDataSources": true
}
Timeout Configuration
Adjust timeout for different scenarios:
{
// Quick queries (30 seconds)
"koalaDataExplorer.timeout": 30000,
// Standard queries (2 minutes)
"koalaDataExplorer.timeout": 120000,
// Complex queries (5 minutes)
"koalaDataExplorer.timeout": 300000,
// Very long queries (10 minutes)
"koalaDataExplorer.timeout": 600000
}
Longer timeouts may cause VS Code to become unresponsive. Use scheduled reports for very long-running queries.
Logging Settings
Enable Logging
{
// Enable debug logging
"koalaDataExplorer.logging.enabled": true,
// Set logging level
"koalaDataExplorer.logging.level": "INFO",
// Maximum log entries to keep
"koalaDataExplorer.logging.maxLogs": 1000
}
Logging Levels
| Level | Description | Use Case |
|---|
ERROR | Only errors | Production use |
WARN | Warnings and errors | Normal use |
INFO | General information | Default |
DEBUG | Detailed debugging | Troubleshooting |
View Logs
- Open Command Palette
- Type: “Koala: View Logs”
- Review log entries in the panel
Scheduled Report Settings
For large dataset processing:
{
// Maximum wait time for scheduled reports (15 minutes)
"koalaDataExplorer.scheduleReport.maxPollTime": 900000,
// Download chunk size in KB (50MB)
"koalaDataExplorer.scheduleReport.chunkSizeKB": 50000,
// Enable for large datasets
"koalaDataExplorer.scheduleReport.enableForLargeDatasets": true
}
SQL History Settings
{
// Maximum SQL history entries (default: 500)
// Note: Limited to 50 in free mode
"koalaDataExplorer.sqlHistory.maxEntries": 500
}
Memory Management
For large result sets:
{
// Limit rows for better performance
"koalaDataExplorer.maxRows": 500,
// Disable auto-refresh for slow connections
"koalaDataExplorer.autoRefreshDataSources": false
}
Network Optimization
{
// Shorter timeout for fast networks
"koalaDataExplorer.timeout": 60000,
// Smaller chunks for slow connections
"koalaDataExplorer.scheduleReport.chunkSizeKB": 10000
}
Development Settings
Testing and QA
{
// Force free mode for testing
"koalaDataExplorer.license.forceFreeMode": true,
// Enable verbose logging
"koalaDataExplorer.logging.enabled": true,
"koalaDataExplorer.logging.level": "DEBUG"
}
Workspace vs User Settings
User Settings (Global)
Applied to all VS Code projects:
// ~/.config/Code/User/settings.json
{
"koalaDataExplorer.timeout": 120000,
"koalaDataExplorer.logging.enabled": false
}
Workspace Settings (Project)
Applied only to current project:
// .vscode/settings.json
{
"koalaDataExplorer.maxRows": 5000,
"koalaDataExplorer.autoRefreshDataSources": false
}
Workspace settings override user settings for the current project.
Environment-Specific Configuration
Development Environment
{
"koalaDataExplorer.timeout": 300000,
"koalaDataExplorer.maxRows": 10000,
"koalaDataExplorer.logging.enabled": true,
"koalaDataExplorer.logging.level": "DEBUG"
}
Production Environment
{
"koalaDataExplorer.timeout": 120000,
"koalaDataExplorer.maxRows": 1000,
"koalaDataExplorer.logging.enabled": false,
"koalaDataExplorer.autoRefreshDataSources": true
}
Proxy Configuration
For corporate networks:
{
// Proxy server URL
"http.proxy": "http://proxy.company.com:8080",
// Disable SSL verification (development only)
"http.proxyStrictSSL": false,
// Proxy authentication
"http.proxyAuthorization": null
}
Reset to Defaults
Reset All Settings
- Open Command Palette
- Type: “Preferences: Open Settings (JSON)”
- Remove all
koalaDataExplorer.* entries
- Reload VS Code
Default Values
{
"koalaDataExplorer.timeout": 120000,
"koalaDataExplorer.maxRows": 1000,
"koalaDataExplorer.autoRefreshDataSources": true,
"koalaDataExplorer.logging.enabled": false,
"koalaDataExplorer.logging.level": "INFO",
"koalaDataExplorer.logging.maxLogs": 1000,
"koalaDataExplorer.scheduleReport.maxPollTime": 900000,
"koalaDataExplorer.scheduleReport.chunkSizeKB": 50000,
"koalaDataExplorer.scheduleReport.enableForLargeDatasets": true,
"koalaDataExplorer.sqlHistory.maxEntries": 500,
"koalaDataExplorer.license.forceFreeMode": false
}
Troubleshooting Settings
Settings Not Applied
- Check for syntax errors in settings.json
- Reload VS Code window (
Ctrl+R)
- Verify setting names are correct
- Check workspace vs user settings
If extension is slow:
{
"koalaDataExplorer.maxRows": 100,
"koalaDataExplorer.autoRefreshDataSources": false,
"koalaDataExplorer.logging.enabled": false
}
Connection Problems
For connection issues:
{
"koalaDataExplorer.timeout": 180000,
"http.proxyStrictSSL": false,
"koalaDataExplorer.logging.enabled": true,
"koalaDataExplorer.logging.level": "DEBUG"
}
Settings Priority
Settings are applied in this order (highest priority first):
- Workspace settings (
.vscode/settings.json)
- User settings (
~/.config/Code/User/settings.json)
- Default settings (extension defaults)
Export/Import Settings
Export Settings
# Copy settings to share with team
cp ~/.config/Code/User/settings.json ./koala-settings-backup.json
Import Settings
# Import settings from backup
cp ./koala-settings-backup.json ~/.config/Code/User/settings.json
Next Steps
