Configure DataStax Studio

# Maximum number of items returned per cell execution. Result set will be
# truncated to this number of rows, edges, vertices, etc.
# Default: 1000 items
resultSizeLimit: 1000

# Graph: maximum content length returned for a cell result (bytes).
# Default: 524288 bytes
maxResultSizeBytes: 524288

# Cell execution timeout (milliseconds). A value of 0 indicates no timeout and
# will depend on the DSE server timeouts configured in dse.yaml.
# Default: 0 milliseconds (no timeout)
executionTimeoutMs: 0

# Determines if selected editor text can be executed, instead of the entire
# cell content. When set to 'true':
#   Graph cells: only the exact selected text is executed
#   CQL and Spark SQL cells: the selected text is expanded to full statement(s)
#   before being executed.
# Default: true
executeSelectionEnabled: true

# The timezone used to display Date and Timestamp values.
# Examples: UTC, GMT, CET, America/Los_Angeles, America/New_York, Europe/Paris, Asia/Kolkata, etc
# These zone IDs are defined by Java in java.time.ZoneId
# Some special values are also supported:
# * SYSTEM - use the default system timezone.
# * TIMESTAMP - display as timestamp value (milliseconds since epoch)
# Default: UTC
displayTimezone: UTC

# Studio web server options.
server:
  # Studio web server http port
  # Default: 9091
  httpPort: 9091

  # WARNING: Changing the setting from the default (localhost) can pose a
  # security risk as users on external machines can gain access to notebooks
  # and the DSE clusters those notebooks are connected to.
  # Studio is designed to be used as a desktop application. Distributed
  # deployment introduces potential security risks.
  # Default: localhost
  httpBindAddress: localhost

# Logging options.
logging:
  # Log file name.
  # Default: studio.log
  fileName: studio.log

  # Max log file size.
  # Default: 250 MB
  maxLogFileSize: 250 MB

  # Max number of archived logs to retain.
  # Default: 10
  maxFiles: 10

  # Log directory.
  # Default: ./logs
  directory: ./logs

  # Spark SQL log level.
  # 0: Disable all logging
  # 1: Log severe error events that abort the driver
  # 2: Log errors that may allow driver to continue
  # 3: Log events that might results in an error
  # 4: Log general driver progress information
  # 5: Log detailed driver debug information
  # 6: Log all driver activity
  # Default: 0
  sparkSQLLogLevel: 0

# User application data options
userData:
  # Application data directory location for user data, including connection
  # and notebook data, events, and history.
  # A value of 'null' will translate to ~/.datastax_studio
  # Default: null
  baseDirectory: null

  # Save frequency for minor cell revisions (seconds). Changes considered 'minor'
  # include: cell editor and settings changes. Major changes, such as cell
  # execution and new results always create a new revision immediately.
  # Default: 300 seconds
  historySaveFrequencyInSeconds: 300

  # Determines if notebook revisions should be deleted based on age.
  # When there are more than 'minHistoryRevisionsToKeep' history revisions,
  # revisions older than 'maxDaysOfHistoryToKeep' days are deleted.
  # Default: true
  pruneRevisionHistoryEnabled: true

  # Minimum number of revisions to retain before pruning by date is enforced.
  # Default: 25
  minHistoryRevisionsToKeep: 25

  # Maximum amount of time notebook revision history files are kept before
  # being deleted (days). This age limit is only applied after the minimum
  # number of history revisions to keep ('minHistoryRevisionsToKeep') has
  # been exceeded.
  # Default: 30 days
  maxDaysOfHistoryToKeep: 30

# Database connection options.
connectionManagement:
  # Java driver: socket options connection timeout (milliseconds).
  # Default: 5000 milliseconds
  connectTimeoutInMillis: 5000

  # Java driver: socket options read timeout (milliseconds).
  # Default: 3000 milliseconds
  readTimeoutInMillis: 3000

  # Java driver: Constant reconnect policy delay (milliseconds).
  # Default: 10000 milliseconds
  constantReconnectPolicyDelayInMillis: 10000

  # Tinkerpop driver: Gremlin server port.
  # Default: 8182 using a standard connection, 30046 when using a secure bundle (Astra)
  defaultGremlinPort: 8182

  # Tinkerpop driver: Time limit for establishing a connection (milliseconds).
  # Default: 5000 milliseconds
  maxWaitForConnection: 5000

  # Spark JDBC driver: Spark SQL port.
  # Default: 10000
  defaultSparkSQLPort: 10000