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
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.
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.
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.