Connection to Snowflake?

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

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?