superhawk610 commented on PR #1199: URL: https://github.com/apache/arrow-adbc/pull/1199#issuecomment-1765249137
@davidhcoe updated the test to connect to Snowflake! I had to open a trial Snowflake account to verify this locally and it took a bit to figure out the expected configuration, so I figured I'd document it here: 1. Open a Snowflake account, note the username/password/account. 2. From the Snowflake console, execute the following statements: ```sql create database adbc_testing; grant all on database adbc_testing to public; grant all on schema adbc_testing.public to public; grant all on warehouse compute_wh to public; ``` 3. Set the following environment variables (replacing `$SNOW_*` accordingly) to test locally: ```env export SNOWFLAKE_URI="$SNOW_USER:$SNOW_PASS/$SNOW_ACCOUNT/adbc_testing?warehouse=compute_wh&role=public" export SNOWFLAKE_DATABASE="adbc_testing" ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
