keboola/db-adapter-snowflake

Maintainers

Details

github.com/keboola/db-adapter-snowflake

Source

Issues

Installs: 478

Dependents: 1

Suggesters: 0

Security: 0

Stars: 0

Watchers: 6

Forks: 0

Open Issues: 2

1.02 2019-12-09 14:51 UTC

Requires

  • php: ^7.1
  • ext-odbc: *

Requires (Dev)

MIT 553f3c5bc3496c5fa12016057219616ff2ffa24b

This package is auto-updated.

Last update: 2020-10-06 10:20:45 UTC

README

Build Status

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