Connection to Snowflake?

Marc-Paul Lee
Marc-Paul Lee Altair Community Member
edited May 8 in Community Q&A

I am trying to make a connection to Snowflake using the LIBNAME statement and authenticating through Okta.  Has anyone managed to do this?  I don't understand the correct syntax to make this connection, e.g., the DATASRC or SERVER option expectation.  

Tagged:

Best Answer

  • Nico Chart_21517
    Nico Chart_21517
    Altair Employee
    edited May 8 Answer ✓

    Hi Marc-Paul,

    The LIBNAME should look something like this:

    libname sf snowflake
      account='nc12340.eu-central-1'
      database='MY_SLC_DB'
      password='NicoC-1234'
      schema=TEST_SCHEMA
      user='nc001@altair.com'
      warehouse='MY_SLC_WH'
      authenticator=okta
      authenticator_url="https://dev-12345678.okta.com/home/snowflake/0oaq7jqpjmQwKQ01o1d7/"
    ;

    Please email us on dasupport@altair.com to create a support ticket and we can follow up in the ticket comments.

    Best Regards,
    Nico

Answers

  • Nico Chart_21517
    Nico Chart_21517
    Altair Employee
    edited May 8 Answer ✓

    Hi Marc-Paul,

    The LIBNAME should look something like this:

    libname sf snowflake
      account='nc12340.eu-central-1'
      database='MY_SLC_DB'
      password='NicoC-1234'
      schema=TEST_SCHEMA
      user='nc001@altair.com'
      warehouse='MY_SLC_WH'
      authenticator=okta
      authenticator_url="https://dev-12345678.okta.com/home/snowflake/0oaq7jqpjmQwKQ01o1d7/"
    ;

    Please email us on dasupport@altair.com to create a support ticket and we can follow up in the ticket comments.

    Best Regards,
    Nico

  • Marc-Paul Lee
    Marc-Paul Lee Altair Community Member
    edited May 8
    Nico Chart_21517 said:

    Hi Marc-Paul,

    The LIBNAME should look something like this:

    libname sf snowflake
      account='nc12340.eu-central-1'
      database='MY_SLC_DB'
      password='NicoC-1234'
      schema=TEST_SCHEMA
      user='nc001@altair.com'
      warehouse='MY_SLC_WH'
      authenticator=okta
      authenticator_url="https://dev-12345678.okta.com/home/snowflake/0oaq7jqpjmQwKQ01o1d7/"
    ;

    Please email us on dasupport@altair.com to create a support ticket and we can follow up in the ticket comments.

    Best Regards,
    Nico

    Thanks, Nico!  This is just what I needed, although the okta option for authenticator didn't work for me.  I changed it to "externalbrowser" and made the connection that way.  

    Now I have a slightly different problem.  Some of our schemas used lower case or mixed case names and the LIBNAME statement seems to default to upper case.  Is there any way to pass a lower case schema name with the LIBNAME statement?  

Categories