SQL Conduit - Connect to Snowflake

Learn how to connect to Snowflake using SQL Conduit. Here are the set of scripts shown in the demo video. /********************************* 1. Private key (PKCS#8, unencrypted) openssl genpkey -algorithm RSA -pkeyopt rsa_keygen_bits:2048 -out sql_conduit_user_rsa_key.p8 2. Public key openssl rsa -in sql_conduit_user_rsa_key.p8 -pubout -out sql_conduit_user_rsa_key.pub **********************************/ USE ROLE USERADMIN; CREATE ROLE IF NOT EXISTS SQL_CONDUIT_ROLE COMMENT = 'Functional role for SQL Conduit orchestration against PROSPERBI'; CREATE USER IF NOT EXISTS SQL_CONDUIT_USER TYPE = SERVICE DEFAULT_ROLE = SQL_CONDUIT_ROLE DEFAULT_WAREHOUSE = SQL_CONDUIT_WH DEFAULT_NAMESPACE = PROSPERBI.PUBLIC RSA_PUBLIC_KEY = 'Paste flattened public key text here' COMMENT = 'Service account for SQL Conduit'; USE ROLE SECURITYADMIN; GRANT ROLE SQL_CONDUIT_ROLE TO USER SQL_CONDUIT_USER; -- Keeps the role reachable from the SYSADMIN branch so you don't orphan the objects GRANT ROLE SQL_CONDUIT_ROLE TO ROLE SYSADMIN; GRANT USAGE, OPERATE ON WAREHOUSE SQL_CONDUIT_WH TO ROLE SQL_CONDUIT_ROLE; GRANT ALL PRIVILEGES ON DATABASE PROSPERBI TO ROLE SQL_CONDUIT_ROLE; GRANT ALL PRIVILEGES ON ALL SCHEMAS IN DATABASE PROSPERBI TO ROLE SQL_CONDUIT_ROLE; GRANT ALL PRIVILEGES ON FUTURE SCHEMAS IN DATABASE PROSPERBI TO ROLE SQL_CONDUIT_ROLE; GRANT ALL PRIVILEGES ON FUTURE SCHEMAS IN DATABASE PROSPERBI TO ROLE SQL_CONDUIT_ROLE; GRANT ALL PRIVILEGES ON FUTURE TABLES IN DATABASE PROSPERBI TO ROLE SQL_CONDUIT_ROLE; GRANT ALL PRIVILEGES ON FUTURE VIEWS IN DATABASE PROSPERBI TO ROLE SQL_CONDUIT_ROLE; GRANT ALL PRIVILEGES ON FUTURE STAGES IN DATABASE PROSPERBI TO ROLE SQL_CONDUIT_ROLE; GRANT ALL PRIVILEGES ON FUTURE FILE FORMATS IN DATABASE PROSPERBI TO ROLE SQL_CONDUIT_ROLE; GRANT ALL PRIVILEGES ON FUTURE SEQUENCES IN DATABASE PROSPERBI TO ROLE SQL_CONDUIT_ROLE; GRANT ALL PRIVILEGES ON FUTURE FUNCTIONS IN DATABASE PROSPERBI TO ROLE SQL_CONDUIT_ROLE; GRANT ALL PRIVILEGES ON FUTURE PROCEDURES IN DATABASE PROSPERBI TO ROLE SQL_CONDUIT_ROLE; --Get Account Identifier SELECT CURRENT_ORGANIZATION_NAME() || '-' || CURRENT_ACCOUNT_NAME();