YAML
####################################################################################################
# Example YAML for Tot Plugin Redshift #
# #
# This file has all the technical properties that can be edited for the client. #
# These properties have a default value in the application, #
# so there is no necessity to configure them. #
# Only configure these properties if they are going to be different to the value of this file, #
# this will make your files more clean and readable. #
####################################################################################################
#########################
### Server properties ###
#########################
server:
# the port where the service will be listening
port: 15017
#############################
### Tot Plugin properties ###
#############################
totplugin:
server:
# the tot server list of URLs, tot can have more than one instance running.
urls:
- https://tot1server.anjanadata.local/totserver/
####################################
### Redshift instance properties
## name: Name of the connection instance
## aris: list of aris to define the different instance functionalities
## technology: bellow this are the specific connection properties of the instance
## sampleRows: number of sample rows
## path-separator: character to be used by Anjana for the path
## query-separator: character to be used on queries
## using-catalogs: lists all tables of all schemas in all databases you see
## using-schemas: lists all the tables of all the schemas you have access to
## obfuscation-string: string to replace information when it is obfuscated
## sample: the query to obtain the sample data
##
####################################
connection:
- name: example-instance
aris:
- ari: "anja:totplugin:sample:/jdbc/redshift/devQA/"
- ari: "anja:totplugin:extract:/jdbc/redshift/devQA/"
- ari: "anja:totplugin:im:/jdbc/redshift/devQA/"
imAri: "anja:totplugin:im:/ldap/ldap/ldap/"
technology:
driver: com.amazon.redshift.jdbc42.Driver
url: jdbc:redshift://rdbservice:5432/anjana
user: <user>
password: <password>
sampleRows: 15
path-separator: "/"
query-separator: "."
using-catalogs: false
using-schemas: true
obfuscation-string: "*****"
####################################
### SQL properties
## sql: Common SQL properties for all instances
## query-pattern: list of properties for the queries that can be configured
## sample: Pattern for the sample query
####################################
sql:
query-pattern:
sample: "SELECT * FROM {0} LIMIT {1}"
########################
## Logs properties ###
########################
logging:
pattern:
# Pattern to convert logs in the convenient format for the client
console: "%clr(%d{yyyy-MM-dd HH:mm:ss.SSS}){faint} [TOT-PLUGIN-JDBC-REDSHIFT] %clr(${LOG_LEVEL_PATTERN:%5p}) %clr(${PID:- }){magenta} %clr(---){faint} %clr([%15.15t]){faint} %clr(%-40.40logger{39}){cyan} %clr(:){faint} %m%n${LOG_EXCEPTION_CONVERSION_WORD:%wEx}"
# Mark the level of log to show for every package. ERROR > WARN > INFO > DEBUG > TRACE
level:
# The main log level this is the base fot all logs
root: info
# Every package of code can be marked with a different log level, every package of code printed on log is selectable to have a record here and mark a log level
com.anjana: DEBUG
#################################
### Hecate(Eureka) properties ###
#################################
eureka:
client:
serviceUrl:
# the url where Tot is listening
defaultZone: http://totserver/totserver/eureka