Skip to content

Latest commit

 

History

History
36 lines (23 loc) · 1.38 KB

README.md

File metadata and controls

36 lines (23 loc) · 1.38 KB
Raw

Snowflake Python

This example will focus on everything that relates with Snowflake in order to create a backend in Python for the OpenBB Terminal Pro. For more information, read our main README.md.

1. Get started with Snowflake

Check website: https://www.snowflake.com/en/.

Create an account at https://app.snowflake.com/.

2. Snowflake and Python

Read the official Snowflake connector for python.

TL;DR: Install Snowflake with pip install snowflake-connector-python

3. Extract Snowflake information

You will need to identify the following from your snowflake account

conn = snowflake.connector.connect(
    user="",
    password="",
    account="",
    warehouse="COMPUTE_WH",
    database="Cybersyn_Weather__Environmental_Essentials",
    schema="CYBERSIN",
)

Account can be found in Accounts under the Admin section. It will look like: https://xxxxxx-xxxxxx.snowflakecomputing.com

The other information is found under the relevant Database you want to query.

In our example, the data used is from the Cybersyn_Weather__Environmental_Essentials database. You can read more information about it here.