What are the different SQL queries which can be run for corresponding table and schema in Snowflake? – RChilli HelpDesk

Schema Name	Table	SQL query
SKILL_JOB	ABILITIES;	select *fromABILITIES;
	EDUCATION;	select *fromEDUCATION;
	EDUCATIONTYPE;	select *fromEDUCATIONTYPE;
	EDURELATEDJOBPROFILES ;	select *fromEDURELATEDJOBPROFILES;
	JOBPORFILESECTORRELATION;	select *fromJOBPORFILESECTORRELATION;
	JOBPROFILE;	select *fromJOBPROFILE;
	JOBPROFILEALIAS;	select *fromJOBPROFILEALIAS;
	KNOWLEDGE;	select *fromKNOWLEDGE;
	LANGUAGE;	select *fromLANGUAGE;
	MULTILANGJOBPROFILE;	select *fromMULTILANGJOBPROFILE;
	MULTILANGJOBPROFILEALIAS;	select *fromMULTILANGJOBPROFILEALIAS;
	MULTILANGSKILL;	select *fromMULTILANGSKILL;
	MULTILANGSKILLALIAS;	select *fromMULTILANGSKILLALIAS;
	NOCDETAIL;	select *fromNOCDETAIL;
	NOCJOBPROFILEMAP;	select *fromNOCJOBPROFILEMAP;
	NOCTITLE;	select *fromNOCTITLE;
	PROFICIENCYLEVEL;	select *fromPROFICIENCYLEVEL;
	RCHILLISECTORS;	select *fromRCHILLISECTORS;
	RCHILLISUBSECTORS;	select *fromRCHILLISUBSECTORS;
	RELATEDJOBPROFILE;	select *fromRELATEDJOBPROFILE;
	RELATEDSKILLS;	select *fromRELATEDSKILLS;
	SKILL;	select *fromSKILL;
	SKILLALIAS;	select *fromSKILLALIAS;
	SKILLRELATIONTYPE;	select *fromSKILLRELATIONTYPE;
	SKILLSECTORRELATION;	select *fromSKILLSECTORRELATION;
	SKILLTYPE;	select *fromSKILLTYPE;
	TASKS;	select *fromTASKS;
	WORKACTIVITIES;	select *fromWORKACTIVITIES;
SKILL	SKILL	select *fromSKILL;
SKILL	SKILLALIAS	select *fromSKILLALIAS;
JOB_PROFILES	JOBPROFILE	select *fromJOBPROFILE;
JOB_PROFILES	JOBPROFILEALIAS	select *fromJOBPROFILEALIAS;
GEOLOCATION	GEOLOCATIONS	select *fromGEOLOCATIONS;
EDUCATION_INSTITUTE	EDUCATIONINSTITUTE	select *fromEDUCATIONINSTITUTE;
EDUCATION_INSTITUTE	INSTITUTEALIAS	select *fromINSTITUTEALIAS;
EDUCATION_DEGREE	EDUCATION	select *fromEDUCATION;
EDUCATION_DEGREE	EDUCATIONALIAS	select *fromEDUCATIONALIAS;
POSTAL_CODE	POSTALCODE_COUNTRYISO	select *fromPOSTALCODE_COUNTRYISO;
POSTAL_CODE	POSTALCODE_ZIP	select *fromPOSTALCODE_ZIP;

Note:

Related articles