keboola / db-adapter-snowflake
1.02
2019-12-09 14:51 UTC
Requires
- php: ^7.1
- ext-odbc: *
Requires (Dev)
- jakub-onderka/php-parallel-lint: ^1.0
- keboola/coding-standard: >=7.0.2
- keboola/datadir-tests: ^2.0
- keboola/php-temp: ^1.0
- phpstan/phpstan-shim: ^0.10.6
- phpunit/phpunit: ^7.0
- symfony/process: ^4.0
This package is auto-updated.
Last update: 2021-01-06 10:52:04 UTC
README
Development
- Clone this repository and init the workspace with following command:
git clone https://github.com/keboola/db-adapter-snowflake
cd db-adapter-snowflake
docker-compose build
docker-compose run --rm dev composer install --no-scripts
- Create snowflake user (supply your own password and warehouse name):
CREATE DATABASE "TRAVIS_SNOWFLAKE_ADAPTER" DATA_RETENTION_TIME_IN_DAYS = 0;
CREATE ROLE "TRAVIS_SNOWFLAKE_ADAPTER";
GRANT OWNERSHIP ON DATABASE "TRAVIS_SNOWFLAKE_ADAPTER" TO ROLE "TRAVIS_SNOWFLAKE_ADAPTER";
CREATE USER "TRAVIS_SNOWFLAKE_ADAPTER"
PASSWORD = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'
DEFAULT_ROLE = "TRAVIS_SNOWFLAKE_ADAPTER";
GRANT ROLE "TRAVIS_SNOWFLAKE_ADAPTER" TO USER "TRAVIS_SNOWFLAKE_ADAPTER";
GRANT ROLE "TRAVIS_SNOWFLAKE_ADAPTER" TO ROLE "ACCOUNTADMIN";
GRANT USAGE ON WAREHOUSE "DEV" TO ROLE "TRAVIS_SNOWFLAKE_ADAPTER";
GRANT USAGE ON DATABASE "TRAVIS_SNOWFLAKE_ADAPTER" TO ROLE "TRAVIS_SNOWFLAKE_ADAPTER";
CREATE SCHEMA "TRAVIS_SNOWFLAKE_ADAPTER"."TRAVIS_SNOWFLAKE_ADAPTER";
GRANT ALL ON SCHEMA "TRAVIS_SNOWFLAKE_ADAPTER"."TRAVIS_SNOWFLAKE_ADAPTER" TO ROLE "TRAVIS_SNOWFLAKE_ADAPTER";
- Fill credentials for created user in
.env
(required variables are in.env.dist
). - Run the test suite using this command:
docker-compose run --rm dev composer tests