Skip to main content

​
Accessing Settings

​
Via VS Code Settings

  1. Open VS Code Settings:
    • Windows/Linux: Ctrl+,
    • Mac: Cmd+,
  2. Search for “Koala”
  3. Modify settings as needed

​
Via Settings JSON

  1. Open Command Palette (Ctrl+Shift+P)
  2. Type: “Preferences: Open Settings (JSON)”
  3. 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

LevelDescriptionUse Case
ERROROnly errorsProduction use
WARNWarnings and errorsNormal use
INFOGeneral informationDefault
DEBUGDetailed debuggingTroubleshooting

​
View Logs

  1. Open Command Palette
  2. Type: “Koala: View Logs”
  3. 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
}

​
Performance Settings

​
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

  1. Open Command Palette
  2. Type: “Preferences: Open Settings (JSON)”
  3. Remove all koalaDataExplorer.* entries
  4. 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

  1. Check for syntax errors in settings.json
  2. Reload VS Code window (Ctrl+R)
  3. Verify setting names are correct
  4. Check workspace vs user settings

​
Performance Issues

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):
  1. Workspace settings (.vscode/settings.json)
  2. User settings (~/.config/Code/User/settings.json)
  3. 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

Timeout Settings

Configure timeouts for your network

Logging

Set up logging for debugging

First Connection

Configure your first connection

Troubleshooting

Resolve configuration issues