As far as I can see the SAS/ODBC connection does not support the bl_internal_stage option directly. But it may be possible to put it in the CONOPTS parameter, something like
conopts='bl_internal_stage="user/XXXXXXXXXXX"'
which may work. I do not have experience with the Snowflake ODBC donnection, though.
BL_INTERNAL:_STAGE is only supported in the SNOWFLAKE access engine.
I think this option is a SAS name, so I highly doubt that it could work in a connection options string.
The Snowflake ODBC driver supports specifying internal stage when using PUT. Not sure how make that work from a SAS libname though.
https://docs.snowflake.com/en/sql-reference/sql/put
If you plan to use Snowflake extensively from SAS I suggest you look into using the Snowflake ACCESS engine instead.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: