Team Studio Configuration Properties

Use the file chorus.properties to configure much of Team Studio.

The configuration file and its companion example file are located in the directory <installation directory>/shared/. The example file,chorus.properties.example , contains examples of all of the properties that you can set in chorus.properties. You can use this example file to learn about the possible properties you can set in chorus.properties. You can include any attribute from the example file in the configuration file.

Note: You must restart Team Studio to the changes you make in chorus.properties to take effect.
chorus.properties options
Property Default setting Description
public_url mycomputer.example.com Network location of the Team Studio application.

Do not include HTTP: or the port number.

server_port 8080 The Team Studio application default port.
postgres_port 8543 The PostgreSQL port.
solr_port 8983 The Apache Solr port.
java_options -Djava.library.path=$CHORUS_HOME/vendor/hadoop/lib/ -server -Xmx2048m -Xms512m -XX:MaxPermSize=128 Command-line options to include on the Java command line when running the Team Studio application.
ssl.enabled FALSE Use to configure SSL for Team Studio. Set ssl.enabled=true to enable SSL.
ssl_server_port 8443 Use to configure SSL for Team Studio. Set the port number with ssl_server_port.
ssl_certificate n/a Use to configure SSL for Team Studio. Set to the path of the server's SSL certificate.
ssl_certificate_key n/a Use to configure SSL for Team Studio. Set to the location of the private key.
workflow.enabled true Enables the workflow feature in Team Studio. The Team Studio server port is set during installation.
workflow.url http://localhost:8070 The URL of the Team Studio server, which is installed with Team Studio. The URL can be an IP address or fully-qualified machine name. Whichever is used, it should be reachable from a browser.

If you must change the port number after installing Team Studio, be sure to also change the port number in the Team Studio Tomcat server configuration file, $CHORUS_HOME/alpine/apache-tomcat-7.x.x/conf/server.xml. Look for the <Connector> element with attribute protocol="HTTP/1.1" under the <Service name="Catalina"> element.

smtp.address localhost Configures the SMTP connection that Team Studio uses to deliver email notifications to users. Sets the network address of the SMTP service.
smtp.port 587 Configures the SMTP connection that Team Studio uses to deliver email notifications to users. Sets the port for the SMTP service.
smtp.user_name USER_NAME Configures the SMTP connection that Team Studio uses to deliver email notifications to users.
smtp.password PASSWORD Configures the SMTP connection that Team Studio uses to deliver email notifications to users.
smtp.authentication login Configures the SMTP connection that Team StudioTeam Studio uses to deliver email notifications to users.
smtp.enable_starttls_auto false Configures the SMTP connection that Team Studio uses to deliver email notifications to users.
mail.enabled FALSE If true, Team Studio delivers job completion and failure notifications to users by email.
mail.from FROMNAME <noreply@chorus.com> Sets the from header in the email message.
mail.reply_to REPLY NAME <noreply@chorus.com> Sets the reply_to header in the email message.
sandbox_recommended_size_in_gb 5 The sandbox-related setting. The default unit is in GB.
Note: This value provides a visual indicator that indicates when a workspace's sandbox exceeds the recommended size.
worker_threads 1 Configures the thread pool size of webserver and worker processes.
webserver_threads 20 The number of webserver threads determines the maximum number of simultaneous web requests.
database_threads 25 The number of worker threads determines the maximum number of asynchronous jobs, such as table copying or importing, that can be run simultaneously.

Each web or worker thread can use its own connection to the local PostgreSQL database. Therefore, the sum of worker_threads and webserver_threads must be less than the max_connections configured in postgresql.conf. The max_connections parameter can be based on the operating system's kernel shared memory size. For example, on OS X this parameter defaults to 20.

session_timeout_minutes 480 The default session timeout time. The number of minutes you can be inactive before you are logged out.
clean_expired_api_tokens_interval_hours 24 renamed in 6.2 from clean_expired_sessions_interval_hours.
delete_unimported_csv_files_interval_hours 1
delete_unimported_csv_files_after_hours 12
instance_poll_interval_minutes 5
reindex_search_data_interval_hours 24
reindex_datasets_interval_hours 24 Sets the frequency for dataseet reindexing.
reset_counter_cache_interval_hours 24
file_download.name_prefix n/a This optional string is prefixed on all generated file names. For example, if a user downloads a dataset, the name of the file downloaded is the specified prefix, followed by the dataset name and then the .csv extension. Only the first 20 characters of the prefix is used.
file_sizes_mb.workfiles 10 Maximum upload work file size.
file_sizes_mb.csv_imports 100 Maximum size for imported files.
file_sizes_mb.user_icon 5 Maximum size for the user icon.
file_sizes_mb.workspace_icon 5 Maximum size for the workspace icon.
file_sizes_mb.attachment 10 Maximum size for file attachments.
logging.syslog.enabled false If true, logs are written to syslog rather than to files.
logging.loglevel info The minimum severity of messages to log. Can be debug, info, warn, error, or fatal.
oracle.enabled TRUE Enables use of Oracle databases.
gpfdist.ssl.enabled false To enable data movement between databases, gpfdist must be installed and running on the Team Studio host. Two gpfdist processes must be started with different ports pointing to the same directory. An SSL certificate must be installed on all segment servers.
gpfdist.url sample-gpfdist-server
gpfdist.write_port 8000
gpfdist.read_port 8001
gpfdist.data_dir /tmp
tableau.enabled TRUE If false, Tableau is disabled even if other Tableau parameters are specified.
tableau.url >ip address> The URL of the Tableau server. The URL can be an IP address or a fully-qualified computer name. Whichever is used, it should be reachable from a browser.
tableau.port 8000 The Tableau server port.
Note: This port must be opened on your Tableau server.
tableau.sites marketing,sales The list of Tableau sites. Team Studio supports this parameter starting in version 5.3. If this option is not present, Team Studio publishes to the default Tableau site.
newrelic.enabled false Enables New Relic application performance monitoring. See http://newrelic.com for more information.
newrelic.license_key NEWRELIC_LICENSE_KEY
default_preview_row_limit 500 The maximum number of preview rows.
execution_timeout_in_minutes 300 The workfile execution timeout in minutes.
visualization.overlay_string n/a This optional string is displayed on all visualizations, both when displaying and when saving.

Only the first 40 characters of the prefix are used.

database_login_timeout 10 Database connection timeout, in seconds. If you are using Google BigQuery as a data source and you are copying large amounts of data between databases, consider increasing this value so the operation does not fail unexpectedly.
jdbc_schema_blacklist.postgresql [information_schema, pg_catalog] Specifies a list of PostgreSQL schemas that are excluded from display, index, and search. (That is, they are effectively excluded from Team Studio).
jdbc_schema_blacklist.sqlserver [db_accessadmin, db_backupoperator, db_datareader, db_datawriter, db_ddladmin, db_denydatareader, db_denydatawriter, db_owner, db_securityadmin, dbo, INFORMATION_SCHEMA, sys] Specifies a list of SQL Server schemas that are excluded from display, index, and search. (That is, they are effectively excluded from Team Studio).
jdbc_schema_blacklist.teradata [All, Crashdumps, DBC, dbcmngr, Default, EXTUSER, LockLogShredder, PUBLIC, SQLJ, SysAdmin, SYSBAR, SYSLIB, SYSSPATIAL, SystemFe, SYSUDTLIB, Sys_Calendar, TDPUSER, TDQCD, TDStats, tdwm, TD_SYSFNLIB, TD_SYSXML] Specifies a list of Teradata schemas that are excluded from display, index, and search. (That is, they are effectively excluded from Team Studio).
Related concepts