Hi  I am trying to follow this and read files in S3 bucket using the capability of Athena  but facing issues. The files in S3 are in multipart parquet format.  Here in this example you have created a table and reading that from SAS, which i understand . however in my case reading a table having parquet format files are not working. Do you have any idea on how to get this working please?. It complains about the below error ERROR: Prepare error: [Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. SYNTAX_ERROR: line 1:15: Schema ******** does not exist SQL statement: SELECT * FROM *******._ACTIVITY The database and schema definitely exists as i can query from AWS Athena. I am able to successfully establish the connection using the JDBC driver.  NOTE: Libref ATHENA was successfully assigned as follows: Engine: JDBC   Any info on how to fix this would be very helpful and much appreciated. ... View more

Hi    I am trying to follow this and read files in S3 bucket using the capability of Athena  but undergoing issues. The files in s3 are in multipart parquet format.   Here in this example you have created a table and reading that from SAS, which i understand . however in my case reading a table having parquet format files are not working. Do you have any idea on how to get this working please?. it complains about the below error ERROR: Prepare error: [Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. SYNTAX_ERROR: line 1:15: Schema ******** does not exist SQL statement: SELECT * FROM *******._ACTIVITY The database and schema definitely exists as i can query from AWS Athena. I am able to successfully establish the connection using the JDBC driver.  NOTE: Libref ATHENA was successfully assigned as follows: Engine: JDBC   Any info on how to fix this would be very helpful and much appreciated.       ... View more

Hi   It is a very good article. I want to know if we can create job dependency and job controls within the job definition file say for ex?   filename job filesrvc folderpath='/path' filename='prog1.sas'; %include job / source; some controls like syserr etc? and if only no error in pervious step , proceed. filename job filesrvc folderpath='/path' filename='prog2.sas'; %include job / source;   is this possible? ... View more

Thanks Gerry  How is other way round?. like promoting from 3.5 to 3.4 . are VA reports backward compatible?.     ... View more

Thanks Gerry   I checked the blog , useful , but the pic in the picture dont have 3.5 mentioned.  We are not able to promote reports from 3.4 to 3.5.  We get this error " SAS Visual Analytics - An error was encountered loading the report".If it is definitely possible then will explore more or raise a tracker with tech support. ... View more

Hi    We have upgraded sas viya dev form 3.4 to 3.5.but not prod.  Dev test is in progress. Now we have to promote some contents ( VA reports ) to prod  which is not working due to different versions. Is there any way to promote contents from 3.4 to 3.5  without any issues or are there any steps that is required to migrate the reports seamless. ... View more

Thanks Uttam. I created a global caslib library using the below code not from ENV manager caslib ds PATH="/opt/sas/casdata/ds" TYPE=path SESSREF=casauto  GLOBAL SUBDIRS;   what is happening is when i use the same path to create a new caslib after dropping this caslib it is not allowing , not sure why.  Different path with the same caslib reference works though. I have to do this though in the end. ... View more

Hi    I have created a global caslib and i am now not able to delete that from ENV manager. Also i dont see this lib reflecting in the library list. i can see other cas libs both global and session scope.   I get this error when i try to create a new caslib using the path or with the same name. i need to as to match with prod. The caslib *** is a duplicate, parent or subpath of caslib New Connection.   How can i drop/delete a global scope library programatically as i dont have cas server monitor. I dont think that is enabled in our env. ... View more

Thanks Patrick   I am using in SQL pass-through  that works as expected and when new users come in we dont need to educate them with this option if this is set globally on the server as system option that was my intention.   ... View more

Hi, Thanks for the information.  How do i set this option up a system option as I dont find the right information on where to set this as system option in sas viya.  ... View more

Thanks all for the information. very surprised as this SAS link details on enabling XCMD in viya 3.4 https://go.documentation.sas.com/?docsetId=calsrvpgm&docsetTarget=n00003viyaprgmsrvs00000admin.htm&docsetVersion=3.4&locale=en   So we would be able to use XCMD on compute only or we can run OS commands on other servers  like control and worker nodes once this is enabled?   What I am trying to achieve is if i am able to run some system commands  on all the servers(like compute , cntrl and worker nodes) from SAS studio in same session. say checking memory or how many processes are running and using the information in scripts.  I feel sometimes this would be handy instead of opening ENV manager and looking visually. ... View more

We are using sas viya 3.4 and couldnt get this working by adding the changes to the spawner_usermods.sh.   Do we need to do any changes to the cntrl server or just comp server will do? ... View more

DBCLIENT_MAX_BYTES=1 wondering how can we use this option in pass-thorugh or set up as a system option if in case dont want to change existing scripts. ... View more