vestapol

library0.0.28pypypiunverified

Python package for loading data from the web and deploying external table definitions in Snowflake or other SQL engines, enabling SQL-based querying. Current version 0.0.28, rapid active development.

database

pip install vestapol

github ↗homepage ↗

INSTALL

IMPORT

SIG · VESTAPOL

vestapol

databasepythonv0.0.28

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

ExternalTable

✓ from vestapol import ExternalTable

✗ from vestapol import ExternalTable

Creates an external table in Snowflake from a web URL. Make sure environment variables are set for authentication.

from vestapol import ExternalTable import os # Snowflake connection parameters (use env vars) conn_params = { "account": os.environ.get('SNOWFLAKE_ACCOUNT', ''), "user": os.environ.get('SNOWFLAKE_USER', ''), "password": os.environ.get('SNOWFLAKE_PASSWORD', ''), "warehouse": os.environ.get('SNOWFLAKE_WAREHOUSE', ''), "database": os.environ.get('SNOWFLAKE_DATABASE', ''), "schema": os.environ.get('SNOWFLAKE_SCHEMA', 'PUBLIC') } # Create external table from a URL et = ExternalTable( name="my_external_table", url="https://example.com/data.csv", file_format="CSV", connection_params=conn_params ) et.create() print("External table created. Query with: SELECT * FROM my_external_table;")

Debug

Known issues

breakingIn v0.0.25, the ExternalTable class was moved to top-level imports from vestapol.external_table. Direct imports from the submodule will raise ModuleNotFoundError.

fix

Update import to 'from vestapol import ExternalTable'.

affects: >=0.0.25

deprecatedThe function 'vestapol.quick_load' is deprecated as of v0.0.20 and will be removed in a future release.

fix

Replace with 'from vestapol import load_data' and use appropriate connection parameters.

affects: >=0.0.20 <0.1.0

gotchaThe 'url' parameter in ExternalTable must be a direct download link (e.g., raw CSV file). Many users mistakenly pass a webpage URL, causing parsing errors.

fix

Ensure the URL points directly to the data file, not an HTML page containing a download button.

affects: all

Upgrade

Version history

0.0.28latest on PyPI · released Dec 19, 2025

Audit

Dependencies

snowflake-connector-pythonrequiredRequired for Snowflake connectivity

boto3optionalRequired for S3 integration

Agent activity

21 hits · last 30 days

node