Key | Description | Sample Value |
---|---|---|
account | Your Snowflake account identifier. | abc1234.us-east-1 |
database | The name of the database you want to query data from. | DEMO_DB |
schema | Schema containing the tables you want to extract data from. | PUBLIC |
username | Username for accessing the database (must have read/write permissions). | guest |
warehouse | Name of the warehouse for executing queries. | COMPUTE_WH |
Key | Description | Sample Value |
---|---|---|
password | Password for the database user. | abc123... |
private_key_file | Path to the Snowflake private key file (supported in version >= 0.9.76). | /path/to/snowflake_key |
private_key_file_pwd | Passphrase for the private key file (supported in version >= 0.9.76). | abc123... |
role | Role of the user to access the database. | ROLE |
For setting up key-pair authentication, follow this guide.
Key | Description | Sample Value |
---|---|---|
batch_fetch_limit | Number of rows to fetch per batch (default: 50,000). Increase for high-memory systems. | 50000 |