Comment on page
Snowflake
Going over how to find your Snowflake settings and outline the typing support.
Create a service account for Transfer to use
Retrieving Account URL
Part of Snowflake's pricing model is virtual warehouse usage and price scales based on the size of the virtual warehouse.
Consider creating a new virtual data warehouse for Transfer so that you can size it independently of your other DWH workloads. Keep in mind that data warehouse size will determine performance and throughput!
For the most optimal usage, consider leveraging warehouse suspension policies and size your warehouse appropriately depending on your workloads. Click here to learn more from Snowflake's website.
Snowflake type | Artie type |
|---|---|
Number / Double / Double Precision / Real | Float |
Numeric / Decimal | Numeric |
Int / Integer / Big Int / Small Int / Tiny Int Byte Int | Integer |
Float / Float4 / Float8 | Float |
Varchar | String |
Char, Character | String |
String | String |
Text | String |
Binary / Var Binary | 🟠 Currently not supported. |
Boolean | Boolean |
Date | Date |
Datetime | Datetime |
Timestamp | Datetime |
Timestamp LTZ | Datetime |
Timestamp NTZ | Datetime with UTC TZ |
Timestamp TZ | Datetime |
Variant | Struct |
Object | Struct |
Array | Array |
Geography | 🟠 Currently not supported. |
Geometry | 🟠 Currently not supported. |
Paste and modify the variables to create an account for Artie.
BEGIN TRANSACTION;
USE ROLE ACCOUNTADMIN; -- This combines both SYSADMIN and SECURITYADMIN
-- IMPORTANT, PLEASE FILL THIS OUT AND SAVE THIS --
SET ROLE_NAME = 'ARTIE_TRANSFER_ROLE';
SET SERVICE_USER = 'ARTIE';
SET SERVICE_PW = 'PASSWORD';
-- NOTE: If you already have a DWH, you can use that, or create a separate one for Artie
-- If your default DWH is a larger size, you may consider creating a dedicated one for Artie that's a smaller size
-- To optimize your spend. See https://docs.artie.so/configurations/real-time-destinations/snowflake#which-data-warehouse-to-use for more details.
SET DWH_NAME = UPPER('DWH');
SET DB_NAME = UPPER('DB_NAME');
SET SCHEMA_NAME = UPPER('public');
-- END IMPORTANT --
SET DB_SCHEMA_NAME = CONCAT($DB_NAME, '.', $SCHEMA_NAME);
CREATE ROLE IF NOT EXISTS identifier($ROLE_NAME);
CREATE USER IF NOT EXISTS identifier($SERVICE_USER)
password = $SERVICE_PW
default_role = $ROLE_NAME;
GRANT ROLE identifier($role_name) to USER identifier($SERVICE_USER);
CREATE WAREHOUSE IF NOT EXISTS identifier($DWH_NAME)
warehouse_size = xsmall
warehouse_type = standard
auto_suspend = 10
auto_resume = true
initially_suspended = true;
GRANT USAGE ON WAREHOUSE identifier($DWH_NAME) TO ROLE identifier($ROLE_NAME);
GRANT USAGE ON DATABASE identifier($DB_NAME) TO ROLE identifier($ROLE_NAME);
GRANT ALL PRIVILEGES ON SCHEMA identifier($DB_SCHEMA_NAME) TO ROLE IDENTIFIER($ROLE_NAME);
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA identifier($DB_SCHEMA_NAME) TO ROLE IDENTIFIER($ROLE_NAME);
GRANT ALL PRIVILEGES ON FUTURE TABLES IN SCHEMA identifier($DB_SCHEMA_NAME) TO ROLE IDENTIFIER($ROLE_NAME);
COMMIT;
Snowflake's native RBAC makes it so that the account that created the resource is the native owner. To change this, assign the ARTIE service account's role to your account and you will be able to operate on the table. See the GIF below on how to fix this problem! [source]
Last modified 2mo ago