Skip to content

Instantly share code, notes, and snippets.

@ahnj
Created October 29, 2020 03:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ahnj/8d90056deb2860b001a51fadcab03635 to your computer and use it in GitHub Desktop.
Save ahnj/8d90056deb2860b001a51fadcab03635 to your computer and use it in GitHub Desktop.
# invoke below set of configuration via:
# $ snowsql -c training
[connections.training]
# https://sfeducationalservices3_acct45.snowflakecomputing.com/
accountname = sfeducationalservices3_acct45
username = woodchuck
password = *your*password*here
# invoke default configuration via:
# $ snowsql
[connections]
# https://company.region.snowflakecomputing.com/
accountname = company.us-east-1
username = joeblogs
password = *password*here
[variables]
#Loads these variables on startup
#Can be used in SnowSql as select $example_variable
example_variable=27
[options]
# If set to false auto-completion will not occur interactive mode.
auto_completion = True
# main log file location. The file includes the log from SnowSQL main
# executable.
log_file = ~/.snowsql/log
# bootstrap log file location. The file includes the log from SnowSQL bootstrap
# executable.
# log_bootstrap_file = ~/.snowsql/log_bootstrap
# Default log level. Possible values: "CRITICAL", "ERROR", "WARNING", "INFO"
# and "DEBUG".
log_level = CRITICAL
# Timing of sql statments and table rendering.
timing = True
# Table format. Possible values: psql, plain, simple, grid, fancy_grid, pipe,
# orgtbl, rst, mediawiki, html, latex, latex_booktabs, tsv.
# Recommended: psql, fancy_grid and grid.
output_format = psql
# Keybindings: Possible values: emacs, vi.
# Emacs mode: Ctrl-A is home, Ctrl-E is end. All emacs keybindings are available in the REPL.
# When Vi mode is enabled you can use modal editing features offered by Vi in the REPL.
key_bindings = emacs
# OCSP Fail Open Mode.
# The only OCSP scenario which will lead to connection failure would be OCSP response with a
# revoked status. Any other errors or in the OCSP module will not raise an error.
# ocsp_fail_open = True
# Repository Base URL
# The endpoint to download the SnowSQL main module.
repository_base_url = https://sfc-repo.snowflakecomputing.com/snowsql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment