Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

How Data Query created in Data Builder stored?

Reply
Occasional Contributor
Posts: 12

How Data Query created in Data Builder stored?

How data query is stored internally. Is this stored as metadata or stored as query/code at particular location?

 

 

 

 

Regular Contributor
Posts: 196

Re: How Data Query created in Data Builder stored?

[ Edited ]

Hello Vivek,

 

Please refer the below link,

 

http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#p1eetf3dmyzgf4n1cngxq...

 

Hope this helps.

 

Thanks & Regards,

Teja Surapaneni

SAS Super FREQ
Posts: 384

Re: How Data Query created in Data Builder stored?

Query information is stored in metadata and also in the SharedServices database. See the SAS(R) 9.4 Intelligence Platform: Middle-Tier Administration Guide for more information about the database.

http://support.sas.com/documentation/cdl/en/bimtag/68217/HTML/default/viewer.htm#p1wm2vva6wgsynn11oa...

 

 

Occasional Contributor
Posts: 12

Re: How Data Query created in Data Builder stored?

Thanks Madelyn information is really helpful . I was facing issue as I was upading source metadata but query doesn't adapt accordingly and was using old values (i.e label for existing column used in query) but new columns when used from same source table used latest updated metadata value (i.e label in this case).

 

I could see Query stored as transformation object but was not able to trace other details .

 

Thanks for information.

 

 

Post a Question
Discussion Stats
  • 3 replies
  • 285 views
  • 0 likes
  • 3 in conversation