Mass Ingestion
- Mass Ingestion
- 所有产品
create user INFACMI_User password 'Xxxx@xxx';
create role INFACMI_superpipe; grant role INFACMI_superpipe to user INFACMI_User;
grant usage on warehousewarehouse_nameto role INFACMI_superpipe;
grant usage on database INFACMI_DB1 to role INFACMI_superpipe;
use database INFACMI_DB1; create schema sh_superpipe;
grant create stream, create view, create table, usage on schema INFACMI_DB1.sh_superpipe to role INFACMI_superpipe;
alter user INFACMI_User set default_role=INFACMI_superpipe;
openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -v1 PBE-SHA1-3DES -out rsa_key.p8
openssl rsa -in rsa_key.p8 -pubout -out rsa_key.pub
alter user INFACMI_User set rsa_public_key='key_value’;
create user INFACMI_User password 'Xxxx@xxx';
replace user INFACMI_User password 'Xxxx@xxx';
create role INFA_CMI_Role; grant role INFA_CMI_Role to user INFACMI_User;
grant usage on warehouse CMIWH to role INFA_CMI_Role;
grant usage, CREATE SCHEMA on database CMIDB to role INFA_CMI_Role;
alter user INFACMI_User set default_role=INFA_CMI_Role;
create schema CMISchema;
SQL compilation error: Object does not exist, or operation cannot be performed.
Create stage if not exists "Schema"."Stage_Bucket"”
GRANT CREATE STAGE ON SCHEMA "Schema" TO ROLE <your_role>;
またはopenssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -v1 PBE-SHA1-3DES -out rsa_key.p8
openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -v1 PBE-SHA1-2DES -out rsa_key.p8