Snowflake

Snowflake Configuration

  • Log into your Sysadmin or Accountadmin account on Snowflake

  • Go on Worksheets, create a new worksheet and copy this in it:

      use role accountadmin;
      alter account set sso_login_page = TRUE;
      alter account set saml_identity_provider =
      '{
          "certificate": "MIIDUTCCAjmgAwIBAgIRALwbppJ9yOSi2xNQSqWc2rgwDQYJKoZIhvcNAQELBQAwUzELMAkGA1UEBhMCRlIxGDAWBgNVBAoTD3dhbGxpeC1qZmxhY2hlcjEWMBQGA1UECxMNVHJ1c3RlbGVtIElkUDESMBAGA1UEAxMJVHJ1c3RlbGVtMB4XDTIwMDkyMTEyNDY0OVoXDTI1MDkyMDEyNDY0OVowUzELMAkGA1UEBhMCRlIxGDAWBgNVBAoTD3dhbGxpeC1qZmxhY2hlcjEWMBQGA1UECxMNVHJ1c3RlbGVtIElkUDESMBAGA1UEAxMJVHJ1c3RlbGVtMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA03DSSaM/B0G70aclJFw+QK6HRl9hkFg2W5HKCGuAHm5wt2tP4FcQ8RMtLZ/WsdeFlUe9VdUGfACCSExq32k4XDR0PA5FJ9sE2pfGXIyyUP2drhqDI1Q754faHPjvkX5niiQkaNFby4HBjvsH6VWVU5PfHoHEeT20qemANWNlrfw8+jkMlN1aioWAuWI9L+OtGqUHEbZy/zj3GrZrAN7G73rClAtcgsIfeqkg3y5g2p4qRynS/MMmpuYiGz89Hcrr3lS52tKjHATskkII+eA+/78SB413KVKxRYSK9DjlA+Wm5Ott4AN99d6sVUIj0jp+fWSIueE4zy4OKrrQR91IYQIDAQABoyAwHjAOBgNVHQ8BAf8EBAMCBPAwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQsFAAOCAQEAaZQzh7/Pv4fl7q8aDAvbsA8ae+ZOtAIOnDq3+Rt4w+ijH//aVDLGefnpVhv1up0qBeFdFUnpVIoxLeyGBThV36sUULsLcEbxaTbIEimepefijIyHhfPuRsKoDYr68f5xoKsnSSYjJaP8vWWI9zBN+C1JPotqlA3DmgI7TeyFbiXtzKK25779NMewgKwgtC+sv+7ZAZXT/SXoW1ve1eQwqBwLDn11YvJMhnqtGTomBZQthba9XRg/r4MuAkIkhJE7/+OPXyLIXAGwyBpeeUTRiTtiRCUXjDIdlEu6GiZ/P98fPZkHVD/vSsTWUepPnIlU+qFDxdO7/XAXtKDigpNTYw==",
          "issuer": "https://mycompany.trustelem.com/app/33XXXX",
          "ssoUrl": "https://mycompany.trustelem.com/app/33XXXX/sso",
          "type"  : "custom",
          "label" : "Trustelem" 
      }';
    
  • Then click on Run

Trustelem Configuration

  • Copy your Snowflake account URL: it should look like this https://[account_name].snowflakecomputing.com/ or this https://[account_name].[region_id].snowflakecomputing.com/

  • On Trustelem, paste this URL in the EntityID, do not forget the “/” at the end