Bulkload data from sas to snowflake using sas connector (Invalid option name BL_INTERNAL_STAGE)

[Krushik]

Usecase: I want to push data from SAS to user stage.
Problem: bl_internal_stage is not working
When I try to execute the following query , bl_internal_stage is not working

15       LIBNAME snowkipi ODBC datasrc='snow_db_kipi'

16       user='XXXXXXXXXXX'

17       password=XXXXXXXXXXX

18       schema='landing'

19      bulkload=yes bl_internal_stage="user/XXXXXXXXXXX";

                     -----------------

                     22

ERROR: Libref SNOWKIPI is not assigned.

ERROR: Error in the LIBNAME statement.

ERROR 22-7: Invalid option name BL_INTERNAL_STAGE.

[s_lassen]

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.

[LinusH]

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.