topic LASR table name standards in SAS Visual Analytics

LASR table name standards

L2Fly — Thu, 26 Apr 2018 22:51:22 GMT

Hello everyone, I am in process of loading our first set of datasets into LASR tables from our SQL Server registered tables library. I have been watching some of SAS video's and based on my reading on some of the blogs mostly adding and LASR extension to the name of LASR. For example if my table name called T_Employee in LASR they name it T_Employee LASR. Is there any reason for it and if I don't use a LASR would it be an issue in the future?

Thank you for your assistant

Re: LASR table name standards

SASKiwi — Thu, 26 Apr 2018 23:11:11 GMT

Personally I can't see the point of renaming a table when loading it into LASR. Adding LASR as a suffix on LASR table name looks completely redundant to me as you can identify all LASR tables by the SAS library they are in.

We have a practice of preparing our LASR tables in a normal SAS library first, which we refer to as our LASR Staging library. Then we keep exactly the same table names when we load them into LASR. To me this a simple and obvious approach - changing table names unless there is a good business reason seems pointless. I can understand you would want to have different names if the table contents were different, for example if you were doing update-type loads rather than replacement-type loads, but if your load and LASR tables are identical I suggest keeping the names the same is good practice.

Re: LASR table name standards

L2Fly — Thu, 26 Apr 2018 23:25:30 GMT

Thank you @SASKiwi for your help and info. Much appreciated, the way I have ours setup is to using ODBC library straight to our DW and registered all of tables we want users to access from EG or SAS Studio. Then based on the business requirement I am moving some of these tables into LASR to be used by our users in visual analytics. I am assuming you "your LASR staging" is the same as my ODBC library.

Again thanks for the info.