ACCOUNTADMIN
system-defined role or custom role with privileges to:
CREATE WAREHOUSE, DATABASE, SCHEMA
CREATE ROLE, USER
CREATE NETWORK POLICY
CREATE OR REPLACE
in our scripts. This is to avoid destroying something by mistake that already exists in your Snowflake account..p8
) and the other public (usually has the extension .pub
). Store both files in a secure place.
Once generated, the public key needs to be assigned to the Snowflake database user created for Streamkap earlier.
This command will copy the public key you generated to your clipboard.
https://
) and port number are optional.
append
and upsert
modes use different, incompatible methods for loading data into the Snowflake tables. If - for whatever reason - you want to change modes for an existing Snowflake Connector, please create a new Snowflake Destination instead i.e. a separate destination for append
, and for upsert
.append
mode:
TABLE_DATA
dictionary to set table specific data.{{dynamicTableName}}
in dynamic table creation SQL. It can use input JSON data for more complex mappings and logic.upsert
mode:
{schema}, {table}, {primary_key_column}
accordingly.
MERGE INTO
statements to upsert data into target snowflake tables. Dynamic tables or other de-duplication mechanisms will not be necessary when using upsert mode.
ORGADMIN
system-defined role to run this script.
ACCOUNTADMIN
system-defined role or custom role with equivalent privileges to run these scripts.
Copy paste the scripts below into Snowflake worksheets. Change the object names at the top as required and run all queries.
ACCOUNTADMIN
, or a custom role with equivalent privileges"Object does not exist or is not authorized"
error, go to the Snowsight UI Admin page and see if the object is showing there. For example, if DESC WAREHOUSE ...
failed, go to Admin -> Warehouses page and check if the Warehouse is shown on that page{ ... }
placeholders as required: