Sqlalchemy Call Crashes Kernel in VSC But Not In Jupyter Notebook

[dmiller2u]

Instantiating a sqlalchemy inspector element works in Jupyter notebook but crashes the kernel when run in VSC / Jupyter under Windows 10 or 11. What's most unusual is that this code has worked for years in what appears to be a stable environment, and all of a sudden started exhibiting this very strange behavior. Here's the code:

import sqlalchemy

# instantiate sqlalchemy engine
# replace with your own IP and database name
enginename = 'postgresql://[email protected]:5432/dbname'
engine = sqlalchemy.create_engine(enginename)

# kernel crashes here when running in VSC but works fine in Jupyter Notebook!!!
inspector = sqlalchemy.inspect(engine)

Note I did a complete wipe and fresh VSC reinstall using latest VSC version but still see the same behavior. I also tried a prior VSC version but see same behavior.

Environment data

• VS Code version: 1.96.4
• Jupyter Extension version 2024.11.0
• Python Extension version 2024.22.2
• OS: Same behavior under Windows 10 or Windows 11
• Python version: 3.8.19
• sqlalchemy version: 2.0.32 (NOTE: problem disappears when using an alternative environment using python version 3.8.12 and sqlalchemy version 1.4.27)
• Type of virtual environment used: anaconda-project
• Jupyter server running: Local

Logs

Running exact same environment in Jupyter Notebook works fine, but when running in VSC gives the following error message:

The Kernel crashed while executing code in the current cell or a previous cell. 
Please review the code in the cell(s) to identify a possible cause of the failure. 
Click here for more info. 
View Jupyter log for further details.

Trace level output from jupyter log shows ExitCode: 3221225477 which from what I can tell means a generic memory access violation or crash in the Jupyter kernel process or conflicts between different Python environments or package versions. But I am running this on a machine with plenty of memory, and the code and identical environment works perfectly in Jupyter Notebook, so the issue is clearly somehow with VSC.

Here's the trace level jupyter log output:

[trace] Cell 1 executed successfully
[debug] Handle Execution of Cells 2 for e:\Python\WeatherNormalization\vsc_crash_debug.ipynb
[trace] Execute Notebook e:\Python\WeatherNormalization\vsc_crash_debug.ipynb. Step 1
[trace] Connect to Kernel e:\Python\WeatherNormalization\vsc_crash_debug.ipynb. Step 2
[trace] Connected to Kernel e:\Python\WeatherNormalization\vsc_crash_debug.ipynb. Step 3
[trace] executeCell 2. Step 4
[trace] Cell Index:2 sent to kernel
[trace] Start cell 2 execution @ 1737743806589 (clear output)
[debug] Kernel acknowledged execution of cell 2 @ 1737743806589
[debug] KernelProcess Exited 20268, Exit Code - 3221225477 
[error] Disposing session as kernel process died ExitCode: 3221225477, Reason: 
[debug] Dispose Kernel process 20268.
[debug] Disposed Kernel process 20268.
[trace] Cell 2 completed in -1737743806.589s (start: 1737743806589, end: undefined)

[DonJayamanne]

Sorry you are running into this issue and thank you for the details and analysis.

Please could you enable logging as follows:

• Open settings & go into Jupyter->Logging
• Change the value to trace
• Reload VS Code,
• Attempt to repro the issue & then copy the output from the Jupyter output panel (use the command Jupyter: Show Output to get to the logs).

Please could you also run the following code in VS code and Jupyter Notebook

import os
print(os.getenv())

Compare the result (environment variables) between VS Code and Jupyter Notebook
This would give you a clue what could be causing this issue.

In the past we've found that some env variables were not setup and that causes this issue.
As a rule of thumb when using Jupyter in VS code, its best to rely on setting environment variables using .env files as opposed to setting them in shell files such as .bash_profile or the like.

[DonJayamanne]

sqlalchemy version: 2.0.32 (NOTE: problem disappears when using an alternative environment using python version 3.8.12 and sqlalchemy version 1.4.27)

Wait, I'm confused, does this work when using Python 3.8.12?

[dmiller2u]

Thanks for your support.

Trace level jupyter logging is already included in the original issue writeup.

Regarding comparing environment variables between Jupyter Notebook and VSC: I am running on a fresh install of Windows 11 and have not manually adjusted any environment variables either in Jupyter Notebook or VSC - fresh install of VSC as well. So not sure how environment variables could be conflicting. Also are you suggesting just going through all environment variables one at a time to compare, or are you suggesting I check specific environment variables?

Yes, the problem goes away in Python 3.8.12 as stated in the writeup.

Thanks for any help solving this! I would love to get to the bottom of this. I suppose I could just try to rebuild my environments to see if this behavior resolves, but the fact that it works in Jupyter Notebook suggests there is a better solution, one where I'm not playing whack-a-mole.

Thanks!

[DonJayamanne]

Also are you suggesting just going through all environment variables one at a time to compare, or are you suggesting I check specific environment variables?

Yes, or please feel free to share them with me and I can compare it

[dmiller2u]

Thanks so much for your help. Here's a listing of all Windows environment variables (powershell: Get-ChildItem Env: | Format-Table -Wrap -AutoSize). I also run the same powershell command in VSC terminal to get the corresponding VSC environment variables. I think I may have attempted to update path sometime before all this bugginess started to happen, but don't recall messing w/other environment variables. Let me know if this helps. I am staring at the two lists and besides some additional environment variables in VSC I cannot see any differences.

Here are WINDOWS 11 environment variables:

Name                                Value                                                                              
----                                -----                                                                              
__CONDA_OPENSLL_CERT_FILE_SET       1                                                                                  
_CONDA_EXE                          C:/Miniconda3\Scripts\conda.exe                                                    
_CONDA_ROOT                         C:/Miniconda3                                                                      
ALLUSERSPROFILE                     C:\ProgramData                                                                     
APPDATA                             C:\Users\dm4\AppData\Roaming                                                       
CLIENTNAME                          VDI-ICPROD-M01                                                                     
CommonProgramFiles                  C:\Program Files\Common Files                                                      
CommonProgramFiles(x86)             C:\Program Files (x86)\Common Files                                                
CommonProgramW6432                  C:\Program Files\Common Files                                                      
COMPUTERNAME                        SF150PYCLIENT22                                                                    
ComSpec                             C:\WINDOWS\system32\cmd.exe                                                        
CONDA_DEFAULT_ENV                   base                                                                               
CONDA_EXE                           C:\Miniconda3\Scripts\conda.exe                                                    
CONDA_PREFIX                        C:\Miniconda3                                                                      
CONDA_PROMPT_MODIFIER               (base)                                                                             
CONDA_PYTHON_EXE                    C:\Miniconda3\python.exe                                                           
CONDA_SHLVL                         1                                                                                  
deployment.expiration.check.enabled false                                                                              
DriverData                          C:\Windows\System32\Drivers\DriverData                                             
EFC_10100                           0                                                                                  
FSAL_JAVA_HOME                      C:\Program Files\Java\jre1.8.0_111                                                 
HOMEDRIVE                           C:                                                                                 
HOMEPATH                            \Users\dm4                                                                         
LOCALAPPDATA                        C:\Users\dm4\AppData\Local                                                         
LOGONSERVER                         \\CPUC-ENERGYDC01                                                                  
NUMBER_OF_PROCESSORS                16                                                                                 
OneDrive                            C:\Users\dm4\OneDrive                                                              
OS                                  Windows_NT                                                                         
Path                                C:\Miniconda3;C:\Miniconda3\Library\mingw-w64\bin;C:\Miniconda3\Library\usr\bin;C:\
                                    Miniconda3\Library\bin;C:\Miniconda3\Scripts;C:\Miniconda3\bin;C:\Miniconda3\condab
                                    in;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\Sy
                                    stem32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;C:\WINDOWS\System32\OpenSSH;
                                    C:\Program Files (x86)\Webex\Plugins;C:\Program Files                              
                                    (x86)\PuTTY;C:\Amazon\AWSCLIV2;C:\Program Files\nodejs;C:\Program                  
                                    Files\Git\cmd;C:\Program Files\Pandoc;C:\Program Files\Microsoft VS                
                                    Code\bin;C:\Users\dm4\AppData\Local\Microsoft\WindowsApps;C:\Program Files         
                                    (x86)\GnuWin32\bin;C:\Program Files (x86)\wget;C:\Program Files\Microsoft          
                                    Office\root\Office16;C:\Users\dm4\AppData\Roaming\npm;.                            
PATHEXT                             .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.CPL                         
PROCESSOR_ARCHITECTURE              AMD64                                                                              
PROCESSOR_IDENTIFIER                Intel64 Family 6 Model 85 Stepping 7, GenuineIntel                                 
PROCESSOR_LEVEL                     6                                                                                  
PROCESSOR_REVISION                  5507                                                                               
ProgramData                         C:\ProgramData                                                                     
ProgramFiles                        C:\Program Files                                                                   
ProgramFiles(x86)                   C:\Program Files (x86)                                                             
ProgramW6432                        C:\Program Files                                                                   
PSExecutionPolicyPreference         Bypass                                                                             
PSModulePath                        C:\Users\dm4\Documents\WindowsPowerShell\Modules;C:\Program                        
                                    Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules 
PUBLIC                              C:\Users\Public                                                                    
SESSIONNAME                         RDP-Tcp#0                                                                          
SSL_CERT_FILE                       C:\Miniconda3\Library\ssl\cacert.pem                                               
SystemDrive                         C:                                                                                 
SystemRoot                          C:\WINDOWS                                                                         
TEMP                                C:\Users\dm4\AppData\Local\Temp                                                    
TMP                                 C:\Users\dm4\AppData\Local\Temp                                                    
UATDATA                             C:\WINDOWS\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77                        
USERDNSDOMAIN                       ENERGY.DMZ.LOCAL                                                                   
USERDOMAIN                          ENERGY                                                                             
USERDOMAIN_ROAMINGPROFILE           ENERGY                                                                             
USERNAME                            dm4                                                                                
USERPROFILE                         C:\Users\dm4                                                                       
windir                              C:\WINDOWS                                                                         

And here are VSC environment variables (running same powershell command in VSC terminal):

Name                                Value
----                                -----
ALLUSERSPROFILE                     C:\ProgramData
APPDATA                             C:\Users\dm4\AppData\Roaming
CHROME_CRASHPAD_PIPE_NAME           \\.\pipe\crashpad_7716_PTUNGMFLACATCGFG
COLORTERM                           truecolor
CommonProgramFiles                  C:\Program Files\Common Files
CommonProgramFiles(x86)             C:\Program Files (x86)\Common Files
CommonProgramW6432                  C:\Program Files\Common Files
COMPUTERNAME                        SF150PYCLIENT22
ComSpec                             C:\WINDOWS\system32\cmd.exe
deployment.expiration.check.enabled false
DriverData                          C:\Windows\System32\Drivers\DriverData
FSAL_JAVA_HOME                      C:\Program Files\Java\jre1.8.0_111
GIT_ASKPASS                         c:\Program Files\Microsoft VS Code\resources\app\extensions\git\dist\askpass.sh
HOMEDRIVE                           C:
HOMEPATH                            \Users\dm4
LANG                                en_US.UTF-8
LOCALAPPDATA                        C:\Users\dm4\AppData\Local
LOGONSERVER                         \\CPUC-ENERGYDC01
NUMBER_OF_PROCESSORS                16
OneDrive                            C:\Users\dm4\OneDrive
ORIGINAL_XDG_CURRENT_DESKTOP        undefined
OS                                  Windows_NT
Path                                C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files (x86)\Webex\Plugins;C:\Program Files (x86)\PuTTY... 
PATHEXT                             .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.CPL
PROCESSOR_ARCHITECTURE              AMD64
PROCESSOR_IDENTIFIER                Intel64 Family 6 Model 85 Stepping 7, GenuineIntel
PROCESSOR_LEVEL                     6
PROCESSOR_REVISION                  5507
ProgramData                         C:\ProgramData
ProgramFiles                        C:\Program Files
ProgramFiles(x86)                   C:\Program Files (x86)
ProgramW6432                        C:\Program Files
PSModulePath                        C:\Users\dm4\Documents\WindowsPowerShell\Modules;C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules
PUBLIC                              C:\Users\Public
SystemDrive                         C:
SystemRoot                          C:\WINDOWS
TEMP                                C:\Users\dm4\AppData\Local\Temp
TERM_PROGRAM                        vscode
TERM_PROGRAM_VERSION                1.96.4
TMP                                 C:\Users\dm4\AppData\Local\Temp
UATDATA                             C:\WINDOWS\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77
USERDNSDOMAIN                       ENERGY.DMZ.LOCAL
USERDOMAIN                          ENERGY
USERDOMAIN_ROAMINGPROFILE           ENERGY
USERNAME                            dm4
USERPROFILE                         C:\Users\dm4
VSCODE_GIT_ASKPASS_EXTRA_ARGS
VSCODE_GIT_ASKPASS_MAIN             c:\Program Files\Microsoft VS Code\resources\app\extensions\git\dist\askpass-main.js
VSCODE_GIT_ASKPASS_NODE             C:\Program Files\Microsoft VS Code\Code.exe
VSCODE_GIT_IPC_HANDLE               \\.\pipe\vscode-git-9aff74bfeb-sock
VSCODE_INJECTION                    1
VSCODE_NONCE                        e65e95ab-87c5-427e-ba75-ea30aeef8351
VSCODE_STABLE                       1
windir                              C:\WINDOWS

[DonJayamanne]

Do you launch Jupyter from vscode terminal or other (ie native terminal outside vscode)

[dmiller2u]

I run “Jupyter notebook” from windows anaconda prompt or from within VSC. The latter approach is what is crashing the kernel. On Feb 1, 2025, at 1:14 AM, Don Jayamanne ***@***.***> wrote: Do you launch Jupyter from vscode terminal or other (ie native terminal outside vscode) —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: ***@***.***>

[DonJayamanne]

Can you share the env variables from anaconda prompt

[dmiller2u]

Here you go:

env_wnorm.txt

[DonJayamanne]

Please share the environment variables, not the environment yaml file.

[dmiller2u]

Apologies but could you be more specific? I already sent you all the environment variables, above, so if that's not it, then I'm afraid I'm a tad confused...

[DonJayamanne]

And here are VSC environment variables (running same powershell command in VSC terminal):
run “Jupyter notebook” from windows anaconda prompt

I would like you run get the env variables from the anaconda prompt, as thats where you lunch Jupyter from.

[dmiller2u]

Is there any way you could tell me exactly what commands you want me to run and from where? From anaconda prompt or terminal in vsc? Apologies I am incredibly confused about how to get you the info you need. Thanks so much. On Feb 4, 2025, at 5:41 PM, Don Jayamanne ***@***.***> wrote: And here are VSC environment variables (running same powershell command in VSC terminal): run “Jupyter notebook” from windows anaconda prompt I would like you run get the env variables from the anaconda prompt, as thats where you lunch Jupyter from. —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: ***@***.***>

[DonJayamanne]

• Open VS Code.
• Open a notebook & select the environment that does not work in VS Code
• Run the following code in the notebook and share the output

import os
os.environ

• Next open anaconda prompt from outside VS Code (do not use vscode)
• Launch Jupyter
• Open a notebook
• Verify you use the right environment where sqlalchemy works.
• Run the following code in the notebook and share the output

import os
os.environ

[dmiller2u]

run:

import os
os.environ

from VSC notebook w/offending environment:

environ{'ALLUSERSPROFILE': 'C:\\ProgramData',
        'APPDATA': 'C:\\Users\\dm4\\AppData\\Roaming',
        'CHROME_CRASHPAD_PIPE_NAME': '\\\\.\\pipe\\crashpad_7716_PTUNGMFLACATCGFG',
        'COMMONPROGRAMFILES': 'C:\\Program Files\\Common Files',
        'COMMONPROGRAMFILES(X86)': 'C:\\Program Files (x86)\\Common Files',
        'COMMONPROGRAMW6432': 'C:\\Program Files\\Common Files',
        'COMPUTERNAME': 'SF150PYCLIENT22',
        'COMSPEC': 'C:\\WINDOWS\\system32\\cmd.exe',
        'CONDA_PREFIX': 'E:\\Python\\WeatherNormalization\\envs\\env_wnorm',
        'DEPLOYMENT.EXPIRATION.CHECK.ENABLED': 'false',
        'DRIVERDATA': 'C:\\Windows\\System32\\Drivers\\DriverData',
        'ELECTRON_RUN_AS_NODE': '1',
        'FSAL_JAVA_HOME': 'C:\\Program Files\\Java\\jre1.8.0_111',
        'HOMEDRIVE': 'C:',
        'HOMEPATH': '\\Users\\dm4',
        'JPY_INTERRUPT_EVENT': '1644',
        'LOCALAPPDATA': 'C:\\Users\\dm4\\AppData\\Local',
        'LOGONSERVER': '\\\\CPUC-ENERGYDC01',
        'NUMBER_OF_PROCESSORS': '16',
        'ONEDRIVE': 'C:\\Users\\dm4\\OneDrive',
        'ORIGINAL_XDG_CURRENT_DESKTOP': 'undefined',
        'OS': 'Windows_NT',
        'PATH': 'e:\\Python\\WeatherNormalization\\envs\\env_wnorm;C:\\ProgramData\\Oracle\\Java\\javapath;C:\\WINDOWS\\system32;C:\\WINDOWS;C:\\WINDOWS\\System32\\Wbem;C:\\WINDOWS\\System32\\WindowsPowerShell\\v1.0\\;C:\\WINDOWS\\System32\\OpenSSH\\;C:\\Program Files (x86)\\Webex\\Plugins;C:\\Program Files (x86)\\PuTTY\\;C:\\Amazon\\AWSCLIV2\\;C:\\Program Files\\nodejs\\;C:\\Program Files\\Git\\cmd;C:\\Program Files\\Pandoc\\;C:\\Program Files\\Microsoft VS Code\\bin;C:\\Users\\dm4\\AppData\\Local\\Microsoft\\WindowsApps;C:\\Program Files (x86)\\GnuWin32\\bin;C:\\Program Files (x86)\\wget;C:\\Program Files\\Microsoft Office\\root\\Office16;C:\\Users\\dm4\\AppData\\Roaming\\npm;C:\\ProgramData\\Oracle\\Java\\javapath;C:\\WINDOWS\\system32;C:\\WINDOWS;C:\\WINDOWS\\System32\\Wbem;C:\\WINDOWS\\System32\\WindowsPowerShell\\v1.0\\;C:\\WINDOWS\\System32\\OpenSSH\\;C:\\Program Files (x86)\\Webex\\Plugins;C:\\Program Files (x86)\\PuTTY\\;C:\\Amazon\\AWSCLIV2\\;C:\\Program Files\\nodejs\\;C:\\Program Files\\Git\\cmd;C:\\Program Files\\Pandoc\\;C:\\Program Files\\Microsoft VS Code\\bin;C:\\Users\\dm4\\AppData\\Local\\Microsoft\\WindowsApps;C:\\Program Files (x86)\\GnuWin32\\bin;C:\\Program Files (x86)\\wget;C:\\Program Files\\Microsoft Office\\root\\Office16;C:\\Users\\dm4\\AppData\\Roaming\\npm',
        'PATHEXT': '.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC',
        'PROCESSOR_ARCHITECTURE': 'AMD64',
        'PROCESSOR_IDENTIFIER': 'Intel64 Family 6 Model 85 Stepping 7, GenuineIntel',
        'PROCESSOR_LEVEL': '6',
        'PROCESSOR_REVISION': '5507',
        'PROGRAMDATA': 'C:\\ProgramData',
        'PROGRAMFILES': 'C:\\Program Files',
        'PROGRAMFILES(X86)': 'C:\\Program Files (x86)',
        'PROGRAMW6432': 'C:\\Program Files',
        'PSMODULEPATH': 'C:\\Program Files\\WindowsPowerShell\\Modules;C:\\WINDOWS\\system32\\WindowsPowerShell\\v1.0\\Modules',
        'PUBLIC': 'C:\\Users\\Public',
        'PYDEVD_IPYTHON_COMPATIBLE_DEBUGGING': '1',
        'PYTHONIOENCODING': 'utf-8',
        'PYTHONUNBUFFERED': '1',
        'PYTHON_FROZEN_MODULES': 'on',
        'SYSTEMDRIVE': 'C:',
        'SYSTEMROOT': 'C:\\WINDOWS',
        'TEMP': 'C:\\Users\\dm4\\AppData\\Local\\Temp',
        'TMP': 'C:\\Users\\dm4\\AppData\\Local\\Temp',
        'UATDATA': 'C:\\WINDOWS\\CCM\\UATData\\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77',
        'USERDNSDOMAIN': 'ENERGY.DMZ.LOCAL',
        'USERDOMAIN': 'ENERGY',
        'USERDOMAIN_ROAMINGPROFILE': 'ENERGY',
        'USERNAME': 'dm4',
        'USERPROFILE': 'C:\\Users\\dm4',
        'VSCODE_CODE_CACHE_PATH': 'C:\\Users\\dm4\\AppData\\Roaming\\Code\\CachedData\\cd4ee3b1c348a13bafd8f9ad8060705f6d4b9cba',
        'VSCODE_CRASH_REPORTER_PROCESS_TYPE': 'extensionHost',
        'VSCODE_CWD': 'C:\\Program Files\\Microsoft VS Code',
        'VSCODE_ESM_ENTRYPOINT': 'vs/workbench/api/node/extensionHostProcess',
        'VSCODE_HANDLES_UNCAUGHT_ERRORS': 'true',
        'VSCODE_IPC_HOOK': '\\\\.\\pipe\\e4294797-1.96.4-main-sock',
        'VSCODE_L10N_BUNDLE_LOCATION': '',
        'VSCODE_NLS_CONFIG': '{"userLocale":"en-us","osLocale":"en-us","resolvedLanguage":"en","defaultMessagesFile":"C:\\\\Program Files\\\\Microsoft VS Code\\\\resources\\\\app\\\\out\\\\nls.messages.json","locale":"en-us","availableLanguages":{}}',
        'VSCODE_PID': '7716',
        'WINDIR': 'C:\\WINDOWS',
        '__COMPAT_LAYER': 'Installer',
        'TERM': 'xterm-color',
        'CLICOLOR': '1',
        'PAGER': 'cat',
        'GIT_PAGER': 'cat',
        'MPLBACKEND': 'module://ipykernel.pylab.backend_inline'}

from anaconda prompt jupyter notebook (where same environment works):

environ{'ALLUSERSPROFILE': 'C:\\ProgramData',
        'APPDATA': 'C:\\Users\\dm4\\AppData\\Roaming',
        'COMMONPROGRAMFILES': 'C:\\Program Files\\Common Files',
        'COMMONPROGRAMFILES(X86)': 'C:\\Program Files (x86)\\Common Files',
        'COMMONPROGRAMW6432': 'C:\\Program Files\\Common Files',
        'COMPUTERNAME': 'SF150PYCLIENT22',
        'COMSPEC': 'C:\\WINDOWS\\system32\\cmd.exe',
        'CONDA_DEFAULT_ENV': 'env_wnorm',
        'CONDA_EXE': 'C:\\Miniconda3\\Scripts\\conda.exe',
        'CONDA_PREFIX': 'E:\\Python\\WeatherNormalization\\envs\\env_wnorm',
        'CONDA_PREFIX_1': 'C:\\Miniconda3',
        'CONDA_PROMPT_MODIFIER': '(env_wnorm) ',
        'CONDA_PYTHON_EXE': 'C:\\Miniconda3\\python.exe',
        'CONDA_SHLVL': '2',
        'DEPLOYMENT.EXPIRATION.CHECK.ENABLED': 'false',
        'DRIVERDATA': 'C:\\Windows\\System32\\Drivers\\DriverData',
        'FSAL_JAVA_HOME': 'C:\\Program Files\\Java\\jre1.8.0_111',
        'HOMEDRIVE': 'C:',
        'HOMEPATH': '\\Users\\dm4',
        'LOCALAPPDATA': 'C:\\Users\\dm4\\AppData\\Local',
        'LOGONSERVER': '\\\\CPUC-ENERGYDC01',
        'NUMBER_OF_PROCESSORS': '16',
        'ONEDRIVE': 'C:\\Users\\dm4\\OneDrive',
        'OS': 'Windows_NT',
        'PATH': 'E:\\Python\\WeatherNormalization\\envs\\env_wnorm;E:\\Python\\WeatherNormalization\\envs\\env_wnorm\\Library\\mingw-w64\\bin;E:\\Python\\WeatherNormalization\\envs\\env_wnorm\\Library\\usr\\bin;E:\\Python\\WeatherNormalization\\envs\\env_wnorm\\Library\\bin;E:\\Python\\WeatherNormalization\\envs\\env_wnorm\\Scripts;E:\\Python\\WeatherNormalization\\envs\\env_wnorm\\bin;C:\\Miniconda3\\condabin;C:\\ProgramData\\Oracle\\Java\\javapath;C:\\WINDOWS\\system32;C:\\WINDOWS;C:\\WINDOWS\\System32\\Wbem;C:\\WINDOWS\\System32\\WindowsPowerShell\\v1.0;C:\\WINDOWS\\System32\\OpenSSH;C:\\Program Files (x86)\\Webex\\Plugins;C:\\Program Files (x86)\\PuTTY;C:\\Amazon\\AWSCLIV2;C:\\Program Files\\nodejs;C:\\Program Files\\Git\\cmd;C:\\Program Files\\Pandoc;C:\\Program Files\\Microsoft VS Code\\bin;C:\\Users\\dm4\\AppData\\Local\\Microsoft\\WindowsApps;C:\\Program Files (x86)\\GnuWin32\\bin;C:\\Program Files (x86)\\wget;C:\\Program Files\\Microsoft Office\\root\\Office16;C:\\Users\\dm4\\AppData\\Roaming\\npm',
        'PATHEXT': '.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.CPL',
        'PROCESSOR_ARCHITECTURE': 'AMD64',
        'PROCESSOR_IDENTIFIER': 'Intel64 Family 6 Model 85 Stepping 7, GenuineIntel',
        'PROCESSOR_LEVEL': '6',
        'PROCESSOR_REVISION': '5507',
        'PROGRAMDATA': 'C:\\ProgramData',
        'PROGRAMFILES': 'C:\\Program Files',
        'PROGRAMFILES(X86)': 'C:\\Program Files (x86)',
        'PROGRAMW6432': 'C:\\Program Files',
        'PROJ_DATA': 'E:\\Python\\WeatherNormalization\\envs\\env_wnorm\\Library\\share\\proj',
        'PROJ_NETWORK': 'ON',
        'PROMPT': '(env_wnorm) $P$G',
        'PSEXECUTIONPOLICYPREFERENCE': 'Bypass',
        'PSMODULEPATH': 'C:\\Users\\dm4\\Documents\\WindowsPowerShell\\Modules;C:\\Program Files\\WindowsPowerShell\\Modules;C:\\WINDOWS\\system32\\WindowsPowerShell\\v1.0\\Modules',
        'PUBLIC': 'C:\\Users\\Public',
        'SSL_CERT_DIR': 'E:\\Python\\WeatherNormalization\\envs\\env_wnorm\\Library\\ssl\\certs',
        'SSL_CERT_FILE': 'E:\\Python\\WeatherNormalization\\envs\\env_wnorm\\Library\\ssl\\cacert.pem',
        'SYSTEMDRIVE': 'C:',
        'SYSTEMROOT': 'C:\\WINDOWS',
        'TEMP': 'C:\\Users\\dm4\\AppData\\Local\\Temp',
        'TMP': 'C:\\Users\\dm4\\AppData\\Local\\Temp',
        'UATDATA': 'C:\\WINDOWS\\CCM\\UATData\\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77',
        'USERDNSDOMAIN': 'ENERGY.DMZ.LOCAL',
        'USERDOMAIN': 'ENERGY',
        'USERDOMAIN_ROAMINGPROFILE': 'ENERGY',
        'USERNAME': 'dm4',
        'USERPROFILE': 'C:\\Users\\dm4',
        'WINDIR': 'C:\\WINDOWS',
        'XML_CATALOG_FILES': 'file:///E:/Python/WeatherNormalization/envs/env_wnorm/etc/xml/catalog',
        '_CONDA_EXE': 'C:/Miniconda3\\Scripts\\conda.exe',
        '_CONDA_ROOT': 'C:/Miniconda3',
        'PYDEVD_USE_FRAME_EVAL': 'NO',
        'JPY_INTERRUPT_EVENT': '3032',
        'IPY_INTERRUPT_EVENT': '3032',
        'JPY_PARENT_PID': '2668',
        '__CONDA_OPENSSL_CERT_DIR_SET': '"1"',
        '__CONDA_OPENSSL_CERT_FILE_SET': '"1"',
        'TERM': 'xterm-color',
        'CLICOLOR': '1',
        'PAGER': 'cat',
        'GIT_PAGER': 'cat',
        'MPLBACKEND': 'module://ipykernel.pylab.backend_inline'}