Function to start a credential table

initCredentialsTable(
  db_id,
  db_full_name = db_id,
  dbms,
  user,
  password,
  connection_string,
  cdm_database_schema,
  work_database_schema,
  temp_emulation_schema = work_database_schema
)

Arguments

db_id: an id or shortName for a database. Please use snakecase
db_full_name: the full name of the database. If not specified defaults to db_id
dbms: the dbms for your database. Can be either redshift, postgres, snowflake, sql server or oracle
user: the user name to connect to the database
password: the password to connect to the databse
connection_string: a jdbc connection string to use with DatabaseConnector
cdm_database_schema: the cdm database schema of the datbase you want to use
work_database_schema: a scratch schema the user has read and write access to in order to build cohort tables
temp_emulation_schema: a schema required for oracle and snowflake to make temp tables.

Value

writes a csv to your home directory called shhh.csv storing your database credentials