# JDBC Connection string (Oracle, Mysql, H2, etc.) jdbc.connect.url=jdbc:snowflake://XXXXX.snowflakecomputing.com/?warehouse=SALES_OPS_WH&db=PROD1&schema=SALES_OPS_CARI/?private_key_file=/Users/kjochim/Documents/Anaplan/Keys/rsa_key.p8&private_key_file_pwd=XXXX # JDBC login username # jdbc.username=username # JDBC login password #jdbc.password=dbpasswordforuser1 # (Optional) JDBC Fetch size, might not be applicable for all JDBC driver flavors. jdbc.fetch.size=10 # Boolean flag, needs to be true if provided {jdbc.query} is a # stored-procedure/function call. # Defaults to false if no value provided, or invalid. jdbc.isStoredProcedure=false # SQL query could be Select or a Stored-Procedure/Function call. In case of latter, # require {jdbc.isStoredProcedure} above set to "true". # NOTE: SQL query needs to be parametrized with ? placeholders and values for # placeholders needs to be provided below in {jdbc.params}. jdbc.query=SELECT * FROM PROD1.SALES_OPS_CARI.ANAPLAN_DIM_OPPS # JDBC parameters for parametrized SQL query in {jdbc.query} above. # NOTE: Number of parameters must equal to the number of parameters provided in {jdbc.query} above. # jdbc.params=1234,ABC