keboola/db-adapter-snowflake

维护者

详细信息

github.com/keboola/db-adapter-snowflake

源代码

安装次数: 7,482

依赖者: 0

建议者: 0

安全性: 0

星标: 0

关注者: 17

分支: 0

1.4.0 2023-06-02 07:06 UTC

Requires

  • php: ^8.0
  • ext-odbc: *

Requires (Dev)

MIT 8d1548cc3724dc588b3fd38bb970072da6041158

This package is auto-updated.

Last update: 2024-09-10 09:32:05 UTC

README

开发

  • 使用以下命令克隆此仓库并初始化工作区
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
  • 创建snowflake用户（提供您自己的密码和仓库名称）
CREATE DATABASE "GHA_SNOWFLAKE_ADAPTER" DATA_RETENTION_TIME_IN_DAYS = 0;
CREATE ROLE "GHA_SNOWFLAKE_ADAPTER";
GRANT OWNERSHIP ON DATABASE "GHA_SNOWFLAKE_ADAPTER" TO ROLE "GHA_SNOWFLAKE_ADAPTER";
CREATE USER "GHA_SNOWFLAKE_ADAPTER"
    PASSWORD = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'
    DEFAULT_ROLE = "GHA_SNOWFLAKE_ADAPTER";
GRANT ROLE "GHA_SNOWFLAKE_ADAPTER" TO USER "GHA_SNOWFLAKE_ADAPTER";
GRANT ROLE "GHA_SNOWFLAKE_ADAPTER" TO ROLE "ACCOUNTADMIN";
GRANT USAGE ON WAREHOUSE "DEV" TO ROLE "GHA_SNOWFLAKE_ADAPTER";
GRANT USAGE ON DATABASE "GHA_SNOWFLAKE_ADAPTER" TO ROLE "GHA_SNOWFLAKE_ADAPTER";
CREATE SCHEMA "GHA_SNOWFLAKE_ADAPTER"."GHA_SNOWFLAKE_ADAPTER";
GRANT ALL ON SCHEMA "GHA_SNOWFLAKE_ADAPTER"."GHA_SNOWFLAKE_ADAPTER" TO ROLE "GHA_SNOWFLAKE_ADAPTER";
  • 在.env中填写已创建用户的凭据（所需变量在.env.dist中）。
  • 使用此命令运行测试套件
docker-compose run --rm dev composer tests

许可证

MIT许可，请参阅LICENSE文件。