PyGWalkre & Snowflake API
Install pygwalker and pygwalker snowflake plugin。
pip install --upgrade --pre pygwalker pip install --upgrade --pre "pygwalker[snowflake]"
Create a connector to snowflake and pass it to
import pygwalker as pyg from pygwalker.data_parsers.database_parser import Connector conn = Connector( "snowflake://user_name:password@account_identifier/database/schema", """ SELECT * FROM SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.ORDERS """ ) walker = pyg.walk(conn)
The first argument to the
Connector is the connection string format in sqlalchemy. According to snowflake's documentation (opens in a new tab), the connection string format is as follows:
- Account name:
- Account locator:
Using pygwalker + snowflake.
Yes, pygwalker (opens in a new tab) is a visual interface for explore data that can easier connect to snowflake. You can start to explore with a few lines of code.
pygwalker (opens in a new tab) supports to connect external data service, like snowflake and bigquery.