A program to recognize and reward our most engaged community members
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.
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?
